2 Replies Latest reply: May 2, 2012 10:21 AM by 934336 RSS

    EM Configuration issue. /usr/app/oracle/product/11.2.0/LPLCLDDB105.phx.aexp

    934336
      OTN community,

      1. I am getting the following error when I try to startup the emcltl db console:

      emctl dbconsole start
      The following exception occurred:
      java.net.UnknownHostException: LPLCLDDB105.phx.aexp.com: LPLCLDDB105.phx.aexp.com
      ....
      EM Configuration issue. /usr/app/oracle/product/11.2.0/LPLCLDDB105.phx.aexp.com_DOC105P not found.

      From there my research brought forward this post I tried this also:

      This is due to a misconfiguration of dbconsole during database setup. The fastest solution is usually to recreate repository and configuration.

      First, deconfigure dbconsole:

      view sourceprint?1 [oracle@oratest03 bin]$ ./emca -deconfig dbcontrol db -repos recreate

      With the following Results:

      ./emca -config dbcontrol db -repos recreate

      STARTED EMCA at May 1, 2012 10:56:03 AM
      EM Configuration Assistant, Version 11.2.0.0.2 Production
      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      ./emca -config dbcontrol db -repos recreate

      STARTED EMCA at May 1, 2012 10:56:03 AM
      EM Configuration Assistant, Version 11.2.0.0.2 Production
      Copyright (c) 2003, 2005, Oracle. All rights reserved.

      Enter the following information:
      Database SID: DOC105P
      log4j:ERROR No appenders could be found for category (emSDK.config).
      log4j:ERROR Please initialize the log4j system properly.
      Listener port number: -bash-3.2$ 1521
      -bash: 1521: command not found

      Im not sure why java is throwing this error and would like someone who has navigated this issue to before to help if possible.

      Thanks Kdecker
        • 1. Re: EM Configuration issue. /usr/app/oracle/product/11.2.0/LPLCLDDB105.phx.aexp
          sb92075
          on DB server issue following OS commands

          lsnrctl startup
          lsnrctl status
          lsnrctl service

          COPY commands & results then PASTE all back here
          • 2. Re: EM Configuration issue. /usr/app/oracle/product/11.2.0/LPLCLDDB105.phx.aexp
            934336
            1. lsnrctl startup

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-MAY-2012 08:17:49

            Copyright (c) 1991, 2009, Oracle. All rights reserved.

            NL-00853: undefined command "startup". Try "help"

            2. lsnrctl status

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-MAY-2012 08:19:29

            Copyright (c) 1991, 2009, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LPLCLDDB105.lab.trcn.aex p.com)(PORT=1521)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
            Start Date 23-APR-2012 09:20:28
            Uptime 8 days 22 hr. 59 min. 1 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /usr/app/oracle/product/11.2.0/network/admin/listener. ora
            Listener Log File /usr/app/oracle/diag/tnslsnr/LPLCLDDB105/listener/aler t/log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LPLCLDDB105.lab.trcn.aexp.com)(PORT= 1521)))
            Services Summary...
            Service "DOC105P" has 1 instance(s).
            Instance "DOC105P", status READY, has 1 handler(s) for this service...
            Service "DOC105PXDB" has 1 instance(s).
            Instance "DOC105P", status READY, has 1 handler(s) for this service...
            The command completed successfully

            3. lsnrctl service

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-MAY-2012 08:20:15

            Copyright (c) 1991, 2009, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LPLCLDDB105.lab.trcn.aexp.com)(PORT=1521)))
            Services Summary...
            Service "DOC105P" has 1 instance(s).
            Instance "DOC105P", status READY, has 1 handler(s) for this service...
            Handler(s):
            "DEDICATED" established:0 refused:0 state:ready
            LOCAL SERVER
            Service "DOC105PXDB" has 1 instance(s).
            Instance "DOC105P", status READY, has 1 handler(s) for this service...
            Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
            DISPATCHER <machine: LPLCLDDB105.lab.trcn.aexp.com, pid: 32054>
            (ADDRESS=(PROTOCOL=tcp)(HOST=LPLCLDDB105.lab.trcn.aexp.com)(PORT=49926))
            The command completed successfully