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

E.2 Oracle ASM of Oracle Database 11g 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. Install and configure Oracle Database software
   Set up the kernel parameter, create Oracle user and install Oracle Database software. See "2.2.2 Oracle Database Software Installation and Configuration".
   

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

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

6. Edit userApplication
   Register Oracle instance resources, the Oracle ASM resource and Oracle listener resources to userApplication that is created at the step 4. See "2.3.2.1 Environment configuration with Oracle Database 11g 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)

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