Implementing a demo RAC 12c system

Hi all!

I am working on a new post series. I am trying to build a whole workable demo Oracle 12c RAC system.
The demo system will use only free or trial licencesed downloadable virtual components.

The planned system components:

• Oracle virtualbox for virtualization
• 2 virtual node with Solaris operating system, 
• a ZFS virtual storage node, 
• Oracle 12c Enterprise Edition RAC
• Container and pluggable database instances

The new post series other goal is to show how fastly is possible to create a working Oracle 12c RAC database for demonstrating purposes of RAC, Solaris or ZFS storage functions, features.

I will begin it as soon as possible.

Zoltan

Building a 5 nodes Oracle EBS using RAC and shared appl top 8.

Finish the configuration

What we have got now?

• Grid infrastructure
• RAC database software
• 2 node RAC EBS database
• A to be configured application tier

The already made steps:

1. Prepare the RAC database software
2. Prepare the source database for the conversion
3. Convert database into RAC
4. Post database conversion steps
1. turn on autoconfig
2. server parameter changes
3. create new EBS specific cluster listeners

So I have to configure the application tier to use the new RAC database. The remaining steps are:

1. Configure application tiers for using RAC database service
2. Post configuration steps

Building a 5 nodes Oracle EBS using RAC and shared appl top 7.

Forming the RAC database

What we have got now?

• Grid infrastructure
• RAC database software
• 1+3 node Oracle EBS system

It's time to copy the EBS single node database data into the new RAC database.

I will use the 823587.1 note for transfering data from the single node EBS database into the new RAC one.
The main steps will be:

1. Prepare the RAC database software
2. Prepare the source database for the conversion
3. Convert database into RAC
4. Post database conversion steps
1. turn on autoconfig
2. server parameter changes
3. create new EBS specific cluster listeners
5. Configure application tiers for using RAC database service
6. Post configuration steps

This post will contain the steps until the application tier configuration, all remaining steps will be in the next one.

Building a 5 nodes Oracle EBS using RAC and shared appl top 6.

Add the 2 remaining node to the system

What we have got now?

• Grid infrastructure
• RAC database software
• 2 node Oracle EBS system

It's time to add the 2 remaining node using the shared APPL_TOP method.

I will use the 384248.1 note during the implementation. 

Building a 5 nodes Oracle EBS using RAC and shared appl top 5.

Begin to build the shared APPL_TOP

Now we have a well configured Oracle 11g RAC infrastructure and an installed cluster database software.
All independent tasks are finished so we are ready to begin to build the 5 node system.

First I will create a 1+3 node system, 1 node for database and 3 node for application tier (with shared appl_top). This task could be splitted into 2 subtask. The first one is to create a 2 node Oracle EBS system, the second one is add the remaing 2 application tier node and reconfigure the first application tier node.
The first task is nothing more then an ordinary EBS cloning task, the second subtask is same complexity as the first one :)

So what we will do at this time?

• prepare application tier nodes
• prepare source system
• create 2 node EBS system
• add the additional application nodes

Building a 5 nodes Oracle EBS using RAC and shared appl top 4.

Install Oracle Database Software

In the previuos step we have successfully installed the Oracle Cluster infrastructure. Now it's time to install the RAC enabled Database software.

The installation will takes these steps

• Install the base 11g R2 version 11.2.0.3 software
• Implement EBS - 11gR2 interoperability note's step

Building a 5 nodes Oracle EBS using RAC and shared appl top 3.

Building the RAC infrastructure

This step is an independent step from half of the other step. I you think you could do it at later for example you could made a 1+3 node Oracle EBS system (1 node database and 3 node apps tier) with configured load balancer and SSL.

But now I am starting with this.

The main steps will be:

1. install operating system on the 2 database node,
2. create and configure all necessary storage partitions and mount points,
3. check the installed operating system and configure it for Oracle RAC and EBS database,
4. create unix users and groups,
5. create stage area,
6. create asm disk groups,
7. install Oracle Clusterware 11g Release 2,
8. install latest PSU patches