I. Introduction

Several i3 components require the ability to log into the Performance Warehouse database.  The Indepth for Oracle component requires the ability to log into the monitored Oracle instance.  If any of the passwords for these Oracle accounts are changed, the corresponding i3 component needs to be notified of the new password.  This TechNote describes how to perform this update..

If running i3 6.x, refer to TechNote  http://support.veritas.com/docs/282253 .

II. Procedure

1. Download the attached change_pass_282252.zip file

2. Unpack it in a convenient temporary location

3. Copy the enclosed change_pass.jar file to <i3_root>/java/1.4.2/lib/

4. Copy the enclosed change_pass.sh (or .bat on Win32) to <i3_root>

5. From the <i3_root> directory, run the script (.sh or .bat) using the following syntax:
change_pass.sh -[p|o] <oracle_server> <oracle_sid> <new_password>

The first argument is defined as follows:
  -p: when changing the Oracle database password used by Alerts or Performance Warehouse
  -o: when changing the Oracle database password used by Indepth for Oracle on the monitored instance

As an example, here is the command to change the password used by the Performance Warehouse Focal Point:

 change_pass.sh -p  OracleServer OracleSID NewPaSSw0rd

Note: The <oracle_server> and <oracle_sid> values need to be the values as displayed in AdminPoint.

6.  Using AdminPoint, restart the appropriate i3 component that was changed.  If the -p parameter was used, make sure to restart the Alerts FocalPoint as well

7. If the database password was changed for the Performance Warehouse Oracle user, in addition to running the command line change above, each Indepth for Oracle schema must be updated to rebuild the pss_pw_link that is used to connect that instance to the Performance Warehouse.

Use the following syntax to recreate the database link:

Use appropriate values for <pw_user_id>, <pw_user_pass>, <pw_host_name>, <pw_port>, <pw_sid>. These values can be found in <i3_root>/products/i3fp/registry/connection-pools/jdbc/pools.xml.