14 Replies Latest reply on Mar 7, 2011 6:41 PM by 839770

    ORA-12541- TNS:No Listener Error

    839770
      Dear All,
      I am new to oracle and this forum. I installed Oracle 11g and Oracle forms in my system.
      When i Try to connect to database thru SQL* Plus, am getting error as "ORA-12541- TNS:No Listener". Same issue when i try to connect thru Forms Builder. This is how my tnsnames.ora looks
      # tnsnames.ora Network Configuration File: C:\DevSuiteHome_2\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Pradeep-PC)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = PLSExtProc)
      )
      )

      ORACLE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracle)
      )
      )

      LISTENER_ORACLE =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )
      Kindly guide me
        • 1. Re: ORA-12541- TNS:No Listener Error
          Kamran Agayev A.
          Please post the output of the following command from db server :
          lsnrctl status
          If it's down, then run
          lsnrctl start
          and post all output



          Kamran Agayev A.
          Oracle ACE
          - - - - - - - - - - - - - - - - - - - - -
          My Oracle Video Tutorials - http://kamranagayev.wordpress.com/oracle-video-tutorials/
          1 person found this helpful
          • 2. Re: ORA-12541- TNS:No Listener Error
            729964
            go to start
            run
            type services.msc
            start oracle services .. related to listener / tns /oracle sid
            1 person found this helpful
            • 3. Re: ORA-12541- TNS:No Listener Error
              12cdb
              Have you tried??? starting the service and commands suggested above
              • 4. Re: ORA-12541- TNS:No Listener Error
                839770
                Hi.. this is wat am getting..

                C:\Users\Pradeep>lsnrctl status
                --------------------------------------------------------------------------------------------------------------------------------------------
                LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-MAR-2011 21:49
                :26

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

                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=Pgz62529)))
                TNS-12541: TNS:no listener
                TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                32-bit Windows Error: 2: No such file or directory
                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Pradeep-PC)(PORT=1521)))

                TNS-12541: TNS:no listener
                TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                32-bit Windows Error: 61: Unknown error
                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=Pradeep-PC)(PORT=2484))
                )
                TNS-12541: TNS:no listener
                TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                32-bit Windows Error: 61: Unknown error
                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=NMP)(SERVER=PRADEEP-PC)(PIPE=ORAPI
                PE)))
                TNS-12541: TNS:no listener
                TNS-12560: TNS:protocol adapter error
                TNS-00511: No listener
                32-bit Windows Error: 2: No such file or directory

                C:\Users\Pradeep>
                --------------------------------------------------------------------------------------------------------------------------------------------
                C:\Users\Pradeep>lsnrctl start

                LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-MAR-2011 21:50
                :37

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

                Starting tnslsnr: please wait...

                TNS-12560: TNS:protocol adapter error
                TNS-00530: Protocol adapter error

                --------------------------------------------------------------------------------------------------------------------------------------------
                • 5. Re: ORA-12541- TNS:No Listener Error
                  sb92075
                  Have both OS Services for database & listener been started?
                  • 6. Re: ORA-12541- TNS:No Listener Error
                    839770
                    ya all the services are started..
                    • 7. Re: ORA-12541- TNS:No Listener Error
                      Hans Forbrich
                      kryptobium wrote:
                      Dear All,
                      I am new to oracle and this forum. I installed Oracle 11g and Oracle forms in my system.
                      When i Try to connect to database thru SQL* Plus, am getting error as "ORA-12541- TNS:No Listener". Same issue when i try to connect thru Forms Builder. This is how my tnsnames.ora looks
                      I am guessing that you have both database and dev suite installed on the PC.

                      If yes, you have 2 *two) diferent TNSNAMES.ORA files.  One in the Dev Suite 'HOME' and one in the Database 'HOME'. 

                      1) These two TNSNAMES.ORA files must be identical.

                      I am also guessing that the PC gets its IP address from DHCP.

                      2) Open a command line, and type in "IPCONFIG /ALL". ENsure that the TNSNAMES.ORA files and the LISTENER.ORA file all refer to the same and correct host name in the "Windows IP Configuration / Host Name . . . . " section of the IPCONFIG ?ALL output. If you needed to make a change, reboot the PC.
                      1 person found this helpful
                      • 8. Re: ORA-12541- TNS:No Listener Error
                        sb92075
                        when was last time SQL*Net worked without error?
                        What changed?

                        All indications are OS/Networking mis-configuration.

                        Is any type of Operating System Virtualization installed on this system.
                        • 9. Re: ORA-12541- TNS:No Listener Error
                          12cdb
                          Your listener.ora file contents look very complicated.. very difficult (might not be for others)

                          Why do not you rename the existing listener.ora file and create a new listener using netca.
                          1 person found this helpful
                          • 10. Re: ORA-12541- TNS:No Listener Error
                            839770
                            Am having VMVare and i ve Ubuntu and MAC OS X working on that.... is there any issue because of this?
                            • 11. Re: ORA-12541- TNS:No Listener Error
                              839770
                              I ve made both tnsnames.ora file identical and both refers to the Hostname under the windows IP configuration. still the issue persists.
                              • 12. Re: ORA-12541- TNS:No Listener Error
                                839770
                                Tried creating new Listener and started that and tried. still the same issue..
                                • 13. Re: ORA-12541- TNS:No Listener Error
                                  839770
                                  Without installing Database Suite, is it enuf if i install Dev Suite alone. Will that work in that case. If i unistall both and install Dev Suite alone, will i be able to create and use database?????
                                  • 14. Re: ORA-12541- TNS:No Listener Error
                                    839770
                                    Thank you all..
                                    After creating new Listener, making all the tnsnames.ora identical and restarting now it is working fine.. thank you for ur help and support