Getting the encrypted password

After you change the database schema users password and deployed your topology, you need to edit the Tivoli® Netcool® Performance Manager components configuration files.

1. Log in as oracle user.
2. Log in to SqlPlus by entering the following command:

   $ sqlplus "/as sysdba"

3. Run the following command to get the new encrypted password from REG$DCCONFIG table.

   For example:

   
   $ SELECT DISTINCT str_value 
     	FROM pv_admin.reg$dcconfig 
     	WHERE str_name='DB_PASSWORD';
   	
   	STR_VALUE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   	----------------------------
   	BFCACLDBCGDHCDAOAPGDGCGH
   

   Take note that the output result BFCACLDBCGDHCDAOAPGDGCGH here is the new (updated) password value.

4. On the DB2 database host, log in as db2 user.
5. Run the following command to connect to the DB2 database:

   clpplus -nw <ADMIN_USER>/<ADMIN_PASSWORD>@localhost:60000/<SID>

   For example:

   $ clpplus -nw PV_ADMIN/PV@localhost:60000/PV

6. Run the following command to get the new encrypted password from REG$DCCONFIG table.

   For example:

   
   $ SELECT DISTINCT str_value 
            FROM pv_admin.reg_dcconfig 
            WHERE str_name='DB_PASSWORD';
   	
   	STR_VALUE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
   	----------------------------
   	BFCACLDBCGDHCDAOAPGDGCGH
   

   Take note that the output result BFCACLDBCGDHCDAOAPGDGCGH here is the new (updated) password value.