We have over 200 different servers that are running Oracle and every 2 months, we have our passwords expire.

Instead of having the DBA's go into every server to sync the passwords I would to have some sort of way of pushing the encrypted password in the Oracle DB to other databases.

Two things to keep in mind.

1) Every user may not be in every DB so if the user does not exist, the
code should not try to update that users password

2) I have all my DB's in a tnsnames.ora file or I can put into an easy to parse
file, so I can connect to every DB.


Does anybody foresee any problems this may cause? Secondly, does anybody know of a tool or some code around the net I can use as a starting place as
I am not an expert in PL/SQL.

Sorry for all the verbosity