Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Oct 6, 2010

Moving to Oracle RAC One Node - Page 4

By Vincent Chan

2.1 Oracle Grid Infrastructure Post-Installation checks

Now that we have successfully installed the Grid Infrastructure, let’s verify the environment we have just set up.

Application resources

grid@gurnard1-> crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       gurnard1
               ONLINE  ONLINE       gurnard2
ora.LISTENER.lsnr
               ONLINE  ONLINE       gurnard1
               ONLINE  ONLINE       gurnard2
ora.asm
               ONLINE  ONLINE       gurnard1                 Started
               ONLINE  ONLINE       gurnard2                 Started
ora.eons
               ONLINE  ONLINE       gurnard1
               ONLINE  ONLINE       gurnard2
ora.gsd
               OFFLINE OFFLINE      gurnard1
               OFFLINE OFFLINE      gurnard2
ora.net1.network
               ONLINE  ONLINE       gurnard1
               ONLINE  ONLINE       gurnard2
ora.ons
               ONLINE  ONLINE       gurnard1
               ONLINE  ONLINE       gurnard2
ora.registry.acfs
               ONLINE  ONLINE       gurnard1
               ONLINE  ONLINE       gurnard2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       gurnard2
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       gurnard1
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       gurnard1
ora.gns
      1        ONLINE  ONLINE       gurnard1
ora.gns.vip
      1        ONLINE  ONLINE       gurnard1
ora.gurnard1.vip
      1        ONLINE  ONLINE       gurnard1
ora.gurnard2.vip
      1        ONLINE  ONLINE       gurnard2
ora.oc4j
      1        OFFLINE OFFLINE
ora.scan1.vip
      1        ONLINE  ONLINE       gurnard2
ora.scan2.vip
      1        ONLINE  ONLINE       gurnard1
ora.scan3.vip
      1        ONLINE  ONLINE       gurnard1
 
 
grid@gurnard1-> srvctl status nodeapps
VIP 192.168.1.222 is enabled
VIP 192.168.1.222 is running on node: gurnard1
VIP 192.168.1.226 is enabled
VIP 192.168.1.226 is running on node: gurnard2
Network is enabled
Network is running on node: gurnard1
Network is running on node: gurnard2
GSD is disabled
GSD is not running on node: gurnard1
GSD is not running on node: gurnard2
ONS is enabled
ONS daemon is running on node: gurnard1
ONS daemon is running on node: gurnard2
eONS is enabled
eONS daemon is running on node: gurnard1
eONS daemon is running on node: gurnard2

Oracle Cluster Ready Services (CRS)

grid@gurnard1-> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
 
grid@gurnard2-> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
 
grid@gurnard1-> crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]

Oracle Cluster Registry (OCR) and Voting DiskCluster Ready Services (CRS)

grid@gurnard1-> ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2824
         Available space (kbytes) :     259296
         ID                       : 1041140530
         Device/File Name         :      +DATA
                                    Device/File integrity check succeeded
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
         Cluster registry integrity check succeeded
 
         Logical corruption check bypassed due to non-privileged user
 
grid@gurnard1-> crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   03caacce4e594faabfeeae5018b7fc8f (ORCL:VOL1) [DATA]
 2. ONLINE   25a2945e01564f30bfd8bf1f50d66fc8 (ORCL:VOL2) [DATA]
 3. ONLINE   448383e5ce5b4fdbbfdf3d9a5ba7b85e (ORCL:VOL3) [DATA]
Located 3 voting disk(s).
 

Oracle High Availability Services

[root@gurnard1 ~]# /u01/app/11.2.0/grid/bin/crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.
 
[root@gurnard1 ~]# ps -ef|egrep 'gpnpd|gns|mdns'|grep -v egrep
grid      2859     1  0 17:35 ?        00:00:00 /u01/app/11.2.0/grid/bin/mdnsd.bin
grid      2878     1  0 17:35 ?        00:00:00 /u01/app/11.2.0/grid/bin/gpnpd.bin
root      3601     1  0 17:37 ?        00:00:00 /u01/app/11.2.0/grid/bin/gnsd.bin 
	-trace-level 0 -ip-address 192.168.1.208 -startup-endpoint ipc://GNS_gurnard1_3415_5ae142164cf056b9
 
 
[root@gurnard2 ~]# /u01/app/11.2.0/grid/bin/crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.
 
[root@gurnard2 ~]# ps -ef|egrep 'gpnpd|gns|mdns'|grep -v egrep
grid      2703     1  0 17:35 ?        00:00:00 /u01/app/11.2.0/grid/bin/mdnsd.bin
grid      2717     1  0 17:35 ?        00:00:00 /u01/app/11.2.0/grid/bin/gpnpd.bin

Oracle Automatic Storage Management (ASM)

grid@gurnard1-> srvctl config asm -a
ASM home: /u01/app/11.2.0/grid
ASM listener: LISTENER
ASM is enabled.
 
grid@gurnard2-> srvctl config asm -a
ASM home: /u01/app/11.2.0/grid
ASM listener: LISTENER
ASM is enabled.
 
grid@gurnard1-> srvctl status asm -a
ASM is running on gurnard1,gurnard2
ASM is enabled.

Oracle Listener

grid@gurnard1-> srvctl config listener -a
Name: LISTENER
Network: 1, Owner: grid
Home: 


Single Client Access Name (SCAN)

grid@gurnard1-> srvctl config scan
SCAN name: gurnard-cluster-scan.gurnard.vcconsult.com, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.1.223/192.168.1.223
SCAN VIP name: scan2, IP: /192.168.1.224/192.168.1.224
SCAN VIP name: scan3, IP: /192.168.1.225/192.168.1.225
 
grid@gurnard1-> srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node gurnard2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node gurnard1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node gurnard1
 
grid@gurnard1-> srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node gurnard2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node gurnard1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node gurnard1
 
grid@gurnard1-> nslookup gurnard-cluster-scan.gurnard.vcconsult.com
Server:         192.168.1.13
Address:        192.168.1.13#53
 
Name:   gurnard-cluster-scan.gurnard.vcconsult.com
Address: 192.168.1.223
Name:   gurnard-cluster-scan.gurnard.vcconsult.com
Address: 192.168.1.225
Name:   gurnard-cluster-scan.gurnard.vcconsult.com
Address: 192.168.1.224

Grid Naming Service (GNS)

grid@gurnard1-> srvctl config gns -a
GNS is enabled.
GNS is listening for DNS server requests on port 53
GNS is using port 5353 to connect to mDNS
GNS status: OK
Domain served by GNS: gurnard.vcconsult.com
GNS version: 11.2.0.1.0
GNS VIP network: ora.net1.network
 
grid@gurnard1-> srvctl status gns
GNS is running on node gurnard1.
GNS is enabled on node gurnard1.

Virtual Network Interfaces

 grid@gurnard1-> srvctl status vip -n gurnard1
VIP 192.168.1.222 is enabled
VIP 192.168.1.222 is running on node: gurnard1
grid@gurnard1-> srvctl status vip -n gurnard2
VIP 192.168.1.226 is enabled
VIP 192.168.1.226 is running on node: gurnard2
 
 
[root@gurnard1 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:16:3E:12:93:AD
inet addr:192.168.1.181  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe12:93ad/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:152558 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3958 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:79485094 (75.8 MiB)  TX bytes:1017059 (993.2 KiB)
 
eth0:1    Link encap:Ethernet  HWaddr 00:16:3E:12:93:AD
inet addr:192.168.1.225  Bcast:192.168.1.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
eth0:2    Link encap:Ethernet  HWaddr 00:16:3E:12:93:AD
inet addr:192.168.1.208  Bcast:192.168.1.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
eth0:4    Link encap:Ethernet  HWaddr 00:16:3E:12:93:AD
inet addr:192.168.1.224  Bcast:192.168.1.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
eth0:6    Link encap:Ethernet  HWaddr 00:16:3E:12:93:AD
inet addr:192.168.1.222  Bcast:192.168.1.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
eth1      Link encap:Ethernet  HWaddr 00:16:3E:1C:C4:2D
          inet addr:10.10.10.181  Bcast:10.10.10.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe1c:c42d/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:11294 errors:0 dropped:0 overruns:0 frame:0
          TX packets:112960 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:2707940 (2.5 MiB)  TX bytes:50319220 (47.9 MiB)
 
lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:55173 errors:0 dropped:0 overruns:0 frame:0
          TX packets:55173 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:18087118 (17.2 MiB)  TX bytes:18087118 (17.2 MiB)
 
sit0      Link encap:IPv6-in-IPv4
          NOARP  MTU:1480  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)
 
 
[root@gurnard2 ~]# ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:16:3E:3F:4F:AE
inet addr:192.168.1.182  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe3f:4fae/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:19674 errors:0 dropped:0 overruns:0 frame:0
          TX packets:6111 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:4345841 (4.1 MiB)  TX bytes:1167411 (1.1 MiB)
 
eth0:1    Link encap:Ethernet  HWaddr 00:16:3E:3F:4F:AE
inet addr:192.168.1.223  Bcast:192.168.1.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
eth0:2    Link encap:Ethernet  HWaddr 00:16:3E:3F:4F:AE
inet addr:192.168.1.226  Bcast:192.168.1.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
 
eth1      Link encap:Ethernet  HWaddr 00:16:3E:77:6C:E0
          inet addr:10.10.10.182  Bcast:10.10.10.255  Mask:255.255.255.0
          inet6 addr: fe80::216:3eff:fe77:6ce0/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:123811 errors:0 dropped:0 overruns:0 frame:0
          TX packets:132742 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:52925305 (50.4 MiB)  TX bytes:75688595 (72.1 MiB)
 
lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:39980 errors:0 dropped:0 overruns:0 frame:0
          TX packets:39980 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:16839844 (16.0 MiB)  TX bytes:16839844 (16.0 MiB)
 
sit0      Link encap:IPv6-in-IPv4
          NOARP  MTU:1480  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:0 (0.0 b)  TX bytes:0 (0.0 b)
 


Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM