Top
PRIMECLUSTER Wizard for Oracle 4.5 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 scalable operation with Oracle RAC, execute it on all the cluster nodes. 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 disable

    or

    INFO: 0101: Fault Watching is disabled
  2. Change the Oracle SYSTEM user password

    Change the Oracle SYSTEM user password.
    In standby operation, change the password on the operating node. In scalable operation with Oracle RAC, change the password on any one of the nodes. In single-node cluster operation, change the password 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

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

    Register the Oracle SYSTEM user password to PRIMECLUSTER Wizard for Oracle using the clorapass command.
    In standby operation, register the password on the operating node. In scalable operation with Oracle RAC, register the passwords for each instance on any one of the nodes. In single-node cluster operation, execute 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 operating node. In scalable operation with Oracle RAC, execute it on all the cluster nodes. 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 enable

    or

    INFO: 0102: Fault Watching is enabled

Information