LISTENER:
You must administer the listener by using the
Upgrade DBUA : automatically migrates the listener from your old Oracle home to the new Oracle Grid Infrastructure 11g Release 2 home.
Manual Upgrade : First remove old listener from old Oracle home and then run NETCA from grid home to create new
ASM : Check if ASM is used select count(*) from v$asm_client where status = 'CONNECTED';
Oracle ASM is upgraded as part of the Oracle Grid Infrastructure upgrade.
You cannot upgrade Oracle ASM before you upgrade Oracle Grid Infrastucture.
Before installing 11.2.0.3 software , root script invokes ASMCA to upgrade Oracle ASM to release 11.2.0.3
ASM and Oracle Clusterware must run in the same Oracle Grid Infrastructure home.
Database compatibility attribute for Oracle ASM disk groups matches the compatibility parameter that is set in
It is necessary to add a user and password combination to the password file when upgrading the Oracle ASM instance to the password file that is local to a node's Oracle ASM instance CREATE USER user_name IDENTIFIED BY password;
.
HOME : Oracle Grid Infrastructure and Oracle Database software will have new ORACLE HOMES instead of the existing Oracle home.ASM and Oracle Clusterware must run in the same Oracle Grid Infrastructure home.
Read-Only and Offline Tablespaces : No action required during upgrade
Time Synchronization : USe OS NTP or oracle Cluster Time Synchronization Service
Standby Databases : Through the use of the new
You must administer the listener by using the
lsnrctl command in
the Oracle Grid infrastructure home and not from Oracle DB homeUpgrade DBUA : automatically migrates the listener from your old Oracle home to the new Oracle Grid Infrastructure 11g Release 2 home.
Manual Upgrade : First remove old listener from old Oracle home and then run NETCA from grid home to create new
ASM : Check if ASM is used select count(*) from v$asm_client where status = 'CONNECTED';
Oracle ASM is upgraded as part of the Oracle Grid Infrastructure upgrade.
You cannot upgrade Oracle ASM before you upgrade Oracle Grid Infrastucture.
Before installing 11.2.0.3 software , root script invokes ASMCA to upgrade Oracle ASM to release 11.2.0.3
ASM and Oracle Clusterware must run in the same Oracle Grid Infrastructure home.
Database compatibility attribute for Oracle ASM disk groups matches the compatibility parameter that is set in
init.ora.It is necessary to add a user and password combination to the password file when upgrading the Oracle ASM instance to the password file that is local to a node's Oracle ASM instance CREATE USER user_name IDENTIFIED BY password;
.
HOME : Oracle Grid Infrastructure and Oracle Database software will have new ORACLE HOMES instead of the existing Oracle home.ASM and Oracle Clusterware must run in the same Oracle Grid Infrastructure home.
Read-Only and Offline Tablespaces : No action required during upgrade
Time Synchronization : USe OS NTP or oracle Cluster Time Synchronization Service
Standby Databases : Through the use of the new
KEEP IDENTITY clause option to the SQL
ALTER DATABASE RECOVER TO LOGICAL STANDBY statement, a physical
standby database can be temporarily converted into a logical standby database
for the rolling upgrade, and then reverted back to the original configuration of
a primary database and a physical standby database when the upgrade is done.