ORA-12541: TNS:no listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-12541: TNS:no listener

  1. #1
    Join Date
    May 2003
    Posts
    14

    ORA-12541: TNS:no listener

    Hi,

    I need to connect to the database on the UNIX server from my laptop. So I updated TNSNAMES.ORA and LISTENER.ORA on my machine as follows:

    TNSNAMES.ORA
    ----------------------------------------------------
    ICT =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = unix4.ict.prod)(PORT = 1523))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = ict)
    )
    )



    LISTENER.ORA
    -------------------------------------------------------

    ICT =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = unix4.ict.prod)(PORT = 1523))
    )
    --------------------------------------------------------------

    but I still get the error message :

    ERROR:
    ORA-12541: TNS:no listener

    any idea why it can't see the new listener?

    Alf

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    go to the database server machine, type lsnrctl status
    to see if the listerner is up. If it is up, which port
    it is litenering on.

    You do not need listener.ora on the client side.

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by sysdba
    go to the database server machine, type lsnrctl status
    to see if the listerner is up. If it is up, which port
    it is litenering on.
    Some other troubleshooting steps you can take before taking a walk to the server:

    Do a ping hostname to determine basic network connectivity between your client and the server. A lot of places don't junk up the server name (unix4 versus unix4.ict.prod - what is "ict.prod" supposed to be, a domain?).

    Then do a tnsping hostname from your client to determine Oracle-related network connectivity.

    If ping works, but tnsping returns the 12541 error, it is more than likely no listener as sysdba pointed out.

    C:\Documents and Settings\stecal>tnsping kguest

    TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 20-NOV-20
    03 16:30:22

    Copyright (c) 1997 Oracle Corporation. All rights reserved.

    Used parameter files:
    D:\Oracle\network\admin\sqlnet.ora

    Used HOSTNAME adapter to resolve the alias
    Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=kguest))(A
    DDRESS=(PROTOCOL=TCP)(HOST=kguest)(PORT=1521)))
    TNS-12541: TNS:no listener
    Last edited by stecal; 11-20-2003 at 06:34 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width