PRIMECLUSTER Wizard for Oracle Configuration and Administration Guide 4.2 - Linux for Itanium -

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 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 10g, change the password on any one of the nodes.

   
   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 Wizard for Oracle

   Register the Oracle system user password to Wizard for Oracle using the clorapass command.
   In standby operation, register the password on the operating node. In scalable operation with Oracle RAC 10g, 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 enabled

• For the "hvoradisable" command, refer to "4.1 hvoradisable - Discontinue 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".
• For the "hvoraenable" command, refer to "4.2 hvoraenable - Restart Monitoring Resources".