This section explains how to create an Oracle resource newly and register it to an existing userApplication that does not include any Oracle instance resource and Listener resource.
For further details, refer to “PRIMECLUSTER Installation and Administration Guide”.
Example
To create an Oracle instance resource and(or) a Listener resource newly and register them(it) to an existing userApplication including Gds, Fsystem and Gls resources already.
In the standby operation, it is the same as the procedure in “2.2.7.2 Oracle Resource Creation”.
Stop RMS on all nodes.
Start up userApplication Configuration Wizard.
Note
If you create and register an Oracle RAC instance resource or a Listener resource in the Oracle RAC Scalable Operation, start up Oracle Clusterware on all nodes.
For details, see “2.3.5 userApplication with Oracle RAC Instances and Listeners”.
Select “Remove userApplication or Resource” in the “userApplication Configuration menu” screen, and click “Next”.
Select the existing userApplication (e.g. userApp_1) from the list in the “List of userApplication and resource” screen, and click “Remove”.
After that, click “userApplication” to reply to the displayed message “0807 Do you want to remove only selected userApplication (userApplication_name)? Do you want to remove all the resources userApplication?”
Note
Do not click “All” to reply to the message. Not only the userApplication but also existing resources will be removed.
Select “Create Resource” in the “userApplication Configuration menu” screen, and click “Next”.
Select “Oracle” from the “Resource type” list in the “Create Resource” screen, and click “Next”.
Select a resource that one wants to create from the menu in the “Set up Resource” screen, and click “Next”.
In the Standby Operation
If you create and register an Oracle instance resource or an Oracle ASM instance resource, select “AdditionalInstance” here, and click “Next”. After that, create and set the resource according to the steps 4, 5 of “2.2.7.2 Oracle Resource Creation”.
If you create and register a Listener resource, select “AdditionalListener” here, and click “Next”. After that, create and set the resource according to the steps 6, 7 of “2.2.7.2 Oracle Resource Creation”.
In the Oracle RAC 11g R2/12c R1 Scalable Operation
If you create and register an Oracle Clusterware resource, select “AdditionalOracle11gR2/12cR1Clusterware” here, and click “Next”. After that, create and set the resource according to the steps 3 to 5 of “2.3.4 userApplication with Oracle Clusterware”.
If you create and register an Oracle RAC instance resource, select “AdditionalRAC11gR2/12cR1Instance” here, and click “Next”. After that, create and set the resource according to the steps 7 to 11 of “2.3.5 userApplication with Oracle RAC Instances and Listeners”.
If you create and register an Oracle RAC listener resource, select “AdditionalRAC11gR2/12cR1Listener” here, and click “Next”. After that, create and set the resource according to the steps 13 to 17 of “2.3.5 userApplication with Oracle RAC Instances and Listeners”.
In the Single-Node Cluster Operation
If you create and register an Oracle instance resource or an Oracle ASM instance resource, select “AdditionalInstance” here, and click “Next”. After that, create and set the resource according to the steps 4, 5 of “2.2.7.2 Oracle Resource Creation”.
If you create and register a Listener resource, select “AdditionalListener” here, and click “Next”. After that, create and set the resource according to the steps 6, 7 of “2.2.7.2 Oracle Resource Creation”.
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) |
Repeat the step 7 as many times as needed.
Select “Create userApplication” in the “userApplication Configuration menu” screen, and click “Next”.
After that, create a userApplication including the Oracle resource.
In the Standby Operation
For further details of the attributes of userApplication, refer to “2.2.3 userApplication Creation”.
In the Oracle RAC 11g R2/12c R1 Scalable Operation
For further details of the attributes of userApplication, refer to “2.3.3 userApplication and Resource Configuration”.
In the 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. |
Click “End” in the “userApplication Configuration menu” screen, and terminate userApplication Configuration Wizard.
