Oracle 12.1.0.2 EE 2-Node RAC
RHEL 6.7
A production database I have to duplicate has 4 tablespaces that were
created a while back to test TDE. It was never fully implemented, the data
in the tables in these tablespaces are copies of real data but aren't
accessed by the application or used at all.
The password for the keystore has been lost. It's auto_login on ASM:
WRL_TYPE WRL_PARAMETER STATUS
WALLET_TYPE WALLET_OR FULLY_BAC CON_ID
-------------------- -------------------- ------------------------------
-------------------- --------- --------- ----------
ASM +ACTIVE/ORCL/wallet/ OPEN
AUTOLOGIN SINGLE NO 0
Since we don't have the password, can I create a new auto_login keystore
for which the password will be retained, export or merge the contents
(which shouldn't require a password) into the new keystore, close the old
keystore which again should not require a password, change the sqlnet.ora
to point to the new keystore and breathe a sigh of relief?
There are some enhancement to Key Administration in 12.2, but with 12.1 is
my only choice to move to an unencrypted state to copy the tables to an
unencrypted tablespace?
