This discussion is archived
2 Replies Latest reply: May 2, 2012 8:21 AM by 934336 RSS

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

934336 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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