ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

Posted on 2009-04-29
Last Modified: 2013-12-18
This is the below error in Oracle 10g Enterprise manager
ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).

I had started listner, and enterprise manager using emctl start dbconsole, everything went fine, but i am getting the above error in the Enterprise manager page.

Kindly advise me to rectify the above error

Question by:umesh4exp
    LVL 68

    Expert Comment

    this is most probably a mismatch between $ORACLE_HOME/network/admin/tnsnames.ora and $ORACLE_HOME/network/admin/listener.ora
    Check it!
    LVL 68

    Accepted Solution

    Also check the ConnectDescriptor in ${ORACLE_HOME}/${HOSTNAME}_${ORACLE_SID}/sysman/config/ if it matches the entries in the other two files.
    Or is/was there simply a typo in hostname/port/SID/service when configuring/accessing the instance in enterprise manager?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Init.ora File Points to SPFILE 6 50
    Format Number Field 10 34
    Add 0 to end of Number 21 58
    Out of Sequence numbers for today 25 35
    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now