Oracle Solaris Cluster – Configure Oracle Database with Dataguard- Part 1

This article will provide step by step procedure to manage the oracle Database under Sun-cluster aka Solaris cluster on Oracle Dataguard environment. Oracle Dataguard is widely used product for the disaster recovery solutions.It provides great visibility to database administrator to manage their environment in better manner. Sun-cluster is used only on oracle Solaris operating system and use of this product have been increased recently. Companies are keep on trying to reduce their operating cost and that axed Veritas products like volume manager and vertias cluster from datacenter. That’s the reason , we are seeing use of ZFS & Sun-cluster aka Solaris cluster increased rapidly.

This article will help you to setup ZFS storage pool under suncluster.

Prerequisites :

• Two nodes with oracle solaris 10 or 11 on each sites. (PROD & DR)
• Sun Cluster product installed on both the nodes & configured. (PROD & DR)
• ZFS storage pool resource configured on suncluster. (PROD & DR)
• Oracle database have been installed and configured. (PROD & DR)

 

• Assumptions:   PRIMARY
  Resource Group Name – UADBPRD-rg
  Zpool Resource name – UADBPRD-HAS

 

Let’s see the step by step procedure to bring the primary oracle database under Sun cluster / Solaris cluster control.

 

PRIMARY:

Login  to the production cluster nodes and perform the following activities.

1. Register the required cluster resource types.

# clrt register SUNW.oracle_server
# clrt register SUNW.oracle_listener
# clrt register SUNW.logicalhostname

 

2. Add the database VIP in /etc/hosts file.

# cat /etc/hosts  |grep UAVSL-vip
192.168.2.40	    UAVSL-VIP

 

3. Create the logical hostname resource for VIP.

# clreslogicalhostname  create -g  UADBPRD-rg  -h  UAVSL-VIP -N db_ipmp@2,db_ipmp@1 UAVSL-vip-res

 

4. Create the oracle database server resource.

# clresource create -g  UADBPRD-rg -t SUNW.oracle_server -p Connect_string=cluster/password -p ORACLE_SID=UADBPRD  -p ORACLE_HOME=/oracle/UADBPRD/product/12.1.0.2 -p Alert_log_file=/oracle/diag/rdbms/UADBPRD/trace/alert_UADBBPRD.log  -p Dataguard_role=PRIMARY -p resource_dependencies=UADBPRD-HAS  UADBPRD-ORA-server

 

5. Create the oracle database listener resoruce.

# clresource create -g  UADBPRD-rg -t SUNW.oracle_listener -p LISTENER_NAME=LISTENER  -p ORACLE_HOME=/oracle/UADBPRD/product/12.1.0.2  -p resource_dependencies=UADBPRD-ORA-server UADBPRD-ORA-LSN

 

6. Check the cluster status using clrg & clrs commands.

# clrg status 

=== Cluster Resource Groups ===

Group Name        Node Name        Suspended    Status
----------        ---------        ---------    ------
UADBPRD-ora-rg    Nodea            Yes          Online
                  Nodeb            Yes          Offline

# clrs status

=== Cluster Resources ===

Resource Name       Node Name        State      Status Message
-------------       ---------        -----      --------------
UADBPRD-vip         Nodea            Online     Online - LogicalHostname online.
                    Nodeb            Offline    Offline - LogicalHostname offline.

UADBPRD-ORA-LSN     Nodea            Online     Online 
                    Nodeb            Offline    Offline

UADBPRD-ORA-server  Nodea            Online     Online 
                    Nodeb            Offline    Offline

UADBPRD-HAS         Nodea            Online     Online
                    Nodeb            Offline    Offline
Nodea:#

In the next article ,we will see that how to configure the oracle Dataguard physical standby node with sun cluster/ Solaris cluster.

Hope this article is informative to you. Share it ! Comment it !! Be Sociable !!!