Error: "ORA-28374 "
Hi to all,
We had a 19c two node RAC database containing an encrypted TDE tablespace.
We have done a full export, deleted the original database, and imported it in a new 19c two node RAC database.
Deleted database was configured :
SQL>alter system set WALLET_ROOT='....../wallet' scope=spfile sid='*';
SQL> alter system set TDE_CONFIGURATION=”KEYSTORE_CONFIGURATION=FILE” SCOPE=BOTH SID = '*';
SQL> administer key management create keystore identified by ....;
SQL>administer key management create auto_login keystore from keystore'...../wallet/tde' identified by ........;
SQL> administer key management set key using tag 'oracledbwr_Tablespace_TDE' force keystore identified by ...... with backup using 'TDE_copia_seguridad' ;
Deleted database was configured :
SQL>alter system set WALLET_ROOT='....../wallet' scope=spfile sid='*';
SQL> alter system set TDE_CONFIGURATION=”KEYSTORE_CONFIGURATION=FILE” SCOPE=BOTH SID = '*';
SQL> administer key management create keystore identified by ....;
SQL>administer key management create auto_login keystore from keystore'...../wallet/tde' identified by ........;
SQL> administer key management set key using tag 'oracledbwr_Tablespace_TDE' force keystore identified by ...... with backup using 'TDE_copia_seguridad' ;
0