Storage Foundation for Oracle® RAC 8.0.2 Configuration and Upgrade Guide - AIX

To configure the Oracle service group manually for container 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 container and pluggable Oracle RAC resources to the service group:

   # hares -add cdb_resname Oracle oradb_grpname

   # hares -add pdb_resname Oracle oradb_grpname

9. Modify the attributes of the container and pluggable Oracle resources for the service group:

   For container Oracle resource:

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

   For pluggable Oracle resource:

   # hares -modify pdb_resname Owner oracle
   # hares -modify pdb_resname Home "db_home"
   # hares -modify pdb_resname StartUpOpt STARTUP
   # hares -modify pdb_resname ShutDownOpt IMMEDIATE

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

    • Localize the Sid attribute for the container Oracle resource:

      # hares -local cdb_resname Sid

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

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

    For pluggable databases that reside in administrator-managed container databases, perform the following steps:

    • Localize the Sid attribute for the pluggable Oracle resource:

      # hares -local pdb_resname Sid

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

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

    • Set the PDBName attribute for the pluggable Oracle database:

      # hares -modify pdb_resname PDBName pdbname

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

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

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

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

      # hares -modify cdb_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 cdb_resname IntentionalOffline
      # hares -modify cdb_resname IntentionalOffline 1
      # hares -modify cdb_resname MonitorOption 0

    For pluggable databases that reside in policy-managed container databases, perform the following steps:

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

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

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

      # hares -modify pdb_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 pdb_resname IntentionalOffline
      # hares -modify pdb_resname IntentionalOffline 1
      # hares -modify pdb_resname MonitorOption 0

    • Set the PDBName attribute for the pluggable Oracle database:

      # hares -modify pdb_resname PDBName pdbname

12. Set the dependency between the pluggable database resources and the corresponding container database resource:

    # hares -link pdb_resname cdb_resname

    Repeat this step for each pluggable database resource in a container database.

13. Repeat steps 8 to 12 for each container database.
14. Set the dependencies between the CFSMount resource and the CVMVolDg resource for the Oracle service group:

    # hares -link oradbmnt_resname
    						oradbdg_resname

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

    # hares -link db_resname
    						oradbmnt_resname

16. 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

17. Enable the Oracle service group:

    # hagrp -enableresources oradb_grpname

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

    # haconf -dump -makero

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

    # hagrp -online oradb_grpname -any