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