This discussion is archived
9 Replies Latest reply: Oct 22, 2012 7:10 AM by Oracle.Quest RSS

Enterprise Manager Not Working

897568 Newbie
Currently Being Moderated
Good day all the gurus in the house,

Please I do need some assistance connecting to Enterprise Manager on my ORACLE 11gR2. When I connect to https://ayodele-hp:1158/em/ and I click on "continue to this website", instead of displaying the login page, it displays the following error message:

*503 Service Unavailable*
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

Please, what do I do.

Thanks.
  • 1. Re: Enterprise Manager Not Working
    mnazim Expert
    Currently Being Moderated
    It mean oms is not up. Please check by command <ORACLE HOME of the oms>/bin/emctl status oms and start oms accordingly by emctl start oms
  • 2. Re: Enterprise Manager Not Working
    897568 Newbie
    Currently Being Moderated
    Thanks for you response, however I'm still unable to get it working. I'm currently running ORACLE on WINDOWS 7 OS and as per your advice, I open command prompt and connected to oms directory : *" c:\app\ayodele\product\11.2.0\dbhome_2\BIN> emctl start oms "* and then I get the following errors :

    c:\app\ayodele\product\11.2.0\dbhome_2\BIN>emctl start oms
    Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
    Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
    Oracle Enterprise Manager 10g Database Control commands:
    emctl start | stop dbconsole
    emctl status | secure | setpasswd dbconsole
    emctl config dbconsole -heap_size <size_value> -max_perm_size <size_valu
    e>
    emctl status agent
    *emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-*
    port>/em/>]*
    emctl getversion
    emctl reload | upload | clearstate | getversion agent
    emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
    emctl config agent <options>
    emctl config agent updateTZ
    emctl config agent getTZ
    emctl resetTZ agent
    *emctl config agent credentials [<Target_name>[:<Target_Type>]]*
    emctl gensudoprops
    emctl clearsudoprops
    Blackout Usage :
    *emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_*
    *Type>]].... [-d <Duration>]*
    emctl stop blackout <Blackoutname>
    *emctl status blackout [<Target_name>[:<Target_Type>]]....*

    The following are valid options for blackouts
    *<Target_name:Target_type> defaults to local node target if not specified.*
    If -nodeLevel is specified after <Blackoutname>,the blackout will be applied to
    all targets and any target list that follows will be ignored.
    *Duration is specified in [days] hh:mm*

    emctl getemhome
    emctl ilint
    Em Key Commands Usage :
    *emctl config emkey -emkeyfile <emkey.ora path> [-force] [-sysman_pwd <sysman pas*
    sword>]
    *emctl config emkey -emkey [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <s*
    ysman password>]
    *emctl config emkey -repos [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <s*
    ysman password>]
    *emctl config emkey -remove_from_repos [-sysman_pwd <sysman password>]*
    *emctl config emkey -copy_to_repos [-sysman_pwd <sysman password>]*
    *emctl status emkey [-sysman_pwd <sysman password>]*

    Secure DBConsole Usage :
    *emctl secure dbconsole -sysman_pwd <sysman password> [-passwd_file <abs file loc*
    *>]*
    *[-host <slb hostname>] [-sid <service name>] [-reset] [-secure_port <sec*
    ure_port>]
    *[-root_dc <root_dc>] [-root_country <root_country>] [-root_state <root_s*
    *tate>] [-root_loc <root_loc>]*
    *[-root_org <root_org>] [-root_unit <root_unit>] [-root_email <root_email*
    *>]*
    *[-wallet <wallet loc>] [-wallet_pwd <wallet pwd>] [-trust_certs_loc <cer*
    ts loc>]
    emctl secure status dbconsole
    Register Targettype Usage :
    *emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <*
    rep passwd> <rep host> <rep port> <rep sid> OR
    *emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <*
    rep passwd> <rep connect descriptor>


    I'm so sorry to be a pest but what do I do?

    Thanks.
  • 3. Re: Enterprise Manager Not Working
    Ahmer Mansoor Journeyer
    Currently Being Moderated
    To check status of OEM, execute at command prompt

    emctl status dbconsole

    if it is not running than execute

    emctl start dbconsole.


    Rgds,

    Ahmer
  • 4. Re: Enterprise Manager Not Working
    897568 Newbie
    Currently Being Moderated
    Thanks for your response but I've already set the ORACLE_SID and started the emctl dbconsole but the problem persits.
  • 5. Re: Enterprise Manager Not Working
    Loc Nhan Expert
    Currently Being Moderated
    Hi,

    I would check:

    - File <ORACLE_HOME>/<hostname>_<sid>/sysman/config/emoms.properties. If it is empty, then you can hit the symptom that you described. See MOS note 1093225.1 for more information.

    - Log files in directory <ORACLE_HOME>/<hostname>_<sid>/sysman/log for clues.

    By the way, have you never been able to connect to the DB Control console successfully? If not, it is possible that your install/configuration was not successful. If necessary, check log files in directory <ORACLE_BASE>/cfgtoollogs/emca/<sid>.

    Regards,
    - Loc
  • 6. Re: Enterprise Manager Not Working
    897568 Newbie
    Currently Being Moderated
    Thank for your response Loc, I appreciate it. I check <ORACLE_HOME>/<hostname>_<sid>/sysman/config/emoms.properties and it was empty. On checking the emoms log files, I saw the following:

    **2012-06-16 06:30:56,324 [HTTPThreadGroup-14] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = User credentials doesn't match the existing ones*
    *2012-06-16 06:31:00,581 [HTTPThreadGroup-14] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = User credentials doesn't match the existing ones*
    *2012-06-16 06:31:02,590 [HTTPThreadGroup-14] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = User credentials doesn't match the existing ones*
    *2012-06-16 06:31:08,530 [HTTPThreadGroup-14] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = User credentials doesn't match the existing ones*
    *2012-06-16 06:31:20,741 [HTTPThreadGroup-14] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = User credentials doesn't match the existing ones*
    *2012-06-16 06:31:24,581 [SystemThreadGroup-8] ERROR cache.CacheManager sessionDestroyed.106 - Error while checking audit ON*
    *2012-06-16 06:31:24,582 [SystemThreadGroup-8] ERROR app.SessionObjectManager sessionDestroyed.128 - java.sql.SQLException: User credentials doesn't match the existing ones*
    java.sql.SQLException: User credentials doesn't match the existing ones
    *     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77)*
    *     at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)*
    *     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)*
    *     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:230)*
    *     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)*
    *     at oracle.jdbc.pool.OracleImplicitConnectionCache.validateUser(OracleImplicitConnectionCache.java:353)*
    *     at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:440)*
    *     at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:544)*
    *     at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:480)*
    *     at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:336)*
    *     at oracle.sysman.util.jdbc.ConnectionCache._getConnection(ConnectionCache.java:322)*
    *     at oracle.sysman.util.jdbc.ConnectionCache.getUnwrappedConnection(ConnectionCache.java:575)*
    *     at oracle.sysman.emSDK.svc.conn.FGAConnectionCache.getFGAConnection(FGAConnectionCache.java:207)*
    *     at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1138)*
    *     at oracle.sysman.emSDK.svc.conn.ConnectionService.getPrivateConnection(ConnectionService.java:1172)*
    *     at oracle.sysman.eml.app.SessionObjectManager.sessionDestroyed(SessionObjectManager.java:116)*
    *     at oracle.sysman.eml.app.SessionListener.sessionDestroyed(SessionListener.java:126)*
    *     at com.evermind.server.http.HttpApplication.invalidateSession(HttpApplication.java:860)*
    *     at com.evermind.server.http.EvermindHttpSession.invalidate(EvermindHttpSession.java:397)*
    *     at com.evermind.server.http.SessionAsyncInvalidateHandler.invalidateSession(SessionAsyncInvalidateHandler.java:179)*
    *     at com.evermind.server.http.SessionAsyncInvalidateHandler.run(SessionAsyncInvalidateHandler.java:139)*
    *     at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)*
    *     at java.lang.Thread.run(Thread.java:595)*

    I have always been able to connect to the DB Control console. I am trying to see if I could get a solution to the problems as I'm planning as a last rest to drop the database and then re-creating it again.

    Many thanks,

    Ayodele

    Edited by: 894565 on Jun 19, 2012 3:09 PM
  • 7. Re: Enterprise Manager Not Working
    Loc Nhan Expert
    Currently Being Moderated
    Ayodele,

    It seems that you are hitting bug 6716659, for which a patch is available. Meanwhile, if you don't have a backup of file emoms.properties, you will have to reconfigure DB control. You can use the following commands for reconfiguring DB control.

    emca -deconfig dbcontrol db
    emca -config dbcontrol db

    - Loc
  • 8. Re: Enterprise Manager Not Working
    897568 Newbie
    Currently Being Moderated
    Thanks Loc for your assistance. The commands actually ran but I received the following message:

    INFO: Database Control started successfully
    Jun 20, 2012 6:11:27 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
    INFO: >>>>>>>>>>> The Database Control URL is http://AYODELE-HP:5501/em <<<<<<<<
    <<<
    Error securing Database Control, Database Control has been brought up in non-sec
    ure mode. To secure the Database Control execute the following command(s):

    1) Set the environment variable ORACLE_SID to bank
    2) C:\app\ayodele\product\11.2.0\dbhome_2\bin\emctl.bat stop dbconsole
    3) C:\app\ayodele\product\11.2.0\dbhome_2\bin\emctl.bat config emkey -repos -sy
    sman_pwd < Password for SYSMAN user >
    4) C:\app\ayodele\product\11.2.0\dbhome_2\bin\emctl.bat secure d bconsole -sysma
    n_pwd < Password for SYSMAN user >
    5) C:\app\ayodele\product\11.2.0\dbhome_2\bin\emctl.bat start dbconsole

    After I ran the above scripts, the dbconsole could not be started. I opened a new terminal, set the ORACLE_SID to bank and then emctl start dbconsole. I got a message that the requested service is already started meanwhile, on the browser it displays "cannot display page".

    I think I will drop the database and just create a new one as I need the DBconsole for my OCA & OCP training.

    Thanks once again Loc and to everyone who tried to assist me fixing the problem.

    Regards,

    Ayodele
  • 9. Re: Enterprise Manager Not Working
    Oracle.Quest Explorer
    Currently Being Moderated
    Hi,

    Can you please provide some guidance to use the management pack/enterprise manager. We also need to use this component for 11gR2 monitoring however we are not sure the enterprise manager version compatible to monitor 11gR2 products and if there is any bug/issue with this EM version which we need to highlight upfront. Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points