Results 1 to 15 of 15
  1. #1
    Join Date
    Jul 2003
    Posts
    129

    Unanswered: ORA-12541 TNS:no listener problem

    I have the above problem, however when i use the sqlplus everything works fine. But, when i use the Enterprise Manager Console i receive this error.

    I own the Oracle 9.2.0.1 on a wni2k machine

    what causes this error.?

    PS i susspect that something is wrong with the listener.ora

    Code:
    # LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listene
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))
          )
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
          (SID_DESC =
          (GLOBAL_DBNAME = dika)
          (ORACLE_HOME = E:\oracle\ora92)
          (SID_NAME = dika)
        )
      )
    dika is the SID of the database.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: ORA-12541 TNS:no listener problem

    Originally posted by dominant
    I have the above problem, however when i use the sqlplus everything works fine. But, when i use the Enterprise Manager Console i receive this error.

    I own the Oracle 9.2.0.1 on a wni2k machine

    what causes this error.?

    PS i susspect that something is wrong with the listener.ora

    Code:
    # LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listene
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))
          )
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
          (SID_DESC =
          (GLOBAL_DBNAME = dika)
          (ORACLE_HOME = E:\oracle\ora92)
          (SID_NAME = dika)
        )
      )
    dika is the SID of the database.
    You "assume" wrong.
    If the listener, which runs on the database server system
    had a problem then by definition SQL*Plus would NOT be able to connect.

    I suspect that SQL*Plus & OEM got installed into different
    ORACLE_HOME directory trees and each have their own TNSNAMES.ORA files. The fix is to copy theTNSNAMES.ORA file from the SQL*Plus tree over the top of the one for OEM.

  3. #3
    Join Date
    Jul 2003
    Posts
    129
    If the ORACLE_HOME is the problem then i would like to use the same ora_home for all these tools

    By the way, when i try to start the OEMCTL START OMS it said that failed.

    How to change the ORACLE_HOME and set the same directory everywhere

  4. #4
    Join Date
    Jul 2003
    Posts
    129
    any ideas?

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Originally posted by dominant
    any ideas?
    Different Oracle products REQUIRE different ORACLE_HOME directories.
    Learn how to deal with this reality.

  6. #6
    Join Date
    Jul 2003
    Posts
    129
    In that case could you give me an example regarding the registry?

  7. #7
    Join Date
    Jul 2003
    Posts
    129
    any help on how to solve this problem?

  8. #8
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    want anacedent meant was that every oracle-home needs to have it's own TNS config files, tnsnames.ora and sqlnet.ora or that u have to configure it all in the manner that all oracle_homes will use the same TNS config files.

    Several ways to solve this:
    1) quick and dirty : copy the tnsnames.ora and sqlnet.ora file from the working Oracle-home\network\admin directory to the not-working oracle_home\network\admin directory

    2) clean but only for this oracle_home effective: use the config assistant to create new TNS config files in the not-working oracle_home

    3) clean and working for all future homes: create a environment variable called TNS_ADMIN to point to the location where the correct TNS config files can be found.
    To do so, depends on the OS. If u need any help, post a reply.

    Good luck.
    Edwin van Hattem
    OCP DBA / System analyst

  9. #9
    Join Date
    Jul 2003
    Posts
    129
    the problem is that i have only one ORACLE_HOME, how to add a second one in which i will copy the files, tnsnames.ora and sqlnet.ora?

  10. #10
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    if u have only oen home, u don't have to copy. But then it is really weird that sqlplus works and Enterprise manger doesn't.

    Did u do one or more installations?
    U start the enterprise manager console and then select the standalone version or the management server option ?
    Did u try to tnsping the database ?

    Greetz
    Edwin van Hattem
    OCP DBA / System analyst

  11. #11
    Join Date
    Jul 2003
    Posts
    129
    here is my tnsping

    Code:
    C:\>tnsping dika
    
    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-OCT-2003 16:18:48
    
    Copyright (c) 1997 Oracle Corporation.  All rights reserved.
    
    Used parameter files:
    E:\oracle\ora92\network\admin\sqlnet.ora
    
    
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DAT
    A = (SERVER = DEDICATED) (SERVICE_NAME = dika)))
    TNS-12541: TNS:no listener
    
    C:\>
    what is the problem now? Sqlplus, sqlplusw, imp, exp work great.

  12. #12
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    looks like the problem is in the tnsnames.ora

    check it out:
    tnsnames.ora says host=localhost
    listener says host=MYip

    Change the tnsnames so that the hostname corresponds with the listener hostname.

    Hope this helps.
    Edwin van Hattem
    OCP DBA / System analyst

  13. #13
    Join Date
    Jul 2003
    Posts
    129
    I fixed the error when i corrected the service (tnslsnr) Now everything works fine!

  14. #14
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up Re: ORA-12541 TNS:no listener problem

    In the listener.ora add the CONNECT_DATA as shown below & try


    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = dika)
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = dika)
    (ORACLE_HOME = E:\oracle\ora92)
    (SID_NAME = dika)
    )
    )
    SATHISH .

  15. #15
    Join Date
    Jul 2003
    Posts
    129
    Ti's ok now, i had forgotten to start the Listener Service!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •