How to build oracle with RAC off/on?

On 10R2 if the Oracle binaries are installed with the RAC, one can’t use those binaries to start Oracle Instance if CRS is not running, so in case when one needs to start the instance without CRS one needs to rebuild the oracle and it’s libraries to start the instance. To turn off RAC #…

How to start/stop an instance on a RAC?

To start the instance: # check status of instance $ $CRS_HOME/bin/crs_stat # seen cases when CRS says OFFLINE but pmon is still running so double checking here $ ps -ef | grep <instance_name> | grep pmon # start one of the instance on one of the nodes if not running $ srvctl start database -d…

10g RAC: How to Clean Up After a Failed CRS Install

Not cleaning up a failed CRS install can cause problems like node reboots. Follow these steps to clean up a failed CRS install: 1. Run the rootdelete.sh script then the rootdeinstall.sh script from the $ORA_CRS_HOME/install directory on any nodes you are removing CRS from. Running these scripts should be sufficent to clean up your CRS…

How to migrate from single instance to RAC 10gR2

Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there is enough space for the new online redo logs for new nodes 4- Make modifications to the pfile for RAC configuration 5- Add the listener configurations to tnsnames file in both nodes 6- Run rconfig…