artaydates
asked on
Encrypted Tablespace Error: ORA-28374: typed master key
Hi -
I have recently inherited an database that was previously copied from a system that has since been retired. The wallet that was used on the previous system was not copied to the new server, I have no way of retrieving, after creating a new wallet I recieved the ORA-28374 error, logically the error is due to keys not matching. I am trying to create a new encrypted tablespace so the objects can be copied to the new tables. But when trying to create the tables I get the same error. Is anyone of a solution for this issue?
SQL> CREATE TABLESPACE ENC_TLGP01_NEW DATAFILE
2 '/opt/app/TSSIDB02/oradata 01/dbf/enc _tlgp01TSS IDB02_01.d bf' SIZE 1024M AUTOEXTEND OFF
3 LOGGING
4 ONLINE
5 PERMANENT
6 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K
7 BLOCKSIZE 8K
8 SEGMENT SPACE MANAGEMENT AUTO
9 FLASHBACK ON
10 ENCRYPTION
11 DEFAULT STORAGE(ENCRYPT);
CREATE TABLESPACE ENC_TLGP01_NEW DATAFILE
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
I have recently inherited an database that was previously copied from a system that has since been retired. The wallet that was used on the previous system was not copied to the new server, I have no way of retrieving, after creating a new wallet I recieved the ORA-28374 error, logically the error is due to keys not matching. I am trying to create a new encrypted tablespace so the objects can be copied to the new tables. But when trying to create the tables I get the same error. Is anyone of a solution for this issue?
SQL> CREATE TABLESPACE ENC_TLGP01_NEW DATAFILE
2 '/opt/app/TSSIDB02/oradata
3 LOGGING
4 ONLINE
5 PERMANENT
6 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K
7 BLOCKSIZE 8K
8 SEGMENT SPACE MANAGEMENT AUTO
9 FLASHBACK ON
10 ENCRYPTION
11 DEFAULT STORAGE(ENCRYPT);
CREATE TABLESPACE ENC_TLGP01_NEW DATAFILE
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
ASKER
Unfortunately no - but I was trying to avoid the lost of data.
If it were possible then anyone that steals your data files would be able to un-encrypt them.
That sort of defeats the purpose of encrypting them to start with.
If there is absolutely no way to ever recover the wallet, if there is a way I think it would be Oracle Support that would know it but I wouldn't put any money on being able to do it given my first statement.
That sort of defeats the purpose of encrypting them to start with.
If there is absolutely no way to ever recover the wallet, if there is a way I think it would be Oracle Support that would know it but I wouldn't put any money on being able to do it given my first statement.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's the only thing that would make sense. Don't forget to close out the question.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
I want to copy and encrypted database from one machine to another not having the encryption key. I then want to force a way of reading the data.
Doesn't seem like it should be possible. Does it?