Top
PRIMECLUSTER Wizard for Oracle (PRIMEQUEST) 4.3 Configuration and Administration Guide
FUJITSU Software
Chapter 2 Environment Setup > 2.2 Standby Operation > 2.2.7 userApplication Edit
PreviousNext

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 database 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. Execute 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 "Same"(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 Oracle ASM instance resource, refer to "2.3.2 Oracle 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

    It can contain the following characters. However, the character string must not start with the hyphen.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+

    OracleUser

    • Oracle instance resource, Oracle ASM instance resource(Oracle Database 11g R1)
      - Operating system user which belongs to OSDBA group.
      (refer to “Oracle User” of “2.2.2 Oracle Database Software Installation and Configuration”.)

    • Oracle ASM instance resource(Oracle Database 11g R2/12c R1)
      - Grid user

    It can contain the following characters. However, the character string must not start with the hyphen.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-

    StartTimeout

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

    StopTimeout

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

    AbortTimeout

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

    StopModeStop

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

    StopModeFail

    Oracle instance 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 instance. (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".

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

    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(M)".

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

    See

    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.

    It can contain the following characters. However, the character string must not start with the hyphen.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-

    OracleUser

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

    • Oracle listener resource(Oracle ASM is used with Oracle Database 11g R2/12c R1)
      - Grid user

    It can contain the following characters. However, the character string must not start with the hyphen.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-

    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.

    It can contain the following characters. However, the character string must not start with the hyphen.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-.

    StartTimeout

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

    StopTimeout

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

    Interval

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

    WatchTimeout

    No response time during monitoring Oracle listener. (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".

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

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

    It can contain the following characters.

    • 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz_-+/"`#$^&*(){}[]|;:<,>.?

    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(M)".

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

    See

    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.

PreviousNext
Copyright FUJITSU LIMITED 2015