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 # link the oracle libraries $ cd $ORACLE_HOME/rdbms/lib $ make -f … Continue reading How to build oracle with RAC off/on?

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 <database name> -i <instance name> To shutdown the instance: # … Continue reading How to start/stop an instance on a RAC?

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 install. If you have any problems with these scripts please … Continue reading 10g RAC: How to Clean Up After a Failed CRS Install

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 or follow instruction on note 208375.1 Some of the steps … Continue reading How to migrate from single instance to RAC 10gR2