Top
PRIMECLUSTER Wizard for Oracle 4.2 Configuration and Administration Guide

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 command as follows on all the cluster nodes.

    # 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 Oracle9i RAC, Oracle RAC 10g or later, change the password on any one of the nodes.

    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 Oracle9i RAC, Oracle RAC 10g or later, register the passwords for each instance on any one of the nodes.

    # /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 command as follows on all the cluster nodes.

    # 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

See