![]() ![]() Then, I have to open the PDB, switch to it, and export the key: You don’t export the container database (CDB) key. ORA-46680: master keys of the container database must be exported SYS TDE IN PDB SOFTWARE KEYSTORE LOCAL PDB6 PDB6Ģ2:22:51 SQL> alter pluggable database PDB6 close immediate Ģ2:23:06 SQL> alter pluggable database PDB6 unplug into '/var/tmp/PDB6.xml' Īlter pluggable database PDB6 unplug into '/var/tmp/PDB6.xml' SYS TDE IN PDB SOFTWARE KEYSTORE LOCAL CDB$ROOT CDB$ROOTģ pdb6 Adnhnu. CREATOR KEY_USE KEYSTORE_TYPE ORIGIN CREATOR_PDBNAME ACTIVATING_PDBNAMEġ cdb1 AcyH+Z. ![]() SQL> select con_id,tag,substr(key_id,1,6)||'.' "KEY_ID.",creator,key_use,keystore_type,origin,creator_pdbname,activating_pdbname from v$encryption_keys ĬON_ID TAG KEY_ID. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Here I’ll unplug PDB6 from CDB1 and plug it into blogs]$ connect as sysdba Usually, you can be guided by the error messages, but this one needs a little explanation and an example. ![]() You cannot just copy the wallet because the wallet contains all CDB keys. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |