ORA-46697: Keystore Password Required. On PDB Switchover

(Doc ID 2378945.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Database as a Service - Version N/A and later
Information in this document applies to any platform.


When trying PDB switchover on an TDE encrypted CDB I get the following error:

However, ALTER PLUGGABLE DATABASE statement does not provide an option to provide keystore password. CREATE PLUGGABLE DATABASE has a "keystore identified by" but not ALTER PLUGGABLE DATABASE.

Note that when the command fails, the PDB remains now in DBA_PDBS with status relocated but not visible from V$PDBS so that it cannot be dropped.




Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms