Cleaning up a failed Oracle 11g grid infrastructure install.

Unfortunately, the installer or more specifically the root.sh script for the Oracle 11g grid (Clusterware) installer can be very flaky.   If it fails and you need to fix something or rerun it for any reason, it will fail the next time if you have not cleaned up the install by de-configuring CRS. I also …

Read more

Manually upgrading to 11g

You can directly upgrade an Oracle database from version 9.2.0.4 or higher, directly to 11g Upgrade Process. Open database in Upgrade mode:      startup upgrade Pre-Upgrade information tool:      utlu111i.sql Precursor to the upgrade. Generated report on required  and recommended changes to make.. Generally increasing tablespace sizes or remove parameters. Upgrade script:   …

Read more