Adding Node To Oracle RAC Database

Summary:

==============================================================

This presentation will provide detail steps for Oracle DBA and Linux Engineer to add new node to existing 11gR1 (11.1.0.6) database RAC. 

The most critical steps that need to be followed are:

• Verify the exists cluster configuration 
• Installation Prerequisite
• Configuring SSH on New Cluster Member Nodes 
• Pre-install checking 
• Backup the files (OCR, Voting Disk, root.sh, oraInventory)
• Adding an Oracle Clusterware home to new nodes using OUI in interactive node
• Configure ONS for the new node.  
• Adding an Oracle ASM home to new nodes using OUI in interactive node (Required If you have separate home directory )
• Adding an Oracle RDBMS home to  new nodes using OUI in interactive mode
• Reconfigure  listener on new node using NETCA
• Adding ASM instance to new nodes using DBCA
• Adding DB Instance to new nodes using DBCA

1. a) Verify the exists cluster configuration

[[email protected] ~]$ crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host       

———————————————————————-

ora….L1.inst application    0/5    0/0    ONLINE    ONLINE    krac1      

ora….L2.inst application    0/5    0/0    ONLINE    ONLINE    krac2      

ora.ORCL.db    application    0/0    0/1    ONLINE    ONLINE    krac1      

ora….SM1.asm application    0/5    0/0    ONLINE    ONLINE    krac1      

ora….C1.lsnr application    0/5    0/0    ONLINE    ONLINE    krac1      

ora.krac1.gsd  application    0/5    0/0    ONLINE    ONLINE    krac1      

ora.krac1.ons  application    0/3    0/0    ONLINE    ONLINE    krac1      

ora.krac1.vip  application    0/0    0/0    ONLINE    ONLINE    krac1      

ora….SM2.asm application    0/5    0/0    ONLINE    ONLINE    krac2      

ora….C2.lsnr application    0/5    0/0    ONLINE    ONLINE    krac2      

ora.krac2.gsd  application    0/5    0/0    ONLINE    ONLINE    krac2      

ora.krac2.ons  application    0/3    0/0    ONLINE    ONLINE    krac2      

ora.krac2.vip  application    0/0    0/0    ONLINE    ONLINE    krac2

RAC Database Configuration details

[[email protected] ~]$ srvctl config database -d orcl

krac1 ORCL1 /u02/app/oracle/product/11.1.0/db_1

krac2 ORCL2 /u02/app/oracle/product/11.1.0/db_1

[[email protected] ~]$ srvctl status database -d orcl
Instance ORCL1 is running on node krac1
Instance ORCL2 is running on node krac2

Automatic Storage Management(ASM) Configuration details

[[email protected] ~]$ srvctl config asm -n krac1

+ASM1 /u02/app/oracle/product/11.1.0/asm_1

[[email protected] ~]$ srvctl config asm -n krac2

+ASM2 /u02/app/oracle/product/11.1.0/asm_1

[[email protected] ~]$ srvctl status asm -n krac1
ASM instance +ASM1 is running on node krac1.
[[email protected] ~]$ srvctl status asm -n krac2
ASM instance +ASM2 is running on node krac2.
[[email protected] ~]$ 

Nodeapps Configuration Details

[[email protected] ~]$ srvctl config nodeapps -n krac1

VIP exists.: /krac1-vip/152.168.1.60/255.255.255.0/eth0

GSD exists.

ONS daemon exists.

Listener exists.

[[email protected] ~]$ srvctl config nodeapps -n krac2

VIP exists.: /krac2-vip/152.168.1.61/255.255.255.0/eth0

GSD exists.

ONS daemon exists.

Listener exists.

Listener Configuration Details

[[email protected] ~]$ srvctl config listener -n krac1

krac1 LISTENER_KRAC1

[[email protected] ~]$ srvctl status nodeapps -n krac1

VIP is running on node: krac1

GSD is running on node: krac1

Listener is running on node: krac1

ONS daemon is running on node: krac1

[[email protected] ~]$ srvctl status nodeapps -n krac2

VIP is running on node: krac2

GSD is running on node: krac2

Listener is running on node: krac2

ONS daemon is running on node: krac2

Nodes and Environment Details

[[email protected] ~]$ olsnodes -n -p -i

krac1   1       krac1-priv      krac1-vip

krac2   2       krac2-priv      krac2-vip

=====================================================================

Exist Nodes :krac1.dbprod.com,krac2.dbprod.com

New Node : krac3.dbprod.com

CRS_HOME : /u01/crs11g — crs(OS) user is owner

ASM_HOME : /u02/app/oracle/product/11.1.0/asm_1 — oracle(OS) user owner

RAC_HOME : /u02/app/oracle/product/11.1.0/db_1 — oracle(OS) user owner

Note : In this setup ASM configured in separate home directory for High availability.

Verify network interface using Oracle interface configuration tool

[[email protected] ~]$ oifcfg getif -global

eth0  152.168.1.0  global  public

eth1  122.168.1.0  global  cluster_interconnect

2. Installation Prerequisite

3. a. Configuring SSH on New Cluster Member Nodes 

[[email protected] ~]$ su – crs

[[email protected] ~]$ mkdir ~/.ssh

[[email protected] ~]$ chmod 700 ~/.ssh

[[email protected] ~]$ cd ~/.ssh

[[email protected] .ssh]$ /usr/bin/ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (/home/crs/.ssh/id_rsa): <ENTER>

Enter passphrase (empty for no passphrase): <ENTER>

Enter same passphrase again: <ENTER>

Your identification has been saved in /home/crs/.ssh/id_rsa.

Your public key has been saved in /home/crs/.ssh/id_rsa.pub.

The key fingerprint is:

2e:85:e0:06:c8:14:66:65:28:83:47:db:78:71:17:01 [email protected]

[[email protected] .ssh]$ /usr/bin/ssh-keygen -t dsa

Generating public/private dsa key pair.

Enter file in which to save the key (/home/crs/.ssh/id_dsa): <ENTER>

Enter passphrase (empty for no passphrase): <ENTER>

Enter same passphrase again: <ENTER>

Your identification has been saved in /home/crs/.ssh/id_dsa.

Your public key has been saved in /home/crs/.ssh/id_dsa.pub.

The key fingerprint is:

60:52:61:65:b7:df:5a:5c:b2:83:79:b4:d2:9b:9d:21 [email protected]

[[email protected] .ssh]$ ls -ltr

total 16

-rw-r–r– 1 crs oinstall  402 Oct 22 21:50 id_rsa.pub

-rw——- 1 crs oinstall 1675 Oct 22 21:50 id_rsa

-rw-r–r– 1 crs oinstall  610 Oct 22 21:50 id_dsa.pub

-rw——- 1 crs oinstall  668 Oct 22 21:50 id_dsa

b.  SCP the authorized_keys file from exist node (on krac1)

su – crs

[[email protected] .ssh]$ scp ~/.ssh/authorized_keys krac3:$HOME /.ssh/.

c.  Login into new node (krac3.dbprod.com) 

[[email protected] .ssh]$ ls -ltr

total 20

-rw-r–r– 1 crs oinstall  402 Oct 22 21:50 id_rsa.pub

-rw——- 1 crs oinstall 1675 Oct 22 21:50 id_rsa

-rw-r–r– 1 crs oinstall  610 Oct 22 21:50 id_dsa.pub

-rw——- 1 crs oinstall  668 Oct 22 21:50 id_dsa

-rw-r–r– 1 crs oinstall 2024 Oct 22 21:50 authorized_keys

[[email protected] .ssh]$ cat id_rsa.pub >> authorized_keys

[[email protected] .ssh]$ cat id_dsa.pub >> authorized_keys

d.  Copy the latest authorized_key file to remaining  all nodes in cluster.

su – crs

[[email protected] .ssh]$ scp authorized_keys krac1:$HOME/.ssh/.

[[email protected] .ssh]$ scp authorized_keys krac2:$HOME/..ssh/.

e.  Enabling SSH User Equivalency on Cluster Member Nodes (Need to done both crs and oracle users)

ssh krac1 date

ssh krac2 date

ssh krac3 date

ssh krac1.dbprod.com date

ssh krac2.dbprod.com date

ssh krac3.dbprod.com date

ssh krac1-priv date

ssh krac2-priv date

ssh krac3-priv date

ssh krac1-priv.dbprod.com date

ssh krac2-priv.dbprod.com date

ssh krac3-priv.dbprod.com date

f. Repeat the same steps as a oracle user in all new nodes. 

3. Pre-install checking 

a) Verify cluster healthy on existing nodes (ocrcheck, cluvfy). 

[[email protected] ~]$ ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          2

         Total space (kbytes)     :    1043916

         Used space (kbytes)      :       5612

         Available space (kbytes) :    1038304

         ID                       : 1347985972

         Device/File Name         : /dev/raw/raw1

                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded

b) This theory assumes that the Prerequisites Installation takes have already been performed on the nodes.

$cluvfy stage -post hwos -n krac3

c) Check OS version, Kernel parameters, /etc/hosts file and ensure they are identical on all nodes.

[[email protected] ~]$ uname -nrmo

krac1.dbprod.com 2.6.18-194.el5 i686 GNU/Linux

[[email protected] ~]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 5.5 (Tikanga)

d) Verify below lines in /etc/sysclt.conf file on new node(krac3) .

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

e) Confirm a new node(commented in red color) entry in /etc/hosts files on all the nodes. 

##################################################

### LocalHost

##################################################

127.0.0.1       localhost.localdomain   localhost

##################################################

### Public IP Address

##################################################

152.168.1.50    krac1.dbprod.com        krac1  

152.168.1.51    krac2.dbprod.com        krac2

152.168.1.52    krac3.dbprod.com        krac3

##################################################

### Private IP Address

##################################################

192.168.1.50    krac1-priv.dbprod.com   krac1-priv

192.168.1.51    krac2-priv.dbprod.com   krac2-priv

192.168.1.52    krac3-priv.dbprod.com   krac3-priv

##################################################

### VIP Address

##################################################

152.168.1.60    krac1-vip.dbprod.com    krac1-vip

152.168.1.61    krac2-vip.dbprod.com    krac2-vip

152.168.1.62    krac3-vip.dbprod.com    krac3-vip

[[email protected] ~]$cluvfy stage -pre crsinst -n krac1,krac2,krac3

Performing pre-checks for cluster services setup

Checking node reachability…

Node reachability check passed from node “krac1”.

Checking user equivalence…

User equivalence check passed for user “crs”.

Checking administrative privileges…

User existence check passed for “crs”.

Group existence check passed for “oinstall”.

Membership check for user “crs” in group “oinstall” [as Primary] passed.

Administrative privileges check passed.

Checking node connectivity…

Node connectivity check passed for subnet “152.168.1.0” with node(s) krac3,krac2,krac1.

Node connectivity check passed for subnet “192.168.1.0” with node(s) krac3,krac2,krac1.

Interfaces found on subnet “152.168.1.0” that are likely candidates for VIP:

krac3 eth0:152.168.1.52

krac2 eth0:152.168.1.51 eth0:152.168.1.61

krac1 eth0:152.168.1.50 eth0:152.168.1.60

Interfaces found on subnet “192.168.1.0” that are likely candidates for VIP:

krac3 eth1:192.168.1.52

krac2 eth1:192.168.1.51

krac1 eth1:192.168.1.50

WARNING:

Could not find a suitable set of interfaces for the private interconnect.

Node connectivity check passed.

Checking system requirements for ‘crs’…

Total memory check passed.

Free disk space check passed.

Swap space check passed.

System architecture check passed.

Kernel version check passed.

Package existence check passed for “make-3.81”.

Package existence check passed for “binutils-2.17.50.0.6”.

Package existence check passed for “gcc-4.1.1”.

Package existence check passed for “libaio-0.3.106”.

Package existence check passed for “libaio-devel-0.3.106”.

Package existence check passed for “libstdc++-4.1.1”.

Package existence check passed for “elfutils-libelf-devel-0.125”.

Package existence check passed for “sysstat-7.0.0”.

Package existence check passed for “compat-libstdc++-33-3.2.3”.

Package existence check passed for “libgcc-4.1.1”.

Package existence check passed for “libstdc++-devel-4.1.1”.

Package existence check passed for “unixODBC-2.2.11”.

Package existence check passed for “unixODBC-devel-2.2.11”.

Package existence check passed for “glibc-2.5-12”.

Group existence check passed for “dba”.

Group existence check passed for “oinstall”.

User existence check passed for “nobody”.

System requirement passed for ‘crs’

Pre-check for cluster services setup was successful.

Backup the files (OCR, Voting Disk).

[[email protected] ~]# cd /u01/crs11g/bin

[[email protected] bin]#./ocrconfig -manualbackup

krac1     2012/10/22 22:58:57     /u01/crs11g/cdata/krac_cluster/backup_20121022_225857.ocr

[[email protected] bin]# ./ocrconfig -export /u01/crs11g/cdata/krac_cluster/ocr_backup_before_adding_node.dmp

[[email protected] bin]# ls -l /u01/crs11g/cdata/krac_cluster/ocr_backup_before_adding_node.dmp

-rw-r–r– 1 root root 104169 Oct 22 23:00 /u01/crs11g/cdata/krac_cluster/ocr_backup_before_adding_node.dmp

[[email protected] bin]# ./crsctl query css votedisk

 0.     0    /dev/raw/raw2

Located 1 voting disk(s).

[[email protected] bin]# dd if=/dev/raw/raw2 of=/u01/crs11g/cdata/krac_cluster/votedisk_bkp_before_adding_node.dmp bs=1024

Inventory and root.sh Backup

[[email protected] oracle]$  cat /etc/oraInst.loc

inventory_loc=/u02/app/oracle/oraInventory

inst_group=oinstall

[[email protected] oracle]$ cd /u02/app/oracle

[[email protected] oracle]$ tar -cvf oraInventory.tar oraInventory

su – crs

cd $ORA_CRS_HOME/bin

cp root.sh root.sh.bkp

su – oracle

cd $ORACLE_HOME/bin

cp root.sh root.sh.bkp

Node : Repeat above the steps in all nodes
 

Adding an Oracle Clusterware home to new nodes using OUI in interactive node

su – crs

cd $ORA_CRS_HOME/oui/bin

./addNode.sh

 Action : Click “Next”

 Action : Enter the new nodes name(Public,Private,Virtual host name) and click “Next”

 Action : Verify cluster add node summary and click “Install”

[[email protected] ~]# /u02/app/oracle/oraInventory/orainstRoot.sh

Changing permissions of /u02/app/oracle/oraInventory to 770.

Changing groupname of /u02/app/oracle/oraInventory to oinstall.

The execution of the script is complete

[[email protected] ~]# ssh krac1 /u01/crs11g/install/rootaddnode.sh

[email protected]’s password:

clscfg: EXISTING configuration version 4 detected.

clscfg: version 4 is 11 Release 1.

Attempting to add 1 new nodes to the configuration

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

node 3: krac3 krac3-priv krac3

Creating OCR keys for user ‘root’, privgrp ‘root’..

Operation successful.

/u01/crs11g/bin/srvctl add nodeapps -n krac3 -A krac3-vip/255.255.255.0/eth0

[[email protected] ~]# /u01/crs11g/root.sh

Checking to see if Oracle CRS stack is already configured

/etc/oracle does not exist. Creating it now.

OCR LOCATIONS =  /dev/raw/raw1

OCR backup directory ‘/u01/crs11g/cdata/krac_cluster’ does not exist. Creating now

Setting the permissions on OCR backup directory

Setting up Network socket directories

Oracle Cluster Registry configuration upgraded successfully

clscfg: EXISTING configuration version 4 detected.

clscfg: version 4 is 11 Release 1.

Successfully accumulated necessary OCR keys.

Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.

node <nodenumber>: <nodename> <private interconnect name> <hostname>

node 1: krac1 krac1-priv krac1

node 2: krac2 krac2-priv krac2

clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.

-force is destructive and will destroy any previous cluster

configuration.

Oracle Cluster Registry for cluster has already been initialized

Startup will be queued to init within 30 seconds.

Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds.

Cluster Synchronization Services is active on these nodes.

        krac1

        krac2

        krac3

Cluster Synchronization Services is active on all the nodes.

Waiting for the Oracle CRSD and EVMD to start

Oracle CRS stack installed and running under init(1M)

 Action : Click “Exit”.

Action : Click “Yes”

[[email protected] ]$ crs_stat -t -v -c krac3

Name           Type           R/RA   F/FT   Target    State     Host       

———————————————————————-

ora.krac3.gsd  application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.ons  application    0/3    0/0    ONLINE    ONLINE    krac3      

ora.krac3.vip  application    0/0    0/0    ONLINE    ONLINE    krac3  

Configure ONS for the new node.  

From the first node, Looking at the ons.config file located in <CRS_HOME>/opmn/config directory. You can determine the ONS remote port to be used. You need to use the same port in racgons add_config as show in below to make sure that the first node can communicate with the ONS on new node.

[[email protected] ]$ cd $ORA_CRS_HOME/opmn/conf

[[email protected] ]$ cat ons.config

localport=6150

useocr=on

allowgroup=true

usesharedinstall=true

[[email protected] conf]$

On new node(krac3) execute below commands.

[[email protected] ~]$ crs_stat -t -c krac3

Name           Type           Target    State     Host       

————————————————————

ora.krac3.gsd  application    ONLINE    ONLINE    krac3      

ora.krac3.ons  application    ONLINE    ONLINE    krac3      

ora.krac3.vip  application    ONLINE    ONLINE    krac3 

[[email protected] ]$ su – crs

[[email protected] ]$cd $ORA_CRS_HOME/bin

[[email protected] bin]$ ./racgons add_config rac3:6150

Adding an ASM home to new nodes using OUI in interactive node.(Its needed when ASM is installed with separate home directory for high availability) 

[[email protected] ]$ su – oracle

[[email protected] ]$ cd $ORA_ASM_HOME/oui/bin

[[email protected] ]$ ./addNode.sh

Action : Click “Next”

 Action : Click “Next”

 Action : Review Cluster Node Addition Summary and click “Next”

 Action : Nothing
After Installation completes OUI will prompt you to run root.sh as root user.  Once root.sh script execution completed follow with below steps.

[[email protected] ~]# /u02/app/oracle/product/11.1.0/asm_1/root.sh

Running Oracle 11g root.sh script…

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u02/app/oracle/product/11.1.0/asm_1

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

   Copying dbhome to /usr/local/bin …

   Copying oraenv to /usr/local/bin …

   Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…

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.

Action: Click “Next”

Adding an RDBMS home to new nodes using OUI in interactive node.

[[email protected] ]$ su – oracle

[[email protected] ]$ cd $ORACLE_HOME/oui/bin

[[email protected] ]$ ./addNode.sh

Action : Click “Next”

Action : Select New Node and click “Next”

 Action : Review Cluster Addition Node Summary and Click “Next”

 Action : Nothing
After Installation completes OUI will prompt you to run root.sh as root user.  Once root.sh script execution completed follow with below steps.

[[email protected] ~]# /u02/app/oracle/product/11.1.0/db_1/root.sh

Running Oracle 11g root.sh script…

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u02/app/oracle/product/11.1.0/db_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]: y

   Copying dbhome to /usr/local/bin …

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

[n]: y

   Copying oraenv to /usr/local/bin …

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

[n]: y

   Copying coraenv to /usr/local/bin …

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.

 Action : Click “Next”

Reconfigure  listener on new node using NETCA

[[email protected] ]$ su – oracle

[[email protected] ]$ cd $ORA_ASM_HOME/bin

[[email protected] ]$ ./netca

 Action : Select Cluster Configuration and click “Next”

Action : Select new node name and click “Next”

Action : Select Listener configuration and click “Next”

Action : Select add and click “Next”

Action : Enter listener name and click “Next”

Action : Click “Next”

Action : Click “Next”

Action : Select no and click “Next”

Action : Click “Next”

Action : Click “Finish”

[[email protected] bin]$ crs_stat -t -v -c krac3

Name           Type           R/RA   F/FT   Target    State     Host       

———————————————————————-

ora….C3.lsnr application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.gsd  application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.ons  application    0/3    0/0    ONLINE    ONLINE    krac3      

ora.krac3.vip  application    0/0    0/0    ONLINE    ONLINE    krac3  

Adding ASM instance to new nodes using DBCA
 

[[email protected] ]$ su – oracle

[[email protected] ]$ cd $ORA_ASM_HOME/bin

[[email protected] ]$ ./dbca

 Action : Select Oracle Real Application Cluster Database and click “Next”

 Action : Select Configure Automatic Storage Management

 Action : Select New nodes and click “Next”

Action : Click “Yes”

 Action : Click “Finish”

[[email protected] bin]$ crs_stat -t -v -c krac3

Name           Type           R/RA   F/FT   Target    State     Host       

———————————————————————-

ora….SM3.asm application    0/5    0/0    ONLINE    ONLINE    krac3      

ora….C3.lsnr application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.gsd  application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.ons  application    0/3    0/0    ONLINE    ONLINE    krac3      

ora.krac3.vip  application    0/0    0/0    ONLINE    ONLINE    krac3  

Adding DB Instance to new nodes using DBCA

su – oracle

[[email protected] ]$ cd $ORACLE_HOME/bin

[[email protected] ]$ ./dbca

 Action : Select Real Application Clusters Database and click “Next”

 Action : Select Instance Management and click “Next”

 Action : Select Add node and click “Next”

 Action : Enter the Username and password then click “Next”

 Action : Click “Next”

 Action : Verify Instance and new node name then click “Next”

 Action : Click “Finish”

Action : Click “OK”

Action : Nothing

Action : Click “Yes”

[[email protected] bin]$ crs_stat -t -v

Name           Type           R/RA   F/FT   Target    State     Host       

———————————————————————-

ora….L1.inst application    0/5    0/0    ONLINE    ONLINE    krac1      

ora….L2.inst application    0/5    0/0    ONLINE    ONLINE    krac2      

ora….L3.inst application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.ORCL.db    application    0/0    0/1    ONLINE    ONLINE    krac1      

ora….SM1.asm application    0/5    0/0    ONLINE    ONLINE    krac1      

ora….C1.lsnr application    0/5    0/0    ONLINE    ONLINE    krac1      

ora.krac1.gsd  application    0/5    0/0    ONLINE    ONLINE    krac1      

ora.krac1.ons  application    0/3    0/0    ONLINE    ONLINE    krac1      

ora.krac1.vip  application    0/0    0/0    ONLINE    ONLINE    krac1      

ora….SM2.asm application    0/5    0/0    ONLINE    ONLINE    krac2      

ora….C2.lsnr application    0/5    0/0    ONLINE    ONLINE    krac2      

ora.krac2.gsd  application    0/5    0/0    ONLINE    ONLINE    krac2      

ora.krac2.ons  application    0/3    0/0    ONLINE    ONLINE    krac2       

ora.krac2.vip  application    0/0    0/0    ONLINE    ONLINE    krac2      

ora….SM3.asm application    0/5    0/0    ONLINE    ONLINE    krac3      

ora….C3.lsnr application    0/5    0/0    ONLINE    ONLINE    krac3      

ora….C3.lsnr application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.gsd  application    0/5    0/0    ONLINE    ONLINE    krac3      

ora.krac3.ons  application    0/3    0/0    ONLINE    ONLINE    krac3      

ora.krac3.vip  application    0/0    0/0    ONLINE    ONLINE    krac3

Post Insallations Check.

clufy stage -post crsinst -n all -verbose

[[email protected] ~]$ sqlplus system/[email protected]

SQL*Plus: Release 11.1.0.6.0 – Production on Mon Oct 29 19:55:42 2012

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

SQL> col host_name for a25

SQL> col instance_name for a20

SQL> select instance_name,host_name from v$instance;

INSTANCE_NAME        HOST_NAME

——————– ————————-

ORCL3                krac3.dbprod.com

SQL> select instance_name,host_name from gv$instance;

INSTANCE_NAME        HOST_NAME

——————– ————————-

ORCL3                krac3.dbprod.com

ORCL2                krac2.dbprod.com

ORCL1                krac1.dbprod.com

Share this post: on Twitter on Facebook on Google+