Database Security Products (MOSC)

MOSC Banner

Importing the CDB TDE encryption keys from file when CDB is in mount mode

edited Nov 26, 2019 4:13PM in Database Security Products (MOSC) 3 commentsAnswered ✓

Hi All,


I am attempting to import the TDE keys from a file, when CDB is in mount mode. Although import is successful, the an error  "ORA-01109: database not open" is thrown.
I would like to know if this a valid workflow.

1. Start the CDB in mount mode

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1342173664 bytes

Fixed Size     9134560 bytes

Variable Size   872415232 bytes

Database Buffers   452984832 bytes

Redo Buffers     7639040 bytes

Database mounted.

SQL>

2. Next open the keystore


SQL> administer key management set keystore open identified by external store;

keystore altered.

SQL> select key_id from v$encryption_keys;

KEY_ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center