January 30 2011

Oracle RAC 11.1.0.6.0 installation on AIX 6.1 Java issue.

Tagged Under : ,

Before start oracle RAC 11.1.0.6.0 installation on AIX 6.1 platform, you are require to install JDK to fix the Bug 9216848.

During the installation, on the “Select Installation Type”, pick the “Minimum” ratio button.

After JDK installed, you can continue to install oracle clusterware software and oracle rdbms software.

January 28 2011

Oracle : Determine PSU (Patch Set Update) Version

Tagged Under : , , ,

Reference to Metalink Doc 861152.1, to determine PSU version installed in your Oracle Home :-

1) Ensure that opatch version is having version of at least / or higher than :-

10.2.0.4.5 for version 10gR2 Oracle Home

11.1.0.6.5 for version 11gR1 Oracle Home

11.2.0.1.0 for version 11gR2 Oracle Home

January 26 2011

SQL*Plus Preliminary connection (Oracle 10g and above)

Tagged Under : , , ,

For certain incident when even DBA / SYSDBA user can’t log-on, note that in 10g and above, there’s a lightweight sqlplus connection introduced. It’s called “preliminary connection”.

Two method to establish the preliminary connection in sqlplus :-