Oracle 23c New Features for DBA'sIn previous releases of Oracle, the database links and scheduler links password are stored in password column in sys.link$ and sys.scheduler$_link table, however the passwords are obfuscated not encrypted.
We can encrypt the obfuscated password in 18c using "alter database dictionary" command.
Create a keystore and define encryption method
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '/etc/ORACLE/WALLETS/orcl' IDENTIFIED BY password;
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "password";
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY "password" WITH BACKUP;
Alter dictionary to encrypt the credentials
ALTER DATABASE DICTIONARY ENCRYPT CREDENTIALS;
For all in a container database use
ALTER DATABASE DICTIONARY ENCRYPT CREDENTIALS CONTAINER = ALL;
Now the password columns in the link$ and scheduler$_link passwords are encrypted. When you do export and import you must provide the encryption password for wallet to ensure the passwords are decrypted while expdp/impdp
-Suresh
Follow Me!!!