You can change the Oracle SYSTEM user password without stopping operation by using the following steps on the node where userApplication is Online.
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
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
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
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
For the hvoradisable or hvoraenable command, see “4.1 hvoradisable - Discontinue Monitoring Resources”, “4.2 hvoraenable - Restart Monitoring Resources”.
For information on how to change the Oracle SYSTEM user password, refer to the Oracle manual.
For the clorapass command, refer to “4.3 clorapass - Register Password for Monitoring”.