Blogs

Upgrade 10gR2 RAC to 11gR2 RAC on RHEL Server !!!

In this article we will see how to upgrade Oracle Clusterware, ASM and Database from 10gR2 [10.2.0.5] RAC to 11gR2 [11.2.0.3] RAC. The current 10gR2 RAC database configuration is as below, • OS: RHEL 5.8 • Oracle User: oracle • Grid User: grid • Oracle Home: /u01/app/oracle/products/10.2.0/db • Grid Home:…

Configure iSCSI Disks using NetApp Ontap Simulator !!!

In this post we will first configure NetApp Ontap 8.1 Simulator using VMWare Workstation. Then we will configure iSCSI disks using the NetApp Ontap Simulator. We will be using the 7-mode for this article.   Once you have downloaded the Ontap Simulator setup, unzip the file and extract it to…

Convert Single Instance DB to RAC DB using rconfig utility !!!

In this article, we will look at the steps to convert a single instance 11gR2 database to 11gR2 RAC database using rconfig utility. In $ORACLE_HOME/assistants/rconfig/sampleXMLs directory, there are two templates ConvertToRAC_AdminManaged.xml and ConvertToRAC_PolicyManaged.xml that are used to convert a single instance database to RAC admin managed or policy managed database respectively. In this article we…

Recover Standby Database Using RMAN Incremental Backup !!!

In this article, we will show the steps that can be used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive log files gap. ======================================================================================================   Below are the steps to perform a Rolling forward for standby database using…

OEM 12c Cloud Control Installation in RHEL !!!

On July 25, 2012, Posted by , In 12c, By , , With No Comments

In this article, we assume that you have already configured an Oracle 11gR2 (11.2.0.3) database. Below are the details of the system that we will be using for OEM 12c installation. Hostname – oem12c Database Name – oem Database Version – 11.2.0.3 ======================================================================================================   Preinstallation Requirements for Oracle Enterprise Manager…

Deleting a Node from 11gR2 RAC !!!

On July 22, 2012, Posted by , In 11g, By , , With No Comments

In this article, we will see the steps for deleting a node from 11gR2 RAC cluster. To delete a node we have to first remove the database instance, then the Oracle home and finally the grid infrastructure home. The cluster here is a 4 node Oracle 11gR2 RAC. Here the…

Configure iSCSI Disks using Openfiler !!!

On July 7, 2012, Posted by , In Others, By ,, , With 4 Comments

In this article, we will configure iSCSI disks using Openfiler software. We assume that the Openfiler Software has been already installed. The Openfiler version used here is openfiler-2.3 (64 bit). ======================================================================================================   – Start the below services to access Openfiler through web interface. # service httpd start # chkconfig httpd…

Oracle 11gR2 RAC installation on RHEL 5.8 !!!

On June 30, 2012, Posted by , In 11g, By , , With 9 Comments

In this article, I am going to configure a four node Oracle 11gR2 RAC cluster, all nodes running RHEL 5.8-64 bit. The network storage server will be configured as an iSCSI storage device for all Oracle Clusterware and Oracle RAC shared storage requirements using Openfiler release 2.3 (64 bit). We…

Snapshot Standby Database Feature in 11gR2 !!!

Snapshot Standby is a new feature introduced in 11gR2 that allows the standby database to be opened in read-write mode. When switched back into standby mode, all changes made whilst in read-write mode are lost. This is achieved using flashback database, but the standby database does not need to have…

Oracle 11gR2 DB Installation on RHEL using ASM !!!

In past releases, Oracle ASM was installed as part of the Oracle Database installation. With Oracle Database 11g Release 2 (11.2), Oracle ASM is installed when you install the Oracle Grid Infrastructure components and shares an Oracle home with Oracle Clusterware when installed in a cluster such as with Oracle…