Posts

Showing posts with the label Oracle Upgrade 11gR2

Resolving Problems in Mixed-Database Environments in a 11gR2 Clusterware

Oracle 11.2 fully supports continuing to use non-11.2 databases on a cluster that has been upgraded to 11.2. However, you should be aware that the Oracle 11.2.0.1 base release contained a number of problems that could affect users with a 10.2 database. Known problem with brand new installations of Grid Infrastructure 11.2 and pre-11.2 RDBMS instances is related to node pinning. During the upgrade, the nodes containing 10.2 RDBMS software will be pinned, allowing pre-11.2 databases to run on them. Important aspect is with Non-upgraded clusters are not automatically pinned, which causes problems with emca and dbca when executed from the pre-11.2 Oracle homes. You should use the utilities from the $GRID_HOME to manage resources provided by the same Oracle home. Similarly, when managing pre-11.2 resources, you can use the commands from their respective homes. This is a golden rule to remember You can find more information about problems with 10.2 databases and 11.2 Grid Infras...

Upgrade the standby dataguard ASM structure to Oracle 11gR2.: Upgrade ASM to 11gR2

Image
Oracle 11gR2 is out for Linux, and I decided to upgrade one of my existing 11.1.0.6 database with ASM to 11.2.0.1. Direct upgrade to 11gR2 is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher and 11.1.0.6 or higher. If you have a database 9.2.0.6 then first you need to upgrade to intermediate release i.e 9.2.0.8 then to 11.2.0.1.     9.2.0.6==>9.2.0.8==>11.2.0.1     8.1.7.0==>8.1.7.4==>10.2.0.4==>11.2.0.1 I will show a upgrade of an existing Single Instance 11.1.0.6 database with ASM, having same ORACLE_HOME, to Oracle 11gR2 with ASM. The Oracle environment is a Dataguard structure bases on 11.1.06 with ASM. The new situation will be one ASM instance with 11.2 and Oracle instance 11.1.0.6 The upgrade needs to be performed in two phases: Done       1. Upgrade the ASM instance of one of the DG’s Pending   2. Upgrade the other ASM instance of the DG ...