Archive for October, 2011

Sync your standby database with primary using RMAN if gap is excessive

October 14, 2011 Leave a comment

Useful document by Girish B. Wankhede and Ajinkya S. Halwalkar

recover standby database

Categories: Oracle

Recreate oraInventory (Central Inventory) in Real Application Clusters.

October 10, 2011 Leave a comment

When you execute opatch lsinventory -detail , the product and components within the Oracle Home are not listed. The cause could be missing or corrupted Oracle home inventory  

1-Locate the central inventory
cat /etc/oraInst.loc or /var/opt/oracle/oraInst.loc (Platform specific)

2-Take a back up of central inventory or rename in all the nodes.
mv oraInventory oraInventory.orig

3-cd $ORACLE_HOME/oui/bin

4-Execute runInstaller with attachHome option for OraCrsHome.

./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="<10g Ora_Crs_Home Path>" ORACLE_HOME_NAME="<Name of oracleCRSHome>" LOCAL_NODE='node1' CLUSTER_NODES=node1,node2 CRS=true

for ex:
./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oracle/product/10.2.0/crs_1" ORACLE_HOME_NAME="OraCrs10g_home" LOCAL_NODE='rac1' CLUSTER_NODES=rac1,rac2 CRS=true

5-Execute runInstaller with attachHome option for OraDbHome
./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="<10g Oracle_Home Path>" ORACLE_HOME_NAME="<Name of oracleHome>" LOCAL_NODE='node1' CLUSTER_NODES=node1,node2

for ex:
./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1" ORACLE_HOME_NAME="OraDb10g_home1" LOCAL_NODE='rac1' CLUSTER_NODES=rac1,rac2 
6-Verify the inventory creation in all the nodes.

7-Verify and compare XML files size inside oraInventory/ContentsXML across all the nodes.

Categories: Oracle Rac