PRIMECLUSTER Wizard for Oracle (PRIMEQUEST) 4.3 Configuration and Administration Guide

E.3 Oracle ASM of Oracle database 11g R2/12c R1 used

1. Install and configure PRIMECLUSTER
   Install and configure PRIMECLUSTER according to Software Release Guides and manuals of PRIMECLUSTER.
   

2. Install PRIMECLUSTER Wizard for Oracle
   Install PRIMECLUSTER Wizard for Oracle according to a Software Release Guide of PRIMECLUSTER Wizard for Oracle.
   

3. Set up the kernel parameter
   Set up the kernel parameter. See the step 1 of "Appendix C Oracle Grid Infrastructure Installation and Oracle ASM instance, Oracle Database Creation".
   

4. Create Grid user, Oracle user
   Create and set up the Oracle user and Grid user. See the step 2 of "Appendix C Oracle Grid Infrastructure Installation and Oracle ASM instance, Oracle Database Creation".
   

5. Set up shared disk units
   Set shared disk units that are managed by Oracle ASM. Set the Grid user to the owner of the device files of the shared disk.
   

6. Create userApplication with No Oracle resources
   Create userApplication with No Oracle resources and check the operation of userApplication. See the following:

   • 2.2.4 userApplication Creation (without Oracle Resources)

   • 2.2.5 userApplication Operation Check

   In single-node cluster operation, the settings for userApplication are as follows. For the attribute of the others, see the PRIMECLUTSER manuals.

   Attributes	Values
   AutoSwitchOver	Do not set the values.
   PersistentFault	1
   HaltFlag	no
   ShutdownPriority	Do not set the values.
   OnlinePriority	Do not set the values.

7. Start userApplication
   Start userApplication on operation node, and verify the shared disk units and the takeover IP address are enabled.
   

8. Install Oracle Grid Infrastructure software
   It is necessary to install Oracle Grid Infrastructure software and Oracle Database software.
   Install Oracle Grid Infrastructure software. See the step 6 of "Appendix C Oracle Grid Infrastructure Installation and Oracle ASM instance, Oracle Database Creation".
   

9. Install Oracle Database software
   Install Oracle Database software. See the step 7 of "Appendix C Oracle Grid Infrastructure Installation and Oracle ASM instance, Oracle Database Creation".
   

10. Create and set up an Oracle Database

    • In single-node cluster operation, create and set up an Oracle Database
      Create Oracle database and Oracle listener according to the Oracle Database manuals.
      

    • SYSTEM user password
      Register the Oracle SYSTEM user password. See "4.3 clorapass - Register Password for Monitoring".
      

    • Define the full path of the log file
      Define the full path of the alert log and the listener log. See "4.5 clgetoralog - Collect Troubleshooting Information".
      

    • Check Oracle database operation
      Check if the Oracle database operation is properly running by executing start and stop of Oracle instances and Oracle listeners manually.
      

11. Edit userApplication
    Register Oracle instance resources, the Oracle ASM resource and Oracle listener resources to userApplication that is created at the step 3. See "2.3.2.2 Environment configuration with Oracle Database 11g R2/12c R1".
    The setting of AutoRecover Flag is recommended for Oracle instance resources and Oracle listener resources. The availability is increased by restarting Oracle instance resources and Oracle listener resources automatically when an error is detected.

    Attributes	Values
    Flags	AutoRecover (A)

12. Check Operation of userApplication
    Check the operation of userApplication including Oracle resources. See "2.2.8 userApplication Operation Check".