Blogs

Prechecks for Oracle 11gR2 RAC installation on Solaris 10 !!!

In this article, we will be doing prechecks for Oracle 11gR2 RAC installation on Solaris 10. ======================================================================================================   Here I have installed Solaris on two nodes using ZFS filesystem. Below are the prechecks that need to be completed before we start the Oracle RAC installation. • Configure Public IP address…

Restore DB using RMAN and then change DB name using NID !!!

In this article, we will restore DB using RMAN and then change DB name using NID utility. Here we will be restoring database “orcldb” on a new server and then will change the DB name to “homedbs”. ======================================================================================================   • Copy init.ora file to $ORACLE_HOME/dbs dir and make appropriate changes…

Manually Create Database in Oracle !!!

In this article I will show you the steps to manually create Database in Oracle. We will use the CREATE DATABASE sql statement for this. After the database is created, we have to manually build the views on the data dictionary tables and install PL/SQL packages using scripts. ======================================================================================================  …

Configure NFS Disks using NetApp Ontap Simulator !!!

In this post we will only see the steps to configure NFS disks using NetApp Ontap Simulator 8.2. We will be using the 7-mode for this article. For this article I have already configured a NetApp Filer with extra disks If you want to configure the NetApp Ontap Simulator from…

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…