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 Go to next message
ishika_20
Messages: 334
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 #587891 is a reply to message #587890] Wed, 19 June 2013 04:12 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
You've hit a known bug (known to me, anyway!) you cannot re-crate the wallet. See MOS note 988022.1.
Re: ora-28374 typed master key not found in wallet [message #587893 is a reply to message #587891] Wed, 19 June 2013 04:21 Go to previous messageGo to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear John,

As of now, I have no access to MOS. Please post it here. Now, to enable wallet, i need to re-create database, again???
There is no other way to proceed?

Regards,
Ishika
Re: ora-28374 typed master key not found in wallet [message #587894 is a reply to message #587893] Wed, 19 June 2013 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 57644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I have no access to MOS. Please post it here


No, no one can post the content of a Metalink note.
It is protected by copyright laws.

Regards
Michel

[Updated on: Wed, 19 June 2013 04:31]

Report message to a moderator

Re: ora-28374 typed master key not found in wallet [message #587896 is a reply to message #587893] Wed, 19 June 2013 04:42 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
If you do not have a MOS account, you cannot get the patch. I don't know of any workaround.
Re: ora-28374 typed master key not found in wallet [message #587897 is a reply to message #587894] Wed, 19 June 2013 04:45 Go to previous message
ishika_20
Messages: 334
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

Previous Topic: OS authentication - using sqlldr but dealing with different schemas
Next Topic: How to find the user and ipaddress from oracle database
Goto Forum:
  


Current Time: Thu Apr 24 02:28:23 CDT 2014

Total time taken to generate the page: 0.13363 seconds