1 2 Previous Next 18 Replies Latest reply: Jan 23, 2013 6:31 AM by EdStevens RSS

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

    668640
      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
          Satish Kandi
          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
            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
              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
                Satish Kandi
                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
                  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
                    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
                      Have you tried:
                      select * from fsnew10;
                      • 8. Re: ORA-12541: TNS:no listener...please help
                        671330
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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