Guenadi N Jilevski's Oracle BLOG

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

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box – Download

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box – Download

In the article you will have a look at how to use some Oracle Virtual Box features to build two node Oracle 12c (12.1.0.1) RAC system on Oracle Enterprise Linux (OEL 6.5). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid are used respectively in order to split the responsibilities between DBAs and storage administrators.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM Virtual Box to build a two node 11gR2 RAC cluster on Solaris 10 and Solaris 11. For information related to building a RAC 11gR2 cluster on OEL 5.X/6.X without GNS click here and here. For information how to build a two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP look here. For information how to upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 look here.

In the article you will see how to configure Linux in an Oracle VM Virtual Box Virtual machines, install Oracle GI, Oracle RDBMS and will create a RAC enabled Multitenant Container Database (CDB).

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

Two virtual machines will be created and used.

  1. OEL65A for RAC node oel65a
  2. OEL65B for RAC node oel65b

The OEL65A/OEL65B Virtual Machines will be configured for RAC nodes each with:

You can read online from here or download Build two node Oracle RAC 12c (12.1.0.1) on OEL 6

May 26, 2014 Posted by | oracle | Leave a comment

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box

Build two node Oracle RAC 12c (12.1.0.1) cluster on OEL 6.5 using Oracle VM Virtual Box

In the article you will have a look at how to use some Oracle Virtual Box features to build two node Oracle 12c (12.1.0.1) RAC system on Oracle Enterprise Linux (OEL 6.5). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid are used respectively in order to split the responsibilities between DBAs and storage administrators.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM Virtual Box to build a two node 11gR2 RAC cluster on Solaris 10 and Solaris 11. For information related to building a RAC 11gR2 cluster on OEL 5.X/6.X without GNS click here and here. For information how to build a two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP look here. For information how to upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 look here.

In the article you will see how to configure Linux in an Oracle VM Virtual Box Virtual machines, install Oracle GI, Oracle RDBMS and will create a RAC enabled Multitenant Container Database (CDB).

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

Two virtual machines will be created and used.

  1. OEL65A for RAC node oel65a
  2. OEL65B for RAC node oel65b

The OEL65A/OEL65B Virtual Machines will be configured for RAC nodes each with:
Continue reading

May 26, 2014 Posted by | oracle | 8 Comments

Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 – Download

Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5 – Download

In the article you will have a look at the guidelines and steps to upgrade an Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL 6.5. The initial cluster configuration (Oracle 11.2.0.3 on OEL 6.1) is described here. The upgrade comprises the following steps:

  1. Rolling upgrade of the Virtual Box machines (OEL61A and OEL61B) from OEL 6.1 to OEL 6.5 with UEKR3 (kernel 3.8.13-35.el6uek.x86_64)
  2. Upgrade from Oracle 11gR2 11.2.0.3 to Oracle 12c 12.1.0.1 for both GI/RDBMS software. The database upgrade involves a downtime during the upgrade.

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

I upgraded the Oracle VM Virtual Box software, used in the setup here, to the latest version available at the time of writing the article. Thus, henceforth, I will not discuss the Oracle VM Virtual Box software upgrade in the article.

I will use the existing VMs (OEL61A and OEL61B) without any change from the original configuration for the upgrade to OEL65 and Oracle 12c. The only changes are to enable internet access for the duration of the OEL upgrade

Overall, I must admit, I was quite impressed by how easy and smooth the upgrade was compared to similar Oracle RAC upgrades from 9i->10g->11g where I had to spend longer time on MOS (former Metalink) working around upgrade issues.

Read online from here or download Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6

May 25, 2014 Posted by | oracle | 3 Comments

Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5

Upgrade Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL6.5

In the article you will have a look at the guidelines and steps to upgrade an Oracle RAC cluster 11.2.0.3 on OEL 6.1 to Oracle RAC cluster 12c on OEL 6.5. The initial cluster configuration (Oracle 11.2.0.3 on OEL 6.1) is described here. The upgrade comprises the following steps:

  1. Rolling upgrade of the Virtual Box machines (OEL61A and OEL61B) from OEL 6.1 to OEL 6.5 with UEKR3 (kernel 3.8.13-35.el6uek.x86_64)
  2. Upgrade from Oracle 11gR2 11.2.0.3 to Oracle 12c 12.1.0.1 for both GI/RDBMS software. The database upgrade involves a downtime during the upgrade.

The following software will be used:

  1. Oracle VM Virtual Box 4.3.12 – download from here.
  2. Oracle 12c (database, grid, examples) – download from OTN here.
  3. Oracle OEL 6.5 – download from Oracle Software Delivery Cloud (former Edelivery) here.

I upgraded the Oracle VM Virtual Box software, used in the setup here, to the latest version available at the time of writing the article. Thus, henceforth, I will not discuss the Oracle VM Virtual Box software upgrade in the article.

I will use the existing VMs (OEL61A and OEL61B) without any change from the original configuration for the upgrade to OEL65 and Oracle 12c. The only changes are to enable internet access for the duration of the OEL upgrade

Overall, I must admit, I was quite impressed by how easy and smooth the upgrade was compared to similar Oracle RAC upgrades from 9i->10g->11g where I had to spend longer time on MOS (former Metalink) working around upgrade issues.

Continue reading

May 25, 2014 Posted by | oracle | 1 Comment

Oracle Certified Master 11g – OCM 11g

Oracle Certified Master 11g – OCM 11g

I recently sat for the Oracle Database 11g: Oracle Certified Master Upgrade (OCM). Today, I was pleasantly surprised receiving a notification that I have successfully completed the practicum.

As I signed an NDA with Oracle Corporation I will not be able to provide you with any comments or answers related to the OCM practicum, but I can assure you that the information provided by Oracle for the scope and instructions for preparation are sufficient for you to prepare and successfully complete the OCM practicum test.

Good luck with your Oracle certifications.

    

May 7, 2014 Posted by | oracle | 3 Comments