hi, just starting to use Oracle 12.2.0.1.July 2017 PSU Enterprise Database.
When i copy/overlay one database with another, i will change the database links as such:
- get the password hash from sys.user$, store it
- change the password for that user
- login as that user
- drop and re-create all user database links to point to the correct databases (TEST, PRODuction, DEVelopment, etc.)
- re-connect as sys
- reset the user password from storage as in the first step.
This - will no longer work.
Oracle 12.2 has set the SYS.USER$.PASSWORD to NULL.
Any suggestions?
I thought of putting all the passwords in a table, encrypting it, and using Oracle Wallet to get the key. Unsure of this method.
Thank you, Steve