ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Resetting the sqloper password


Article ID: 88661


Updated On:


CA Automic Applications Manager (AM)


Resetting the sqloper password


Release: 8.x & 9.x
Component: Applications Manager 


Detailed Description and Symptoms
Occasionally an Applications Manager administrator will leave a company without passing on the login credentials for the administrative user. When that happens support will need to help the customer identify the applicable Administrative user, and then provide update assistance for that user.


Stop the instance, and login into the DB via SQLPlus as the Applications Manager Oracle user

Run the following command to determine which user is set up as the administrator.

SQL> select so_user_name,so_last_name from so_user_table;

Please contact Automic Support for additional SQL statements to actually change the password.