Home » RDBMS Server » Security » Reset Database vault owner password (11.2.0.3.0 Linux x86_64)
Reset Database vault owner password [message #609237] Tue, 04 March 2014 05:48 Go to next message
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 .
Re: Reset Database vault owner password [message #609240 is a reply to message #609237] Tue, 04 March 2014 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59422
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.

Re: Reset Database vault owner password [message #609242 is a reply to message #609240] Tue, 04 March 2014 06:19 Go to previous message
sandba00
Messages: 10
Registered: February 2014
Junior Member
Thanks Michel.
I missed this point.. I was looking out without disabling the db vault.
Previous Topic: Using "TCP/IP with SSL" protocol
Next Topic: ORA-01917: user or role does not exist
Goto Forum:
  


Current Time: Thu Oct 23 12:25:10 CDT 2014

Total time taken to generate the page: 0.24467 seconds