How To Change the Password of the Database User Sysman (Enterprise Manager Database Control Repository Schema)
(Doc ID 259379.1)
Last updated on APRIL 03, 2018
Applies to:Enterprise Manager for Oracle Database - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 11.2]
Enterprise Manager for Oracle Database - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Information in this document applies to any platform.
The SYSMAN password is stored encrypted in several places so that the Enterprise Manager Database Control web site can access the database without having to prompt the user for the SYSMAN password at each operation.
When the SYSMAN password is changed in the database, the new password must be provided to the Database Control web site configuration.
If this is not done, the web site cannot access the database, and the following error messages will be logged in the trace files:
2012-05-31 13:50:13,513 [PAFStartupThread] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = ORA-01017: invalid username/password; logon denied
2012-05-31 13:50:20,717 [HTTPThreadGroup-4] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = ORA-28000: the account is locked
2012-05-31 13:50:20,764 [HTTPThreadGroup-2] ERROR eml.OMSHandshake processFailure.806 - OMSHandshake failed. (AGENT URL = https://uk-sno1-m018.uk-paper.group.wan:3938/emd/main)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: ORA-01017: invalid username/password; logon denied
This document explains How to change the password of the Database User SYSMAN without breaking the communication between the Database and the Database Control.
ATTENTION: Enterprise Manager 10g is now in extended support. Oracle strongly recommends that you upgrade your environment to a currently supported version. If you would like to discuss SYSMAN password issues with other EM Users or with EM Support, please feel free to monitor or update the MOS EM Community listed below.
All database administrators using the Enterprise Manager DB Control 10g or 11g.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Database Release prior 10.2.0.4|
|Database Release beginning 10.2.0.4|