I faced with that issue on “Oracle Enterprise manager” on one of my client environments.

Here is the error message while I try to start dbconsole

[oracle@yourhostname alert]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
http://yourhostname:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running. 
------------------------------------------------------------------
Logs are generated in directory $ORACLE_HOME/your_hostname/sysman/log 
[oracle@yourhostname alert]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
http://yourhostname:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ............................................................................................. failed.

While I checked log message I found those errors:

[OC4J Launcher] ERROR em.rca reconcileOrphans.194 – java.sql.SQLException: Could not get a private connection for Root Cause Analysis.
2017-12-22 16:04:25,390 [OC4J Launcher] ERROR sch.ScheduleTZService init.105 – Error While initializing emSDK/sch/ScheduleTZService $ORA-28000: the account is locked
 [HTTPThreadGroup-2] ERROR conn.ConnectionService verifyRepositoryEx.891 – Invalid Connection Pool. ERROR = ORA-28000: the account is locked
[EMUI_16_04_25_/console/aboutApplication] ERROR svlt.PageHandler handleRequest.639 – java.lang.IllegalStateException: Response has already been committed
java.lang.IllegalStateException: Response has already been committed
“emoms.log” 46380L, 3949784C 1,1 Top
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:637)
EMUI_07_35_02_/console/aboutApplication] ERROR em.console doGet.363 – java.lang.IllegalStateException: Response has already been committed, be sure not to write to the OutputStream or to trigger a commit due to any other action before calling this method.
java.lang.IllegalStateException: Response has already been committed, be sure not to write to the OutputStream or to trigger a commit due to any other action before calling this method.
at com.evermind.server.http.EvermindHttpServletResponse.sendRedirect(EvermindHttpServletResponse.java:1545)
at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:812)
at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:343)
at oracle.sysman.eml.app.Console.doGet(Console.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:107)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:149)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:327)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:226)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:127)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:116)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:637)
[HTTPThreadGroup-5] ERROR conn.ConnectionService verifyRepositoryEx.891 – Invalid Connection Pool. ERROR = ORA-28000: the account is locked
[PAFStartupThread] ERROR conn.ConnectionService verifyRepositoryEx.891 – Invalid Connection Pool. ERROR = ORA-28000: the account is locked

The thing is SYSMAN account is locked. Here is the steps:

1) Stop the DB Control

[oracle@yourhostname]$ emctl stop dbconsole

2) Connect to the database as a user with DBA privilege with SQL*Plus and execute:

[oracle@yourhostname]$ cd $ORACLE_HOME/bin
[oracle@yourhostname]$./sqlplus

SQL> alter user sysman identified by <password> ;

Check the new password
SQL> connect sysman/[@database_alias]

3) Set new password for dbconsole
$ emctl setpasswd dbconsole
Provide the new SYSMAN password

4) open the emoms.properties configuration file, backup it and change entries
xx\sysman\config\emoms.properties

orcle.sysman.eml.mntr.emdRepPwd=NEW_SYSMAN_PASSWORD
orcle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE ( If its true than change it to false)
5) Restart the DB Control
On Unix
$ emctl start dbconsole

Reference:
– How To Change the Password of the Database User Sysman (Enterprise Manager Database Control Repository Schema) (Doc ID 259379.1)
– Database Control (dbconsole) homepage shows “Failed to connect to database instance: ORA-12537: TNS:connection closed” under “agent connection to instance” (Doc ID 1563982.1)

Reklam