Reason for change
To comply with SLAC's new database password policy we must change the database passwords every 6 months. We have switched to using Oracle wallet to make this process as painless as possible. Oracle wallet will enable us to change the oracle password without any application downtime.
We have one remaining application (data catalog crawler) which needs to be updated to use Oracle wallet. We can then change the last oracle password used by pipeline II and the data catalog. This must be done by April 30.
Test Procedure
The change to the data catalog crawler has been tested on the DEV database. We have previously tested changing passwords with oracle wallet and do not anticipate any problems. We will change the password on TEST, DEV and PROD databases (in that order).
Rollback procedure
It will be easy to rollback to the old version of the data catalog crawler should any problems occur.