OraFAQ Forum: Security » Reset Database vault owner password

Home » RDBMS Server » Security » Reset Database vault owner password (11.2.0.3.0 Linux x86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reset Database vault owner password [message #609237]

Tue, 04 March 2014 05:48

sandba00
Messages: 10
Registered: February 2014

Junior Member

Hi,

I had recently enabled database vault in Oracle 11gr2. Unfortunately I forgot the password of "database vault owner"
Now, if I try to reset the password of database vault owner from SYS or SYSTEM, its saying insufficient privileges. This is due to DB vault restricting SYS or SYSTEM user as the privilege alter user is removed.

Even for DB vault account manager, the password is same Sad

SQL> alter user dbvowner identified by *****;
alter user dbvowner identified by ****
*
ERROR at line 1:
ORA-01031: insufficient privileges

Can anyone please let me know how to reset the password of database vault owner .

Report message to a moderator

Re: Reset Database vault owner password [message #609240 is a reply to message #609237]

Tue, 04 March 2014 05:57

Michel Cadot
Messages: 68348
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Vault Administrator's Guide
Annex B Disabling and Enabling Oracle Database Vault

Quote:

You may need to disable Oracle Database Vault to perform upgrade tasks or correct erroneous configurations
...
The following situations require you to disable Oracle Database Vault:

• The Oracle Database Vault user accounts have been inadvertently locked or their passwords forgotten...
...

It is the first link in Google when you enter your title in search field.

Report message to a moderator

Re: Reset Database vault owner password [message #609242 is a reply to message #609240]

Tue, 04 March 2014 06:19

sandba00
Messages: 10
Registered: February 2014

Junior Member

Thanks Michel.
I missed this point.. I was looking out without disabling the db vault.

Report message to a moderator

Previous Topic:	Using "TCP/IP with SSL" protocol
Next Topic:	ORA-01917: user or role does not exist

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 04 00:35:13 CST 2023