11 Replies Latest reply: Mar 13, 2006 5:25 AM by 496898 RSS

    ORA-12541 TNS :no listener.

    472972
      Hi All,

      I have installed oracle server on my machine, but not able to login Scott with password as tiger.

      The error is ORA-12541 no listener.

      So I have changes an entry in the tnsnames.ora, also added a listener to listener.ora for same entry.

      Can you please suggest any next steps in this direction?

      Thanks
        • 1. Re: ORA-12541 TNS :no listener.
          453363
          please check whether the listener service is up and running or else try lsnrctl and start the listener
          • 2. Re: ORA-12541 TNS :no listener.
            472972
            Hi,

            Thanks for the reply.

            I have started the listener but now while connecting getting an error
            ORA-12154 TNS:could not resolve the service name.

            Can you please help with some next steps

            Thanks a lot
            • 3. Re: ORA-12541 TNS :no listener.
              453363
              Do u have any domain name set....
              like .us.oracle.com

              Or else please check the sqlnet.ora and tnsnames.ora file
              • 4. Re: ORA-12541 TNS :no listener.
                477152
                Hi,

                check the user name and password.

                if u r connecting like
                SQL> sqlplus scott/tiger@oracle9i

                then check whether the service oracle9i is present in tnsnames.ora
                if not edit it and shutdown and restart the databse.


                Trinath Somanchi,
                • 5. Re: ORA-12541 TNS :no listener.
                  472972
                  Hi Sashi/Trinath

                  I am getting a bit confused.....so let me start again

                  While installing the oracle server, the insatalltaion asks you for
                  1) SID
                  2) Global Database Name

                  so i provided the following values

                  SID=practice
                  Global Database Name=axxx.byyy

                  The tnsoranames conatins the follwing enrty

                  axxx.byyy.com=
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1521))
                  )
                  (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = practice)
                  )
                  )


                  AND listener.ore contains the following enrty

                  LISTENER =
                  (DESCRIPTION_LIST =
                  (DESCRIPTION =
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
                  )
                  (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1521))
                  )
                  )
                  )

                  SID_LIST_LISTENER =
                  (SID_LIST =
                  (SID_DESC =
                  (SID_NAME = PLSExtProc)
                  (ORACLE_HOME = D:\OraHome1)
                  (PROGRAM = extproc)
                  )
                  (SID_DESC =
                  (GLOBAL_DBNAME = UKOBA)
                  (ORACLE_HOME = D:\OraHome1)
                  (SID_NAME = UKOBA)
                  )
                  (SID_DESC =
                  (GLOBAL_DBNAME = nhsdw1)
                  (ORACLE_HOME = D:\OraHome1)
                  (SID_NAME = nhsdw)
                  )
                  (SID_DESC =
                  (GLOBAL_DBNAME = axxx.byyy)
                  (ORACLE_HOME = D:\OraHome1)
                  (SID_NAME = practice)
                  )
                  )

                  and entry in the sql.net

                  NAMES.DEFAULT_DOMAIN = byyy.com

                  SQLNET.AUTHENTICATION_SERVICES= (NTS)

                  NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

                  I am not able to figure out what is the reason for the error as there are enteries in all the three files.

                  It would be great help if you could throw some light on this topic

                  Thanks
                  • 6. Re: ORA-12541 TNS :no listener.
                    477152
                    hi,
                    u have to connect like this

                    sqlplus scott/tiger@practice

                    it surely works as it worked for me


                    Trinath Somanchi,
                    Hyderabad.
                    • 7. Re: ORA-12541 TNS :no listener.
                      496898
                      Hi

                      Do you have more than 1 oracle home in your server?
                      Allways the tnsnames.ora of the default oracle home is used for lookup the tns name.
                      Try to configure and test the tns name in the net configuration assistant.

                      Ott Karesz
                      http://www.trendo-kft.hu
                      • 8. Re: ORA-12541 TNS :no listener.
                        472972
                        Hi Trinath/Ott,

                        Sorry again i'm not able to connect through scott/tiger@practice and still giving me an error could not resolve the service name.

                        Also i have two Oracle Home on my machine.

                        Thanks
                        • 9. Re: ORA-12541 TNS :no listener.
                          453363
                          Please include the domain name also in your host string as like your tnsnames.ora file..

                          If it does give the same problem,

                          Please edit below setting in the sqlnet.ora file

                          SQLNET.AUTHENTICATION_SERVICES=

                          (ie) remove the (NTS) in the right side
                          • 10. Re: ORA-12541 TNS :no listener.
                            472972
                            Hi Sashi,

                            After removing the NTS enrty on right hand side becomes
                            SQLNET.AUTHENTICATION_SERVICES=
                            but the error is still the same.

                            Can you sugget something else....:)


                            Thanks a lot for your replies
                            • 11. Re: ORA-12541 TNS :no listener.
                              496898
                              Hi

                              Copy your tnsnames.ora and sqlnet.ora files whoch contains the right tns name to the other oracle_home/network/admin, and try to connect again.
                              Test your tns name in the net configuration assistant.
                              Try to connect as scott/tiger@axxx.byyy.com and scott/tiger@axxx

                              Ott Karesz
                              http://www.trendo-kft.hu