This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 23, 2013 4:31 AM by EdStevens RSS

ORA-12541: TNS:no listener...please help

668640 Newbie
Currently Being Moderated
Hi,

I have 2 databases on different machines - ORCL on 172.21.161.107 and scmb10g on 172.21.161.60.
I tried to create a database link from ORCL on 172.21.161.107 to scmb10g on 172.21.161.60.
The public db link is created successfully....but while trying to access it, I'm getting foll error .

Pls Help.



SQL> create public database link fsnew10 connect to onsitedba identified by onsitedba using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.161.60)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SCMB10g) ) )';

Database link created.

SQL> commit;

Commit complete.

SQL> select * from SYG_SYSTEM_GLOBALS@fsnew10;
select * from SYG_SYSTEM_GLOBALS@fsnew10
*
ERROR at line 1:
ORA-12541: TNS:no listener
  • 1. Re: ORA-12541: TNS:no listener...please help
    SatishKandi Guru
    Currently Being Moderated
    Check if the listener on 172.21.161.60 is running on default port i.e. 1521.

    Can you establish a connection to this database with sqlplus?
  • 2. Re: ORA-12541: TNS:no listener...please help
    NavneetU Expert
    Currently Being Moderated
    Please check whether Listener is running at the target database server '172.21.161.60'?

    It seems that listener is not running at the target server.

    Regards
  • 3. Re: ORA-12541: TNS:no listener...please help
    668640 Newbie
    Currently Being Moderated
    Hi Satish,

    a ping from 172.21.161.107 resulted in the following -

    ping 172.21.161.60||1521

    PING 172.21.161.60: (172.21.161.60): 56 data bytes
    64 bytes from 172.21.161.60: icmp_seq=0 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=1 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=2 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=3 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=4 ttl=255 time=3 ms
    64 bytes from 172.21.161.60: icmp_seq=5 ttl=255 time=7 ms
    64 bytes from 172.21.161.60: icmp_seq=6 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=7 ttl=255 time=0 ms



    also, i was able to connect to SCMB10g sid on 172.21.161.60 -

    sqlplus onsitedba/onsitedba
  • 4. Re: ORA-12541: TNS:no listener...please help
    SatishKandi Guru
    Currently Being Moderated
    Can you post the output of tnsping?
    also, i was able to connect to SCMB10g sid on 172.21.161.60 -
    Have you tried connecting remotely from other server?
  • 5. Re: ORA-12541: TNS:no listener...please help
    668640 Newbie
    Currently Being Moderated
    Can you please advice how to check whether listener is running on target server.

    I used a ping and it sems it worked -

    ping 172.21.161.60||1521
    PING 172.21.161.60: (172.21.161.60): 56 data bytes
    64 bytes from 172.21.161.60: icmp_seq=0 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=1 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=2 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=3 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=4 ttl=255 time=3 ms
    64 bytes from 172.21.161.60: icmp_seq=5 ttl=255 time=7 ms
    64 bytes from 172.21.161.60: icmp_seq=6 ttl=255 time=0 ms
    64 bytes from 172.21.161.60: icmp_seq=7 ttl=255 time=0 ms
  • 6. Re: ORA-12541: TNS:no listener...please help
    NavneetU Expert
    Currently Being Moderated
    run>lsnrct
    lsnrctl>status

    PLease see this

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-NOV-2008 12:43
    :21

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

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> ststus
    NL-00853: undefined command "ststus". Try "help"
    LSNRCTL> status
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
    tion
    Start Date 26-NOV-2008 10:53:58
    Uptime 0 days 1 hr. 49 min. 33 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File E:\oracle\ora92\network\admin\listener.ora
    Listener Log File E:\oracle\ora92\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.162.1.1)(PORT=1521)
    ))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "oracle" has 1 instance(s).
    Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    LSNRCTL>



    Regards,

    Edited by: NKU on Nov 26, 2008 12:41 PM
  • 7. Re: ORA-12541: TNS:no listener...please help
    656573 Newbie
    Currently Being Moderated
    Have you tried:
    select * from fsnew10;
  • 8. Re: ORA-12541: TNS:no listener...please help
    671330 Newbie
    Currently Being Moderated
    You said:
    also, i was able to connect to SCMB10g sid on 172.21.161.60 -

    sqlplus onsitedba/onsitedba
    but this is meaningless because the logon clause uses no connection identifier (e.g. @xxxx), thus
    a connection is established without using a LISTENER and the network. Here sqlplus and the server process will communicate with inter process communication facilities.

    Please log in into 172.21.161.60 and run then command "lsnrctl status" this will give you the best
    source of information for determining the problem.
  • 9. Re: ORA-12541: TNS:no listener...please help
    668640 Newbie
    Currently Being Moderated
    Hi All,

    "lsnrctl status" has resulted in this -

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 26-NOV-2008 15:01:42

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 79: Connection refused






    "lsnrctl start" -

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 26-NOV-2008 15:03:31

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

    Starting /ora10g/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

    TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
    NL-00280: error creating log stream /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log
    NL-00278: cannot open log file
    SNL-00016: snlfohd: error opening file
    IBM/AIX RISC System/6000 Error: 13: Permission denied

    Listener failed to start. See the error message(s) above...




    /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log says this -

    TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 26-NOV-2008 13:24:17

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

    System parameter file is /etc/listener.ora
    Log messages written to /ora10g/oracle/product/10.2.0/db_1/network/log/listener.log
    Trace information written to /ora10g/oracle/product/10.2.0/db_1/network/trace/listener.trc
    Trace level is currently 0

    Started with pid=1839352
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.161.60)(PORT=1521)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    TNS-12555: TNS:permission denied
    TNS-12560: TNS:protocol adapter error
    TNS-00525: Insufficient privilege for operation
    IBM/AIX RISC System/6000 Error: 1: Not owner
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.161.60)(PORT=1521)))
  • 10. Re: ORA-12541: TNS:no listener...please help
    656573 Newbie
    Currently Being Moderated
    Could it be that your listener service doesnt have the correct user id and password with rights to start?
  • 11. Re: ORA-12541: TNS:no listener...please help
    668640 Newbie
    Currently Being Moderated
    i'm using ora10g login to start the listener.
    I'm not sure what permission is it looking for.
  • 12. Re: ORA-12541: TNS:no listener...please help
    656573 Newbie
    Currently Being Moderated
    I may going down the wrong path (thats why im a newbie!) but what OS is Oracle on and does your login user have the rights to start the TNS service?
  • 13. Re: ORA-12541: TNS:no listener...please help
    450155 Explorer
    Currently Being Moderated
    who is the owner of oracle software

    cd /ora10g/oracle/product/10.2.0/db_1
    ls -ltr (check the owner and group)

    drwxr-xr-x 2 oracle oinstall 12288 Jun 17 21:05 bin
    drwxr-x--- 2 oracle oinstall 4096 Nov 19 03:43 dbs

    In the above case oracle is the owner
    and oinstall is the group.

    ensure that the oracle home directory is having 755.

    Also check whether you have run the root.sh after the installation.
  • 14. Re: ORA-12541: TNS:no listener...please help
    669771 Oracle ACE
    Currently Being Moderated
    Hi,

    do you have register database scmb10g with listener on 172.21.161.60?
    It looks you haven't.

    Regards,
    Tom
    http://oracledba.cz
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points