|Applies To||Oracle 10g Datastore|
RSA Access Manager 6.x admingui
RKM Server Appliance
|Issue||AxM/RKM/Oracle 10g/how to reset the admingui super user password when the password is unknown|
Unable to login to http://myhost.mydomain.com:<7001|8080>/admingui, invalid credentials.
Lost admin account login information lost or forgotten
To correct this issue, you will need to manually interact with the datastore via the sqlplus command line interface.
Step 1, identify the oracle.user and oracle.password in the sql.conf
-Login into the unix server as the root account.
# This required parameter specifies the password for the account specified by
-record the values for these two variables and exit out of vi
Step 2, connect to oracle and modify the table for the admin account
- switch user to the oracle account
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 21 13:07:33 2009
It will respond with:
-Now, alter your admin account at the SQL> prompt as follows with this command:
SQL> update password set password = 'attitash' where user_id = (select id from users where name='admin');
-it will respond with:
1 row updated.
-Now, commit the change:
-It will respond with:
Step 3: Login to admingui and change the password again so it will not be stored in cleartext.
-At this point, you should be able to successfully login to admingui with the new password.
|Notes||The same philosophy can be applied to an RKM appliance when the password is unknown. See solution How to log back in if I lost my Key Manager admin password? for other information specific to RKM appliances to reset the password.|
|Legacy Article ID||a46759|