Flowers To India

Flowers To India
Send cakes,flowers to India

Thursday, November 21, 2013

REP-0177: Error while running in remote server Executed successfully but there were some errors when distribute the output.

REP-0177: Error while running in remote server
Executed successfully but there were some errors when distribute the output.

Oracle AS Error:

We got the error while sending Oracle Report output by Email by using "rwclient".

REP-0177: Error while running in remote server
Executed successfully but there were some errors when distribute the output.

  Solution:

This was related to smtp settings on configuration file We need to add the below line in rwbuilder.conf and servicename.conf 
  pluginParam name="mailServer">mail.domain.com:25 pluginParam (need to put special charecters as per the example in therwbuilder.conf and servicename.conf )

-----------------------------------------------------------------

Send Gifts to India by http://amazegifts.com

Gifts To India 

-----------------------------------------------------------------

Rman background process

Which Back ground Process RMAN Will use?


There is no special back ground proceses. Actually, when taking bakcup, it used job queue process for maitain the backup job as well as dbwriter will help to retrieve the data to buffer.

Which buffer pool RMAN will use for backup? 

large pool

If large pool is not available which Buffer pool  RMAN will use?

Shared Pool

---------------------------------


Send Gifts to India by http://amazegifts.com

Gifts To India 

----------------------------------------

How to apply CPU patch

How to apply CPU patch

How to Apply SPU Patch

CPU Patch Apply Procedure:

Before applying the patch make sure all backups are in place.
cpu patch location on server1
/opt/oracle/July2010/9655017

Step 1) take the below commands outputs. 
SQL>select name from v$database;
SQL>select * from registry$history;
SQL>select * from v$version;
SQL>select * from dba_registry_history;
SQL>select count(1) from dba_objects where status like 'I%';
SQL>SELECT OBJECT_NAME,OBJECT_TYPE,owner FROM DBA_OBJECTS WHERE STATUS= 'INVALID';
$cd $ORACLE_HOME/OPatch
$opatch version
$opatch lsinventory

Step 2) Shut down the database & stop the listener.
Step 3) check the iventory path and make sure the inventory path should be point correct inventory.

Step 4) use below commands and take the home and inventory backups.
cd /oracle10g/PRDRCD1/product/10.2
tar cvf - .|gzip -c > /path/back_home/
home_dbname_`hostname`_`date +%Y%m%d`.tar.gz
cd /inventorypath/product/10.2/
inventory
tar cvf - .|gzip -c > /path/
oraInvent_dbanem_`hostname`_`date +%Y%m%d`.tar.gz

Step 5)take the OPatch backup.
cd $ORACLCE_HOME
cp OPatch OPatch_bak

Step 6) unzip the p6880880_102000_SOLARIS64.zip under ORACLE_HOME

Step 7) go to CPU patch directory and apply the CPU patch
cd /opt/oracle/July2010/9655017
export PATH=$PATH:/usr/ccs/bin
export PATH=$ORACLE_HOME/
OPatch:$PATH:.
opatch version
opatch napply -skip_subset -skip_duplicate

Step 8) Run catbunle.sql
cd $ORACLE_HOME/rdbms/admin
sqlplus /'as sysdba'
startup
@catbundle.sql cpu apply

Step 9) run the utlrp.sql

Step 10) excute the below statement
SQL>SELECT * FROM registry$history where ID = '6452863';
if that statement returns no rows please execute below commands
$cd $ORACLE_HOME/cpu/
view_recompile
$sqlplus /'as sysdba'
SQL>@recompile_precheck_jan2008cpu
.sql
sql>shut immediate
startup upgrade
@view_recompile_jan2008cpu.sql
shut immediate

startup
@utlrp.sql

10) perform 1st step for taking patch information.
-----------------------------------------------

Send Gifts to India by http://amazegifts.com

Gifts To India

 -----------------------------------------------

Possible port conflict on port(3872): Retrying the operation...

Oracle Grid agent Error:

emctl start agent

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.

Starting agent ..................... failed.

HTTP Listener failed at Startup

Possible port conflict on port(3872): Retrying the operation...

Failed to start the agent after 1 attempts. Please check that the port(3872) is available.

Consult emctl.log and emagent.nohup in: /oracle/app/12c_agent1/agent_inst/sysman/log

 Solution:

So check whether any other application is using the port 3872 by using below command and take action accordingly.
netstat -Aan |grep 3872
 (Or)
Chang "ListenOnAllNICs=false" in emd.properties.
 ----------------------------------------------------------------------------------------------------------------

Send Gifts to India by http://amazegifts.com

Gifts To India 

------------------------------------------------------------------------------------------------------------------