Author Archives: TJ

Home »  Author: TJ

Converting SE RAC Database to EE RAC Database !!!

On October 5, 2013, Posted by , In ORACLE, By ,, , With 2 Comments

In this article I will show you the steps of converting SE RAC database to EE RAC database. You are using a Standard Edition (SE) database and want to convert it to the Enterprise Edition (EE) because functionality you require is not part of the SE. Since the same “SQL.BSQ”…

Dataguard configuration in 11gR2 Standard Edition !!!

On October 4, 2013, Posted by , In 11g, By , , With 3 Comments

In this article, I will show you the steps for Dataguard configuration in 11gR2 Standard Edition. As all of you must be knowing that dataguard is not available in Standard Edition. To have the Dataguard option, we require an Enterprise Edition. But still there is a way to configure Dataguard in Standard Edition,…

Dataguard configuration in 11gR2 Enterprise Edition !!!

In this article, I will show you the steps for Dataguard configuration in 11gR2 Enterprise Edition. I have another post showing Dataguard configuration using “duplicate target database for standby from active database” command. Here we will create the standby database by restoring the RMAN Backup on standby. Before proceeding, I assume here…

Ethernet or Network Bonding in Linux !!!

On June 16, 2013, Posted by , In LINUX, By ,,, , With Comments Off on Ethernet or Network Bonding in Linux !!!

In this article, we will see how to do bonding of two or more physical network interfaces together to look and act as a single interface in Linux.Ethernet or network bonding in Linux is used in a ‘fail-over’ setup, where if one cable dies, the kernel will automatically switch to using…

Restore as single instance DB and convert to RAC DB !!!

On February 26, 2013, Posted by , In ORACLE, By , , With No Comments

For this article, we have taken a RMAN backup of an existing 10g RAC database. There is another 10g RAC cluster on which we will restore this backup. We will restore RMAN backup as single Instance database and then convert it to RAC database by adding instances to the cluster configuration. Similarly, you…

Change Existing Hostnames in 10g RAC cluster !!!

Recently we wanted to upgrade an Oracle 10g (10.2.0.5) RAC database having ASM storage to higher version i.e. Oracle 11gR2 (11.2.0.3). While checking the prechecks for the upgradation, we noticed that the 10g RAC Cluster was configured using the hostnames having ‘_’ in their names. The private and virtual hostnames were…

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…