Storage Foundation for Oracle® RAC 7.4.1 Configuration and Upgrade Guide - Solaris

To configure the Oracle service group manually for traditional Oracle databases

1. Change the cluster configuration to read-write mode:

   # haconf -makerw

2. Add the service group to the VCS configuration:

   # hagrp -add oradb_grpname

3. Modify the attributes of the service group:

   # hagrp -modify oradb_grpname Parallel 1

   # hagrp -modify oradb_grpname SystemList node_name1 0  node_name2 1

   # hagrp -modify oradb_grpname AutoStartList node_name1 node_name2

4. Add the CVMVolDg resource for the service group:

   # hares -add oradbdg_resname CVMVolDg oradb_grpname

5. Modify the attributes of the CVMVolDg resource for the service group:

   # hares -modify oradbdg_resname CVMDiskGroup oradb_dgname
   # hares -modify oradbdg_resname CVMActivation sw
   # hares -modify oradbdg_resname CVMVolume oradb_volname

6. Add the CFSMount resource for the service group:

   # hares -add oradbmnt_resname CFSMount oradb_grpname

7. Modify the attributes of the CFSMount resource for the service group:

   # hares -modify oradbmnt_resname MountPoint "oradb_mnt"
   # hares -modify oradbmnt_resname BlockDevice \
   "/dev/vx/dsk/oradb_dgname/oradb_volname"

8. Add the Oracle RAC database instance to the service group:

   # hares -add db_resname Oracle oradb_grpname

9. Modify the attributes of the Oracle resource for the service group:

   # hares -modify db_resname Owner oracle
   # hares -modify db_resname Home "db_home"
   # hares -modify db_resname StartUpOpt SRVCTLSTART
   # hares -modify db_resname ShutDownOpt SRVCTLSTOP

10. For administrator-managed databases, perform the following steps:

    • Localize the Sid attribute for the Oracle resource:

      # hares -local db_resname Sid

    • Set the Sid attributes for the Oracle resource on each system:

      # hares -modify db_resname Sid oradb_sid_node1 -sys node_name1
      # hares -modify db_resname Sid oradb_sid_node2 -sys node_name2

11. For policy-managed databases, perform the following steps:

    • Modify the attributes of the Oracle resource for the service group:

      # hares -modify db_resname DBName db_name
      # hares -modify db_resname ManagedBy POLICY

    • Set the Sid attribute to the Sid prefix for the Oracle resource on all systems:

      # hares -modify db_resname Sid oradb_sid_prefix

      Note:

      The Sid prefix is displayed on the confirmation page during database creation. The prefix can also be determined by running the following command :

      # grid_home/bin/crsctl status resource ora.db_name.db -f | grep GEN_USR_ORA_INST_NAME@ | tail -1 | sed 's/.*=//' | sed 's/_[0-9]$//'

    • Set the IntentionalOffline attribute for the resource to 1 and make sure that the health check monitoring is disabled:

      # hares -override db_resname IntentionalOffline
      # hares -modify db_resname IntentionalOffline 1
      # hares -modify db_resname MonitorOption 0

12. For pluggable databases, perform the following steps:

    • Modify the attributes of the Oracle resource for the service group:

      # hares -modify db_resname DBName db_name
      # hares -modify pdb_resname PDBName pdb_name
      # hares -modify pdb_resname ManagedBy POLICY

    • Set the Sid attribute to the Sid prefix for the Oracle resource on all systems:

      # hares -modify db_resname Sid oradb_sid_prefix
      # hares -modify pdb_resname Sid orapdb_sid_prefix

      Note:

      The Sid prefix is displayed on the confirmation page during database creation. The prefix can also be determined by running the following command :

      # grid_home/bin/crsctl status resource ora.pdb_name.db -f | grep GEN_USR_ORA_INST_NAME@ | tail -1 | sed 's/.*=//' | sed 's/_[0-9]$//'

    • Set the IntentionalOffline attribute for the resource to 1 and make sure that the health check monitoring is disabled:

      # hares -override db_resname IntentionalOffline
      # hares -modify db_resname IntentionalOffline 1
      # hares -modify db_resname MonitorOption 0

      # hares -override pdb_resname IntentionalOffline
      # hares -modify pdb_resname IntentionalOffline 1
      # hares -modify pdb_resname MonitorOption 0

13. Set the dependencies between the CFSMount resource and the CVMVolDg resource for the Oracle service group:

    # hares -link oradbmnt_resname oradbdg_resname

14. Set the dependencies between the Oracle resource and the CFSMount resource for the Oracle service group:

    # hares -link db_resname oradbmnt_resname

15. Create an online local firm dependency between the oradb1_grp service group and the cvm service group:

    # hagrp -link oradb_grpname cvm_grpname online local firm

16. Enable the Oracle service group:

    # hagrp -enableresources oradb_grpname

17. Change the cluster configuration to the read-only mode:

    # haconf -dump -makero

18. Bring the Oracle service group online on all the nodes:

    # hagrp -online oradb_grpname -any