Oracle Labs by Yuri Khazin, Oracle DBA

Virtual Oracle RAC. Task 12: Creating Oracle database in RAC nodes


Link back: This guide is a part of the Virtual Oracle RAC project, the index to the whole project is here.

Start Database Configuration Assistant from odbn1 node:

$ dbca &

Leave fisrt option selected:

Leave "Create a Databse" selected:

Click "Select All" nodes:

Select "Custom Database":

Fill out the Global Database Name. ,We have discussed the importance of the domain name in the networking of the RAC in the very beginning of this article. Although the domain name has to be there, it is not a real internet domain. Still, it has to match what you have in your "hosts" file.

I am configuring a lightweight RAC configuration so I am not installing OEM or other advanced options (it is up to you if want OEM, Java etc):

Specify password for all admin accounts (and write it down)

Select ASM as a storage option:

Specify SYS password for ASM instance and fill out location of SPFILE as shown (SPFILE has to be on a shared disk):

Acknowledge the confirmation:

Promising signs…

When next screen appears click "Create New" disk group:

Fill out details as shown, click "Ok":

Click "Create New" again:

Fill out details as shown:

In the next screen select RACDB_DATA1 as a storage option for the database (unselect first group):

Agree to the "Oracle Managed Files" option:

Fill out details for Flash Recovery as shown (total size of the disk group minus some 10%):

As mentioned before, I am installing barebone database, but you can add more options:

I am even removing standard components as I am not going to use them in this configuration:

In the next screen click "Add":

Fill out "Service Name" as racdb_taf (this is for Transparent Application Failover):

Leave both nodes as "Preferred" and select "Basic" as TAF Policy:

I am accepting default settings (you can change them as you wish):

Same with storage options, I am accepting all defaults:

Leave "Create Database" option selected and select "Generate Database Creation Scripts" as well (for later review). Click "Finish":

Summary screen pops up. Cross fingers and click "Ok"

Database installation progresses and in the end this screen appers, click "Exit":

A few moments later the RAC starts (this phase may take a while):

Then the OUI will close by itself.

A little cleanup needs to be done (again). Edit the following file (on both nodes):

$ vi $ORACLE_HOME/bin/srvctl

Add the following text at line 168:

unset LD_ASSUME_KERNEL

Save the file and exit.

Now we should have a fully functional Oracle RAC.

Let’s run a few checks.

To make sure all registered RAC applications are running (as user "oracle" from any node):

$ $ORA_CRS_HOME/bin/crs_stat -t

To verify the racdb_taf service, start a sqlplus (on any node):

$ sqlplus ‘/as sysdba’

Give following command:

SQL> show parameter service

See that there are two services displayed. If there is only one or none they can be added manually:

SQL> alter system set service_names = ‘racdb.idevelopment.info, racdb_taf’ scope=both;

Just for reference

Stopping the Oracle RAC 10g Environment on a single node

$ export ORACLE_SID=racdb1
$ srvctl stop instance -d racdb -i racdb1
$ srvctl stop asm -n odbn1
$ srvctl stop nodeapps -n odbn1

Starting the Oracle RAC 10g environment on a single node

$ export ORACLE_SID=racdb1
$ srvctl start nodeapps -n odbn1
$ srvctl start asm -n odbn1
$ srvctl start instance -d racdb -i racdb1

Start or stop all Instances of the RAC at once

$ srvctl start database -d racdb
$ srvctl stop database -d racdb

Next chapter.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: