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 :-
Continue reading SQL*Plus Preliminary connection (Oracle 10g and above) »
Upgrade steps for Oracle DB from 11.2.0.1 to 11.2.0.2 :
(1) Make sure you have taken level 0 database backup.
(2) Ensure that 11.2.0.2 (out-of-place) rdbms binary has been installed in new home e.g. /usr/oracle_gxs2/oracle/product/11.2/db_1.
(3) Please refer to Metalink / My Oracle Support document 1201253.1 to check for DST update action. In this scenario, we assume that no application schema object using datatype TSLTZ or TSTZ, hence no action on DST required.
Continue reading Upgrading Oracle Database from 11.2.0.1 to 11.2.0.2 »
Upgrade Oracle Grid Infrastructure patchset to 11.2.0.2, follow the steps below:
(1) Unset all GI, CRS and RDBMS related environment variable.
For example: ORA_CRS_HOME, ORACLE_HOME, ORA_NLS10, TNS_ADMIN ..
(2) Goto extracted GI files and run “runInstaller”
Continue reading Upgrade Oracle Grid Infrastructure patchset 11.2.0.2 from 11.2.0.1 (Part 2) »