we copied 19c db from on premises to oci db systems , tde not enabled in on premises database
SQL> CREATE BIGFILE TABLESPACE USERS1 DATAFILE '+DATAC1' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE 10G;
CREATE BIGFILE TABLESPACE USERS1 DATAFILE '+DATAC1' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE 10G
*
ERROR at line 1:
ORA-28361: master key not yet set
Wallet keys are in open status , no issues while starting db with wallet
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC CON_ID
-------------------- ------------------------------------------------------------ ------------------------------ -------------------- --------- -------- --------- ----------
FILE /home/oracle/stgdb01/wallet_root/tde/ OPEN AUTOLOGIN SINGLE NONE NO 0
Login to database as sysdba and set keystore:
SQL> ADMINISTER KEY MANAGEMENT SET KEY USING TAG 'rotate_key' FORCE KEYSTORE IDENTIFIED BY "Password" WITH BACKUP USING 'backup_key';
keystore altered.
NOTE:By default, the keystore password is set to the value of the administration password that is specified when the database deployment is created from cloud console
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC CON_ID
--------------- ------------------------------------ ---------- -------------------- --------- -------- --------- ----------
FILE /home/oracle/stgdb01/wallet_root/tde/ OPEN AUTOLOGIN SINGLE NONE NO 0
Tablespace created without any error
SQL> CREATE BIGFILE TABLESPACE USERS1 DATAFILE '+DATAC1' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE 10G;
Tablespace created.
Thank you Raju, good post. Keep it up.
ReplyDeleteSuperb Raju. Its helped me a lot..Good one..
ReplyDelete