Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Using Logical Standby (SQL Apply) for near zero downtime upgrade of two node Oracle RAC database from 10.2.0.5 to 11.2.0.3 -Download

In the article you will have a look at an example of using a logical standby database, also known as SQL Apply, to perform a near zero downtime upgrade of a two node Oracle RAC database from version 10.2.0.5 to version 11.2.0.3. The two node cluster configuration is described here in detail. For the testing both primary and standby databases share the same Oracle GI cluster. Earlier I have upgraded the cluster to 11.2.0.3 and installed Oracle RDBMS 11.2.0.3 binaries on each node. In the article a physical standby database will be build and converted to a logical database that will be used for the upgrade. Each node has a separate non-shared $OH for the GI and RDBMS versions installed. The table below summarizes some environment details used in the article.

Download the article  Using Logical Standby (SQL Apply) database for near zero downtime while upgrading 2 node RAC database from 10.2.0.5 to 11.2.0.3_1 or read online from here

June 26, 2012 Posted by | oracle | 3 Comments

Using Logical Standby (SQL Apply) for near zero downtime upgrade of two node Oracle RAC database from 10.2.0.5 to 11.2.0.3

Using Logical Standby (SQL Apply) for near zero downtime upgrade of two node Oracle RAC database from 10.2.0.5 to 11.2.0.3

In the article you will have a look at an example of using a logical standby database, also known as SQL Apply, to perform a near zero downtime upgrade of a two node Oracle RAC database from version 10.2.0.5 to version 11.2.0.3. The two node cluster configuration is described here in detail. For the testing both primary and standby databases share the same Oracle GI cluster. Earlier I have upgraded the cluster to 11.2.0.3 and installed Oracle RDBMS 11.2.0.3 binaries on each node. In the article a physical standby database will be build and converted to a logical database that will be used for the upgrade. Each node has a separate non-shared $OH for the GI and RDBMS versions installed. The table below summarizes some environment details used in the article.

Continue reading

June 26, 2012 Posted by | oracle | 1 Comment

Oracle Virtualization – Installing Oracle VM Server 3.1.1, Oracle VM Manager 3.1.1 and Deploying Oracle RAC 11gR2 (11.2.0.3) Oracle VM templates Linux x86 64 bit for test configuration

Oracle Virtualization – Installing Oracle VM Server 3.1.1, Oracle VM Manager 3.1.1 and Deploying Oracle RAC 11gR2 (11.2.0.3) Oracle VM templates Linux x86 64 bit for test configuration

In the second post, first is here, for Oracle VM 3.1.1 technology you will look at how to upgrade the existing Oracle VM server and Oracle VM manager to version 3.1.1 and deploy Oracle RAC templates to build two node Oracle 11gR2 (11.2.0.3) cluster.

All software can be downloaded from edelivery.oracle.com (Oracle Software Delivery Cloud) and the templates (version 11.2.0.3) can be downloaded as a patch from MOS (patch 12694014. The approach described in the article is applicable on any supported platform although I am using Oracle VirtualBox for testing.
Continue reading

June 20, 2012 Posted by | oracle | 20 Comments

Oracle Virtualization – Installing Oracle VM Server 3.0.3, Oracle VM Manager 3.0.3 and Deploying Oracle RAC 11gR2 (11.2.0.3) Oracle VM templates Linux x86 64 bit for test configuration

Oracle Virtualization – Installing Oracle VM Server 3.0.3, Oracle VM Manager 3.0.3 and Deploying Oracle RAC 11gR2 (11.2.0.3) Oracle VM templates Linux x86 64 bit for test configuration

In two posts I will cover Oracle VM server 3.0.3 and 3.1.1 technology; the first (this one) will be dedicated to 3.0.3 and the second (next one)to 3.1.1. Oracle provides virtualization software ranging from bare metal implementations based on Oracle VM Server to a Microsoft Windows/Linux/Mac OS and Solaris deployments based on Oracle Virtual Box. Oracle VM Manager facilitates management of Oracle VM Server. In this article you will look at the installation of Oracle VM server 3.0.3 and Oracle VM Manager 3.0.3 on Oracle VirtualBox and in addition I will provide guidelines for deploying Oracle RAC 11gR2 (11.2.0.3) Oracle VM templates Linux x86 64 bit for test configuration using Oracle VM Manager. For information relating to earlier Oracle VM server 2.2.1 deployment with RAC templates click here. All software can be downloaded from edelivery.oracle.com (Oracle Software Delivery Cloud) and the templates (version 11.2.0.3) can be downloaded as a patch from MOS (patch 12694014). The approach described in the article is applicable on any supported platform although I am using Oracle VirtualBox for testing. Bear in mind that contrary to Oracle VM server 2.2.1 in Oracle VM Server 3.0.3 YOU WILL NOT BE ABLE to have RAC templates deployed in Virtual box environment due to Oracle VM 3.0.3 dmidecode requirement that VirtualBox does not comply. I will show briefly guidelines for a successful RAC template deployment after Oracle VM Server 3.0.3 and Oracle VM Manager are installed. In the next post I will present a detail steps by step guide for RAC templates deployment using Oracle VM server 3.1.1 and Oracle VM Manager 3.1.1.
Continue reading

June 19, 2012 Posted by | oracle | 4 Comments