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
-----------------------------------------------------------------
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
----------------------------------------
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
-----------------------------------------------
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
------------------------------------------------------------------------------------------------------------------