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

3.3 Oracle SYSTEM user Password Change

You can change the Oracle SYSTEM user password without stopping operation by using the following steps on the node where userApplication is Online.

  1. Discontinue monitoring the Oracle instance resources

    Execute the following command to stop monitoring Oracle resources. In standby operation, execute it on the operating node. In single-node cluster operation, execute it on the one node.

    # /opt/FJSVclora/sbin/hvoradisable -a <userApplication>

    Be sure to check the following message in syslog before going to the next step:

    [Info] [0101] Fault Watching is disabled
  2. Change the Oracle SYSTEM user password

    Change the Oracle SYSTEM user password, or unlock SYSTEM user account.

    • Change the Oracle SYSTEM user password
      In standby operation, change the password on the operating node. In single-node cluster operation, change it on the one node.

      Example

      The following example shows how to change password to "oracle".

      # su - <Oracle user>
      $ sqlplus /nolog
      SQL> connect / as sysdba
      SQL> alter user system identified by oracle;
      SQL> exit
    • Unlock SYSTEM user account
      Refer to [Case 2] of "A.1.3 Warning State".

  3. Register the Oracle SYSTEM user password to PRIMECLUSTER Wizard for Oracle

    Register the Oracle SYSTEM user password to PRIMECLUSTER Wizard for Oracle using "clorapass" command.
    In standby operation, register the password on the operating node. In single-node cluster operation, register it on the one node.

    # /opt/FJSVclora/sbin/clorapass
    Enter OracleSID > sid           (Enter ORACLE_SID)
    Enter Password > ******        (Enter "oracle" for password.)
    Re-enter Password > ******     (Re-enter "oracle" for password.)
    finished
  4. Restart monitoring the Oracle instance resources

    Execute the following command to restart monitoring Oracle resources. In standby operation, execute it on the operation node. In single-node cluster operation, execute it on the one node.

    # /opt/FJSVclora/sbin/hvoraenable -a <userApplication>

    Be sure to check the following message in syslog after execution:

    [Info] [0102] Fault Watching is enabled

Information