Home » RDBMS Server » Security » ora-28374 typed master key not found in wallet (11g, 11.2.0.1, Window XP)
ora-28374 typed master key not found in wallet [message #587890] |
Wed, 19 June 2013 04:04  |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
Dear All,
I am getting error "ora-28374 typed master key not found in wallet".
Let me explain you the steps.
steps-
1) created tablespace and user to the respective tablespace.
2) created table by issuing command as "CREATE TABLE TEST1 (SR_NO NUMBER(3), NAME VARCHAR2(30) ENCRYPT) DEFAULT TABLESPACE ENC". (by user - enc_user)
3) Inserted rows on to the table.
4) entry made in sqlnet.ora as
ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE)(METHOD_DATA=
(DIRECTORY=C:\app\Administrator\admin\test\encrypted_wallet/)))
5) issued command as sysdba -
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "ASHISH123";
6) restarted the database.
7) since i want to made it autologin. so I open wallet through the below mentioned path
program file >>oracle_home>> integrated management tool >> wallet
But when it asked the password I typed the same password but it was not accepting. So i made new wallet with the same specified path. Also I clicked on auto login.
8) Now, i have restarted the database and tried to issue the command "ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "suresh123";
While issuing the command, getting error "ora-28374 typed master key not found in wallet". "
i tried with the recreation of new folder again on the same path as -"C:\app\Administrator\admin\test\wallet"
and same entry updated on sqlnet.ora. But facing the same error.
Is there any way to re-create or modify the encryption of tablespace?
As it is testing database. I want to make it done. Kindly assist me to rectify the problem.
Regards,
Ishika
|
|
|
|
|
|
|
Re: ora-28374 typed master key not found in wallet [message #587897 is a reply to message #587894] |
Wed, 19 June 2013 04:45  |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
Dear All,
I had done mistake while doing entry on sqlnet.ora
Instead of below entry
ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE)(METHOD_DATA=
(DIRECTORY=C:\app\Administrator\admin\test\encrypted_wallet/)))
It should be like below
ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE)(METHOD_DATA=
(DIRECTORY=C:\app\Administrator\admin\test\encrypted_wallet\)))
since it is windows and marked "/" after wallet instead of "\". After doing changes on it, i can able to access encryption.
Regards,
Ishika
Regards,
Ishika
[Updated on: Wed, 19 June 2013 23:50] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Wed May 21 14:32:04 CDT 2025
|