Sun Cluster Data Service for Oracle Application Server Guide for Solaris OS

ProcedureHow to Register and Configure Sun Cluster HA for Oracle Application Server as a Failover Service

This procedure assumes that you installed the data service packages during your initial Sun Cluster installation.

If you did not install the Sun Cluster HA for Oracle Application Server packages as part of your initial Sun Cluster installation, go to How to Install the Sun Cluster HA for Oracle Application Server Packages using the scinstall Utility.

Steps
  1. Become superuser on one of the nodes in the cluster that will host Sun Cluster.

  2. Register the SUNW.gds resource type.


    # scrgadm -a -t SUNW.gds
    
  3. Register the SUNW.HAStoragePlus resource type.


    # scrgadm -a -t SUNW.HAStoragePlus
    
  4. Register the SUNW.oracle_server and SUNW.oracle_listener resource type.


    # scrgadm -a -t SUNW.oracle_server
    # scrgadm -a -t SUNW.oracle_listener
    
  5. Create a failover resource group.


    # scrgadm -a -g Sun Cluster-failover-resource-group
    
  6. Create a resource for the Sun Cluster Disk Storage.


    # scrgadm -a -j Sun Cluster-has-resource  \
    -g Sun Cluster-failover-resource-group   \
    -t SUNW.HAStoragePlus  \
    -x FilesystemMountPoints=Sun Cluster -Infrastructure instance-mount-points
    
  7. Create a resource for the Sun Cluster Logical Hostname.


    # scrgadm -a -L -j Sun Cluster-lh-resource  \
    -g Sun Cluster-failover-resource-group  \
    -l Sun Cluster-logical-hostname
    
  8. Enable the failover resource group that now includes the Sun Cluster Disk Storage and Logical Hostname resources.


    # scswitch -Z -g Sun Cluster-failover-resource-group
    
  9. Create a resource for the Sun Cluster Oracle Database.


    Note –

    For detailed information about Sun Cluster HA for Oracle, refer to the Sun Cluster Data Services Installation and Configuration Guide.



    # 
    scrgadm -a -j Sun Cluster-ORACLE-resource \
    -t SUNW.oracle_server  \
    -g  Sun Cluster-failover-resource-group\
    -x Connect_string=<user/passwd>\
    -x ORACLE_SID=<Oracle 9iAS instance>\
    -x ORACLE_HOME=<Oracle 9iAS Infrastructure directory>  \
    -x Alert_log_file=<$ORACLE_HOME alert log file>
     
    #
    # scswitch -e -j Sun Cluster-ORACLE-resource
    
  10. Create a resource for the Sun Cluster Oracle Listener.


    Note –

    For detailed information about Sun Cluster HA for Oracle, refer to the Sun Cluster Data Services Installation and Configuration Guide.



    # scrgadm -a -j Sun Cluster-ORALSR-resource \
    -t SUNW.oracle_listener  \
    -g  Sun Cluster-failover-resource-group\
    -x Listener_name=<Instance>\
    -x ORACLE_HOME=<Oracle 9iAS Infrastructure directory>\
    
    #
    # scswitch -e -j Sun Cluster-ORALSR-resource
    
  11. Create the Oracle 9iAS Infrastructure resources.


    Note –

    Refer to Step 13 for Oracle 10g AS Infrastructure


    Edit the 9ias_config file and follow the comments with that file, for example


    #
    # Copyright 2004 Sun Microsystems, Inc.  All rights reserved.
    # Use is subject to license terms.
    #
    # This file will be sourced in by 9ias_register and the parameters
    # listed below will be used.
    #
    # These parameters can be customized in (key=value) form
    #
    #            RG - name of the SC resource group containing the resources
    #     RS_OIDMON - name of the SC Oracle Internet Directory Monitor resource
    #    RS_OIDLDAP - name of the SC Oracle Internet Directory resource
    #       RS_OPMN - name of the SC Oracle Process Monitor Notification resource
    #         RS_EM - name of the SC Enterprise Manager Web site resource
    #
    #       Note: Only one Enterprise Manager is required if multiple
    #               infrastructure instances are being deployed.
    #
    #             Omit the value to RS_EM if you do not require a SC resource
    #               for the Enterprise Manager.
    #
    #   ORACLE_HOME - name of the Oracle home directory
    #    ORACLE_SID - name of the Oracle SID
    #    OIAS_LHOST - name of the Oracle 9iAS Infrastructure logical hostname
    #     OIAS_USER - name of the Oracle 9iAS Infrastructure userid
    #    OIAS_ADMIN - name of the Oracle 9iAS Internet Directory Admin password
    #    OIAS_INFRA - name of the Oracle 9iAS Infrastructure /var/opt/oracle
    #     OIAS_FQDN - name of the Oracle 9iAS fully qualified domainname
    #     OIAS_OPMN - name of the Oracle 9iAS OPMN instance names to start
    #               e.g. OIAS_OPMN=ohs,OC4J_DAS or ALL
    #       ALL indicates all instance names in $ORACLE_HOME/opmn/conf/opmn.xml
    #
    #         RS_LH - name of the SC Logical Hostname resource
    #        RS_HAS - name of the SC Oracle 9iAS HAStoragePlus resource
    #     RS_ORACLE - name of the SC Oracle resource
    #     RS_ORALSR - name of the SC Oracle Listener resource
    #
     
    RG=
    RS_OIDMON=
    RS_OIDLDAP=
    RS_OPMN=
    RS_EM=
     
    ORACLE_HOME=
    ORACLE_SID=
    OIAS_LHOST=
    OIAS_USER=
    OIAS_ADMIN=
    OIAS_INFRA=
    OIAS_FQDN=
    OIAS_OPMN=
     
    RS_LH=
    RS_HAS=
    RS_ORACLE=
    RS_ORALSR=

    The following is an example for Sun Cluster for Oracle 9iAS Infrastructure.


    RG=9ias-infra-rg
    RS_OIDMON=9ias-oidmon-res
    RS_OIDLDAP=9ias-oidldap-res
    RS_OPMN=9ias-opmn-res
    RS_EM=9ias-em-res
     
    ORACLE_HOME=/global/ora9ias/infra
    ORACLE_SID=iasdb
    OIAS_LHOST=ora9ias
    OIAS_USER=oraprod
    OIAS_ADMIN=1as_admin
    OIAS_INFRA=/var/opt/oracle or 
    		/var/opt/oracle_infra if the  middle tier is also installed and
    			 /var/opt/oracle was renamed to /var/opt/oracle_infra
     OIAS_FQDN=ora9ias.com
    OIAS_OPMN=ohs/oc4j_das or 
    		all if all components are required
    RS_LH=9ias-lhs-res
    RS_HAS=9ias-has-res
    RS_ORACLE=9ias-oracle-res
    RS_ORALSR=9ias-oralsr-res
    

    # ./9ias_register
    
  12. Enable each Oracle 9iAS Infrastructure resource.


    # scstat
    #
    # scswitch -e -j Sun Cluster-OIDMON-resource
    # scswitch -e -j Sun Cluster-OIDLDAP-resource
    # scswitch -e -j Sun Cluster-OPMN-resource
    # scswitch -e -j Sun Cluster-EM-resource
    
  13. Create the Oracle 10g AS Infrastructure resources.


    Note –

    Refer to Step 11 for Oracle 9iAS Infrastructure


    Edit the 10gas_config file and follow the comments with that file, for example


    #
    # Copyright 2004 Sun Microsystems, Inc.  All rights reserved.
    # Use is subject to license terms.
    #
    # This file will be sourced in by 10gas_register and the parameters
    # listed below will be used.
    #
    # These parameters can be customized in (key=value) form
    #
    #            RG - name of the SC resource group containing the resources
    #       RS_OPMN - name of the SC Oracle Process Monitor Notification resource
    #         RS_EM - name of the SC Enterprise Manager Web site resource
    #
    #   ORACLE_HOME - name of the Oracle home directory
    #    ORACLE_SID - name of the Oracle SID
    #    OIAS_LHOST - name of the Oracle 10gAS Infrastructure logical hostname
    #     OIAS_USER - name of the Oracle 10gAS Infrastructure userid
    #    OIAS_ADMIN - name of the Oracle 10gAS Internet Directory Admin password
    #    OIAS_INFRA - name of the Oracle 10gAS Infrastructure /var/opt/oracle
    #     OIAS_FQDN - name of the Oracle 10gAS fully qualified domainname
    #     OIAS_OPMN - name of the Oracle 10gAS ias-components
    #               e.g. OIAS_OPMN=OID/HTTP_Server/OC4J or OIAS_OPMN=all
    #
    #       ALL indicates all the installed ias-components
    #
    #         RS_LH - name of the SC Logical Hostname resource
    #        RS_HAS - name of the SC Oracle 10gAS HAStoragePlus resource
    #     RS_ORACLE - name of the SC Oracle resource
    #     RS_ORALSR - name of the SC Oracle Listener resource
    #
     
    RG=
    RS_OPMN=
    RS_EM=
     
    ORACLE_HOME=
    ORACLE_SID=
    OIAS_LHOST=
    OIAS_USER=
    OIAS_ADMIN=
    OIAS_INFRA=
    OIAS_FQDN=
    OIAS_OPMN=
     
    RS_LH=
    RS_HAS=
    RS_ORACLE=
    RS_ORALSR=

    The following is an example for Sun Cluster for Oracle 10g AS Infrastructure.


    Note –

    The values for OIAS_ADMIN and OIAS_FQDN are not used within the Sun Cluster HA for Oracle Application Server for Oracle 10g AS, however you need to supply a value for the registration script and therefore can supply the value dummy.



    RG=10gas-infra-rg
    RS_OPMN=10gas-opmn-res
    RS_EM=10gas-em-res
     
    ORACLE_HOME=/global/ora10gas/infra
    ORACLE_SID=iasdb
    OIAS_LHOST=ora10gas
    OIAS_USER=oraprod
    OIAS_ADMIN=dummy
    OIAS_INFRA=/var/opt/oracle or 
    		/var/opt/oracle_infra if the  middle tier is also installed and
    			 /var/opt/oracle was renamed to /var/opt/oracle_infra
    OIAS_FQDN=dummy
    OIAS_OPMN=OID/HTTP_Server/OC4J or 
    		all if all components are required
    RS_LH=10gas-lhs-res
    RS_HAS=10gas-has-res
    RS_ORACLE=10gas-oracle-res
    RS_ORALSR=10gas-oralsr-res
    

    # ./10gas_register
    
  14. Enable each Oracle 10g AS Infrastructure resource.


    # scstat
    #
    # scswitch -e -j Sun Cluster-OPMN-resource
    # scswitch -e -j Sun Cluster-EM-resource