Tuesday, July 10, 2012

Re-seting Oracle VM Manager Password for ADMIN or Any other user

If you have ever lost the password for Admin user for Oracle VM Manager you need to reset it from Back End DB. 

--Login to database as SYS user or OVS user
-bash-3.2$ . oraenv
ORACLE_SID = [XE] ?
-bash-3.2$ ./sqlplus ovs/ovs@XE

-- Take a backup from OVS_USER table
SQL> create table OVS_USER_BKP as select * from OVS_USER;

SQL> select * from ovs_user_bkp;



         1 admin                                                                                                   admin@xxxxx.com                                                                                   z+Ht76IxU1FHSXkRLH6/rQ==                                                                                            Unlocked


-- Update the password 
SQL> UPDATE OVS_USER set password='admin' where account_name='admin';
1 row updated.


-- Encrypt the password 
SQL> UPDATE OVS_USER set password=create_encrypt_passwd('admin') where account_name='admin';
1 row updated.


SQL> commit;
Commit complete.