Top
PRIMECLUSTER Wizard for Oracle 4.3 Configuration and Administration Guide

2.2.7 userApplication Edit

Register Oracle resources in userApplication that was created at "2.2.4 userApplication Creation (without Oracle Resources)".

In standby operation, userApplication is configured as follows.

Note that userApplication resource (Ora_App1) is being created and added in this section.

Note

  • Check if Oracle is properly running by starting and stopping the Oracle instance and Oracle listener manually.

  • Stop the Oracle instance, Oracle listener, and RMS on all the nodes in a cluster system before starting next section.

  • Do not create multiple resources for the same an Oracle instance or a Listener.

See

For further details, refer to the "PRIMECLUSTER Installation and Administration Guide".

2.2.7.1 Oracle Resource Creation and Registration

The following example shows how to configure the Oracle environment.

  1. Executed the following command on any one of the cluster nodes.
    (Configuration name specified at "2.2.4 userApplication Creation (without Oracle Resources)" also should be specified as <Configuration Name>.)

    # hvw -n <Configuration Name>

  2. Select Application-Edit in the "Main configuration menu" screen.

  3. Select userApplication (displayed in capital letters) created at "2.2.4 userApplication Creation (without Oracle Resources)".

  4. Select Oracle(-) in the "Settings of turnkey wizard "WIZSTANDBY"" screen.

  5. Add Oracle instances and Oracle listeners in the Oracle setup screen.

    Attributes

    Description

    AdditionalInstance

    Add an Oracle instance resource.

    AdditionalListener

    Add an Oracle listener resource.

    StartPriority

    Set up the startup order of the Oracle instance and Oracle listener. The default is "Simultaneous startup".

    Example

    StartPriority

    If a shared server configuration or dynamic service information is used, specify "Listener" for the StartPriority attribute.

  6. Add Oracle instance resource.
    Select AdditionalInstance, FREECHOICE and enter ORACLE_SID.

    Information

    An Oracle instance resource name on RMS is based on the ORACLE_SID <OracleSID> entered on this step.

    ORACLE_Ora_<ApplicationName>_<OracleSID>

    This resource name has the following convention and rules.

    • The resource name must be up to 39 characters.

    • "ORACLE_Ora_" is a fixed word.

    • For information on how to set up <ApplicationName>, refer to the step "4" of "2.2.4.1 userApplication creation".

    Note

    For addition of ASM instance resource, refer to "2.3.2 ASM (Automatic Storage Management)".

  7. Edit advanced settings of Oracle instance resource.

    The settings for Oracle instance resource are as follows:

    Attributes

    Description

    OracleSID

    ORACLE_SID

    OracleUser

    StartTimeout

    Timeout duration of Oracle startup. (seconds)
    Default: 600 (300 - 86400)

    StopTimeout

    Timeout duration of Oracle stop. (seconds)
    Default: 180 (60 - 86400)

    AbortTimeout

    Timeout duration of forced termination in the event of an Oracle stop error. (seconds)
    Default: 60 (60 - 86400)

    StopModeStop

    Oracle stop mode in normal time.
    Default: Immediate mode (abort, immediate, transactional)

    StopModeFail

    Oracle stop mode in the event of a failure.
    Default: Abort mode (abort, immediate)

    Interval

    Monitoring interval of Oracle instance. (seconds)
    Default: 30 (5 - 86400)

    WatchTimeout

    No response time during monitoring Oracle. (seconds)
    Default: 300 (30 - 3600)

    PreOnlineScript

    Executed before online processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    PostOnlineScript

    Executed after online processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    PreOfflineScript

    Executed before offline processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    PostOfflineScript

    Executed after offline processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    FaultScript

    Executed when a fault occurs.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    Flags

    NullDetector
    (D)

    If you do not want to monitor the resource, select this flag "NullDetector(D)".

    Default: "NullDetector(D)" is not selected.

    AutoRecover
    (A)

    If you want to restart the resource before failover when a resource failure occurs, select this flag "AutoRecover(A)".

    Default: "AutoRecover(A)" is not selected.

    MonitorOnly
    (M)

    If you do not want to generate a failover when a resource failure occurs, select this flag "MonitorOnly(N)".

    Default: "MonitorOnly(N)" is not selected.

    See

    • For details about *Script, refer to "2.3.1 Oracle Online/Offline Script".

    • For details about Flags, refer to "11 Appendix—Attributes" of "PRIMECLUSTER RMS with Wizard Tools Configuration and Administration Guide".

    Note

    • If NullDetector is enabled, the AutoRecover and MonitorOnly attribute will automatically be disabled.

    • If "Instance" or "Listener" is specified for StartPriority, MonitorOnly cannot be enabled. To enable it, specify "Same".

    • Flags=<Abbreviation> indicates that the flag attribute is enabled.

  8. Select SAVE+RETURN to quit advanced settings.

  9. Add Oracle listener resource.
    Select AdditionalListener, FREECHOICE and enter Listener name.

    Information

    An Oracle listener resource name on RMS is based on the listener name <ListenerName> entered on this step.

    LISTENER_Ora_<ApplicationName>_<ListenerName>

    This resource name has the following convention and rules.

    • The resource name must be up to 39 characters.

    • "LISTENER_Ora_" is a fixed word.

    • For information on how to set up <ApplicationName>, refer to the step "4" of "2.2.4.1 userApplication creation".

  10. Edit advanced settings of Oracle listener resource.

    The settings for Oracle listener resource are as follows:

    Attributes

    Description

    ListenerName

    Listener name.

    OracleUser

    • Oracle listener resource(Oracle 11g R1), Oracle listener resource(ASM is not used with Oracle 11g R2)Oracle
      - Operating system user for Listener control.

    • Oracle listener resource(ASM is used with Oracle 11g R2)
      - Grid user

    TNSName

    Network service for Listener monitoring
    Execute "tnsping" command to monitor the Oracle listener when TNSName is set (tnsnames.ora). If the TNSName is omitted, process monitoring of the Oracle listener will only be performed.

    StartTimeout

    Timeout during Oracle startup. (seconds)
    Default: 180 (120 - 86400)

    StopTimeout

    Timeout during Oracle stop. (seconds)
    Default: 60 (60 - 86400)

    Interval

    Monitoring interval of Oracle instance. (seconds)
    Default: 30 (5 - 86400)

    WatchTimeout

    No response time during monitoring Oracle. (seconds)
    Default: 300 (30 - 3600)

    PreOnlineScript

    Executed before online processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    PostOnlineScript

    Executed after online processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    PreOfflineScript

    Executed before offline processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    PostOfflineScript

    Executed after offline processing.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    FaultScript

    Executed when a fault occurs.
    The script must be entered with a full path name. If you are specifying arguments, separate the arguments with "blanks".
    No default

    Flags

    NullDetector
    (D)

    If you do not want to monitor the resource, select this flag "NullDetector(D)".

    Default: "NullDetector(D)" is not selected.

    AutoRecover
    (A)

    If you want to restart the resource before failover when a resource failure occurs, select this flag "AutoRecover(A)".

    Default: "AutoRecover(A)" is selected.

    MonitorOnly
    (M)

    If you do not want to generate a failover when a resource failure occurs, select this flag "MonitorOnly(N)".

    Default: "MonitorOnly(N)" is not selected.

    See

    • For details about *Script, refer to "2.3.1 Oracle Online/Offline Script".

    • For details about Flags, refer to "11 Appendix—Attributes" of "PRIMECLUSTER RMS with Wizard Tools Configuration and Administration Guide".

    Note

    • If NullDetector is enabled, the AutoRecover and MonitorOnly attribute will automatically be disabled.

    • If "Instance" or "Listener" is specified for StartPriority, MonitorOnly cannot be enabled. To enable it, specify "Same".

    • Flags=<Abbreviation> indicates that the flag attribute is enabled.

  11. Select SAVE+RETURN to quit advanced settings.

  12. Confirm that Oracle instance and listener resources have been set, and then select SAVE+EXIT.
    In the next screen, confirm that Oracle(Ora_xxx) have been set.

2.2.7.2 Other Resource Creation and Registration

  1. If you have any other required resources, register and create them in the "Settings of turnkey wizard "WIZSTANDBY"" screen.

    Information

    Other resources (ex. Procedure resource, resource concerning backup software) should be registered here.
    For details of them, refer to the each manual. (For Procedure resource, refer to "PRIMECLUSTER Installation and Administration Guide".)

  2. Select SAVE+EXIT to return Main configuration menu.

  3. If you have any other required userApplications, create them in Main configuration menu screen.

2.2.7.3 Configuration-Generate and Configuration-Activate

  1. Execute Configuration-Generate and Configuration-Activate.

  2. Select QUIT and terminate RMS Wizard.

Information

After set up userApplication, the settings in this section can be confirmed with "clorainfo -c" command. Refer to "4.6 clorainfo - Display Resource Configuration and Monitoring Status" for details.