Oracle 11gR2 – clean up after failed database install

So your Oracle database install crashes and burns and you are left with a mess to clean up.

Oracle now provides some canned de-install scripts to try to do this for you, but in my experience they are about as useful as a chocolate teapot.

First, let’s verify where Oracle did the install.  Check the oraInst.loc file in the /etc directory:

Continue reading

Oracle 11gR2 RAC install – installer hangs at 65%

During the install of Oracle 11gR2 RAC Grid, the installer hangs at 65%, with no errors on screen or in the log file.

The problem is the Linux firewall interfering with the install.

Before running the runInstaller script, make sure the firewall is disabled on ALL nodes. Connect as root and disable it as follows:

[root@tbird1 ~]# service iptables stop
Flushing firewall rules: [  OK  ]
Setting chains to policy ACCEPT: filter [  OK  ]
Unloading iptables modules: [  OK  ]

 

To make sure it stays permanently disabled use the following:

[root@tbird1 init.d]# chkconfig iptables off

Oracle 11gR2 RAC Install – cleaning up a failed install on Linux

Despite all the updates to the Oracle RAC installer, it is still an extremely brittle install process that frequently goes pear shaped.

A common problem is pilot-error, and a regular mistake is running the root.sh script on secondary nodes before it has fully completed on the primary node.

Oracle now provides the rootcrs.pl script in the Grid home crs/install directory.

To execute the script, connect to your first node and execute as follows:

Continue reading