11gR2 RAC Step By Step Configuration On VMWare part5

STAGE 5
Oracle rdbms instance configuration  

Go to Node1 and login as root

[root@racha1 ~]# xhost +
access control disabled, clients can connect from any host
[root@racha1 ~]# su - oracle
[oracle@racha1 ~]$xclock ---> it should return clock display
[oracle@racha1 ~]$ cd /install/disk1
[oracle@racha1 disk1]$ ls  
doc install response rpm runInstaller sshsetup stage welcome.html
[oracle@racha1 disk1]$./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 80 MB. Actual 9852 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3887 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-07-25_08-46-27PM. Please wait ...

Uncheck the security updates checkbox and click the "Next" button.

  

 Accept the "Create and configure a database" option by clicking the "Next" button.

Accept the "Server Class" option by clicking the "Next" button.

  

Make sure both nodes are selected, then click the "Next" button.

   

 Accept the "Typical install" option by clicking the "Next" button.

Enter "/u01/app/oracle/product/11.2.0/dbhome_1" for the software location. The storage type should be set to "Automatic Storage Manager". Enter the appropriate passwords and database name, in this case "RAC.localdomain".

  

Wait for the prerequisite check to complete. If there are any problems either fix them, or check the "Ignore All" checkbox and click the "Next" button.

  

If you are happy with the summary information, click the "Finish" button.

  

Once the software installation is complete the Database Configuration Assistant (DBCA) will start automatically.

  

Once the Database Configuration Assistant (DBCA) has finished, click the "OK" button.

  

When prompted, run the configuration scripts on each node. When the scripts have been run on each node, click the "OK" button.

  

Node 1:

[root@racha1 ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) 

[n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

[root@racha1 ~]#

Node 2: 

[root@racha2 ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

[root@racha2 ~]#

Two Node RAC Installation Successfully completed. Click the "Close" button to exit the installer.

Check the Status of the RAC
There are several ways to check the status of the RAC. The srvctl utility shows the current configuration and status of the RAC database.For that you have to set the environment for  GRID infrastructure. I made a grid.env in my oracle home and it contains

[oracle@racha1 ~]$ cat grid.env
export GRID_HOME=/u01/app/11.2.0/grid
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=+ASM1
[oracle@racha1 ~]$. grid.env

$ srvctl config database -d RAC
Database unique name: RAC
Database name: RAC
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RAC/spfileRAC.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RAC
Database instances: RAC1,RAC2
Disk Groups: DATA
Services: 
Database is administrator managed
$

$ srvctl status database -d RAC
Instance RAC1 is running on node racha1
Instance RAC2 is running on node racha2
$

The V$ACTIVE_INSTANCES view can also display the current status of the instances. 

Just Check

Node 1:

[oracle@racha1 ~]$. .bash_profile (sourcing the rdbms home environment) 

[oracle@racha1 ~]$ export ORACLE_SID=RAC1

[oracle@racha1 ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 26 13:00:31 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: / as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME

---------

RAC

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

RAC1

SQL> SELECT inst_name FROM v$active_instances;

INST_NAME
-------------------------------------------------------------------
racha1.localdomain:RAC1
racha2.localdomain:RAC2

    

                                         I hope this may help you , enjoy ..!!!