1 2 3 Previous Next 44 Replies Latest reply on Sep 17, 2008 3:16 AM by Maran Viswarayar Go to original post
      • 15. Re: ORA-TNS:12541
        639811
        Hi steven
        Ha ha Ha...
        i laughed myself after reading ur mail..Anyway its good ya..
        i m saying two listeners in that sense all listeners are up.(i too know its a server side connection establish file)
        now lets come to the matter..
        first i ll start from the tnsping on client machine:
        *****************************************
        TNS Ping Utility for Linux: Version 9.2.0.5.0 - Production on 12-SEP-2008 21:45:58

        Copyright (c) 1997 Oracle Corporation. All rights reserved.

        Used parameter files:
        /oracle/product/92040/network/admin/sqlnet.ora


        Used TNSNAMES adapter to resolve the alias
        Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OWAZUAT1)))
        OK (10 msec)


        [oracle@inp1db02 ~]$ sqlplus system@owazuat1

        SQL*Plus: Release 9.2.0.5.0 - Production on Fri Sep 12 21:46:33 2008

        Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

        Enter password:
        ERROR:
        ORA-12541: TNS:no listener


        sqlnet_client.log(client machine)
        ****************************

        Fatal NI connect error 12514, connecting to:
        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(
        SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVPS)(CID=(PROGRAM=)(HOST=inp1db02.bagic.com
        )(USER=oracle))))

        VERSION INFORMATION:
        TNS for Linux: Version 9.2.0.5.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.5.0 - Production
        Time: 12-SEP-2008 19:30:44
        Tracing to file: /oracle/product/92040/network/trace/sqlnet_client_32121.trc
        Tns error struct:
        nr err code: 0
        ns main err code: 12564
        TNS-12564: TNS:connection refused
        ns secondary err code: 0
        nt main err code: 0
        nt secondary err code: 0
        nt OS err code: 0




        Fatal NI connect error 12541, connecting to:
        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVP)(CID=(
        PROGRAM=)(HOST=inp1db02.bagic.com)(USER=oracle))))

        VERSION INFORMATION:
        TNS for Linux: Version 9.2.0.5.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.5.0 - Production
        Time: 12-SEP-2008 19:35:53
        Tracing to file: /oracle/product/92040/network/trace/sqlnet_client_32305.trc
        Tns error struct:
        nr err code: 0
        ns main err code: 12541
        TNS-12541: TNS:no listener
        ns secondary err code: 12560
        nt main err code: 511
        TNS-00511: No listener
        nt secondary err code: 111
        nt OS err code: 0



        Fatal NI connect error 12541, connecting to:
        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVP)(CID=(
        PROGRAM=)(HOST=inp1db02.bagic.com)(USER=oracle))))

        VERSION INFORMATION:
        TNS for Linux: Version 9.2.0.5.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.5.0 - Production
        Time: 12-SEP-2008 19:38:13
        Tracing to file: /oracle/product/92040/network/trace/sqlnet_client_32368.trc
        Tns error struct:
        nr err code: 0
        ns main err code: 12541
        TNS-12541: TNS:no listener
        ns secondary err code: 12560
        nt main err code: 511
        TNS-00511: No listener
        nt secondary err code: 111
        nt OS err code: 0


        ***********************************************************************
        Fatal NI connect error 12541, connecting to:
        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVP)(CID=(
        PROGRAM=)(HOST=inp1db02.bagic.com)(USER=oracle))))

        VERSION INFORMATION:
        TNS for Linux: Version 9.2.0.5.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.5.0 - Production
        Time: 12-SEP-2008 19:39:47
        Tracing to file: /oracle/product/92040/network/trace/sqlnet_client_32407.trc
        Tns error struct:
        nr err code: 0
        ns main err code: 12541
        TNS-12541: TNS:no listener
        ns secondary err code: 12560
        nt main err code: 511
        TNS-00511: No listener
        nt secondary err code: 111
        nt OS err code: 0


        ***********************************************************************
        Fatal NI connect error 12541, connecting to:
        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OWAZUAT1)(CID=(
        PROGRAM=)(HOST=inp1db02.bagic.com)(USER=oracle))))

        VERSION INFORMATION:
        TNS for Linux: Version 9.2.0.5.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.5.0 - Production
        Time: 12-SEP-2008 21:47:21
        Tracing to file: /oracle/product/92040/network/trace/sqlnet_client_3345.trc
        Tns error struct:
        nr err code: 0
        ns main err code: 12541
        TNS-12541: TNS:no listener
        ns secondary err code: 12560
        nt main err code: 511
        TNS-00511: No listener
        nt secondary err code: 111
        nt OS err code: 0


        trace file for sqlnet_client_4444.trc
        ****************************

        [12-SEP-2008 21:43:43:500]
        --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
        [12-SEP-2008 21:43:43:508] New trace stream is /oracle/product/92040/network/trace/sqlnet_client_3244.trc
        [12-SEP-2008 21:43:43:508] New trace level is 6
        [12-SEP-2008 21:43:43:508] --- TRACE CONFIGURATION INFORMATION ENDS ---
        [12-SEP-2008 21:43:43:508]
        --- PARAMETER SOURCE INFORMATION FOLLOWS ---
        [12-SEP-2008 21:43:43:508] Attempted load of system pfile source /oracle/product/92040/network/admin/sqlnet.ora
        [12-SEP-2008 21:43:43:508] Parameter source loaded successfully
        [12-SEP-2008 21:43:43:508]
        [12-SEP-2008 21:43:43:508] Attempted load of local pfile source /home/oracle/.sqlnet.ora
        [12-SEP-2008 21:43:43:508] Parameter source was not loaded
        [12-SEP-2008 21:43:43:508]
        [12-SEP-2008 21:43:43:508] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
        [12-SEP-2008 21:43:43:508] Successful parameter table load
        [12-SEP-2008 21:43:43:508] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
        [12-SEP-2008 21:43:43:508] SQLNET.EXPIRE_TIME = 0
        [12-SEP-2008 21:43:43:508] trace_level_client = ADMIN
        [12-SEP-2008 21:43:43:508] NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
        [12-SEP-2008 21:43:43:508] LOG_FILE_CLIENT = sqlnet_client.log
        [12-SEP-2008 21:43:43:508] SQLNET.AUTHENTICATION_SERVICES = (NONE)
        [12-SEP-2008 21:43:43:508] TRACE_FILE_CLIENT = sqlnet_client.trc
        [12-SEP-2008 21:43:43:508] LOG_DIRECTORY_CLIENT = /oracle/product/92040/network/log
        [12-SEP-2008 21:43:43:509] TRACE_DIRECTORY_CLIENT = /oracle/product/92040/network/trace
        [12-SEP-2008 21:43:43:509] --- PARAMETER SOURCE INFORMATION ENDS ---
        [12-SEP-2008 21:43:43:509]
        --- LOG CONFIGURATION INFORMATION FOLLOWS ---
        [12-SEP-2008 21:43:43:509] Log stream will be "/oracle/product/92040/network/log/sqlnet_client.log"
        [12-SEP-2008 21:43:43:509] Log stream validation not requested
        [12-SEP-2008 21:43:43:509] --- LOG CONFIGURATION INFORMATION ENDS ---

        [12-SEP-2008 21:43:43:517] nigini: entry
        [12-SEP-2008 21:43:43:517] nigini: Count in NI global area now: 1
        [12-SEP-2008 21:43:43:517] nigini: Count in NI global area now: 1
        [12-SEP-2008 21:43:43:517] nrigbi: entry
        [12-SEP-2008 21:43:43:517] nrigbni: entry
        [12-SEP-2008 21:43:43:517] nrigbni: Unable to get data from navigation file tnsnav.ora
        [12-SEP-2008 21:43:43:517] nrigbni: exit
        [12-SEP-2008 21:43:43:517] nrigbi: exit
        [12-SEP-2008 21:43:43:517] nigini: exit
        [12-SEP-2008 21:43:43:517] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
        [12-SEP-2008 21:43:43:518] nnfgiinit: entry
        [12-SEP-2008 21:43:43:518] nnftboot: entry
        since this trace file is a very big so i cant paste full if u want more i have attached that file only..

        now i pasted tail -f of sqlnet_client_444.trc
        [oracle@inp1db02 trace]$ tail -f sqlnet_client_3244.trc
        [12-SEP-2008 21:50:41:988] nioqrc: entry
        [12-SEP-2008 21:50:41:988] nsdo: cid=0, opcode=85, bl=0, what=0, uflgs=0x0, cflgs=0x3
        [12-SEP-2008 21:50:41:988] nsdo: rank=64, nsctxrnk=0
        [12-SEP-2008 21:50:41:988] nsdo: nsctx: state=8, flg=0x420d, mvd=0
        [12-SEP-2008 21:50:41:988] nsdo: gtn=127, gtc=127, ptn=10, ptc=2011
        [12-SEP-2008 21:50:41:988] nsdo: switching to application buffer
        [12-SEP-2008 21:50:41:988] nsrdr: recving a packet
        [12-SEP-2008 21:50:41:988] nsprecv: 53 bytes from leftover
        [12-SEP-2008 21:50:41:989] nsprecv: tlen=53, plen=2011, type=6


        client tnsnames.ora file:
        ***********************

        OWAZUAT3=
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521))
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = OWAZUAT3)
        )
        )
        OWAZDEVP=
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521))
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = OWAZDEVP)
        )
        )
        hope this is not full required coz i can able to ping to that database..

        CONNECTION CHECK(TELNET)

        Trying 10.1.3.30...
        Connected to 10.1.3.30 (10.1.3.30).
        Escape character is '^]'.

        This is somewhat but not full and lucid details of client machine...

        Regards,
        M.Murali..
        • 16. Re: ORA-TNS:12541
          EdStevens
          >
          now lets come to the matter..
          first i ll start from the tnsping on client machine:
          *****************************************
          It could have been helpful to see the actual command as well .... however,
          TNS Ping Utility for Linux: Version 9.2.0.5.0 - Production on 12-SEP-2008 21:45:58

          Copyright (c) 1997 Oracle Corporation. All rights reserved.

          Used parameter files:
          /oracle/product/92040/network/admin/sqlnet.ora


          Used TNSNAMES adapter to resolve the alias
          Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OWAZUAT1)))
          OK (10 msec)


          [oracle@inp1db02 ~]$ sqlplus system@owazuat1

          SQL*Plus: Release 9.2.0.5.0 - Production on Fri Sep 12 21:46:33 2008

          Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

          Enter password:
          ERROR:
          ORA-12541: TNS:no listener


          sqlnet_client.log(client machine)
          ****************************

          Fatal NI connect error 12514, connecting to:
          (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(
          SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVPS)(CID=(PROGRAM=)(HOST=inp1db02.bagic.com
          )(USER=oracle))))

          VERSION INFORMATION:
          TNS for Linux: Version 9.2.0.5.0 - Production
          TCP/IP NT Protocol Adapter for Linux: Version 9.2.0.5.0 - Production
          Time: 12-SEP-2008 19:30:44
          Tracing to file: /oracle/product/92040/network/trace/sqlnet_client_32121.trc
          Tns error struct:
          nr err code: 0
          ns main err code: 12564
          TNS-12564: TNS:connection refused
          ns secondary err code: 0
          nt main err code: 0
          nt secondary err code: 0
          nt OS err code: 0




          Fatal NI connect error 12541, connecting to:
          (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVP)(CID=(
          PROGRAM=)(HOST=inp1db02.bagic.com)(USER=oracle))))
          Hmm.

          On your tnsping, it shows that it was resolved to (SERVICE_NAME = OWAZUAT1)

          On your SQLPlus, it shows that it was resolved to (SERVICE_NAME=OWAZDEVP)

          The listener status you showed us in an earlier msg did not list either of these services. Also, that output shows the listener is on IP 10.1.2.2, while the traces you show are looking to a server at 10.1.3.30

          This also doesn't square with the snippet of tnsnames.ora that you gave earlier, showing a service name of STAGEDB. All in all, it looks like we're trying to hit a moving target because you are showing us consistent source.

          When testing with tnsping, you need to be aware that tnsping goes no further than the listener. You can get a successful tnsping against a box using a non-existent service name. tnsping only shows that there is an oracle listener active on the designated server at the designated port. So if you have a listener at 10.1.1.1, you can create an entry in your client tnsnames.ora designating service 'FOOBAR' at host=10.1.1.1 and get a successful tnsping even though the listener at 10.1.1.1 knows nothing of FOOBAR.

          So, you need to go all the way through your configuration and make sure you are comparing apples to apples. Of particular interest should be the host and service names referenced in your clients tnsnames.ora file and how those match up to the services listed by the listeners at the referenced hosts.
          • 17. ORA-TNS:12541
            639811
            Hi steven,
            yesterday i was left office. thats y i couldn't reply to u.
            so where the exact problem resides?

            i have correct entry regarding the connecting database service names and ip including port.
            (i.e)
            clinet tnsnames.ora
            server listener.ora both ports are 1521 only.
            now ip,port,service_name everything is right but why still its not happen?
            please let me know and thanks for ur patience?

            Regards,
            M.Murali..

            Edited by: Balamurali on Sep 13, 2008 1:22 PM

            Edited by: Balamurali on Sep 13, 2008 1:24 PM
            • 18. Re: ORA-TNS:12541
              EdStevens
              Balamurali wrote:
              Hi steven,
              yesterday i was left office. thats y i couldn't reply to u.
              so where the exact problem resides?
              I can't tell where the problem resides because you keep showing different service names, different host ip addresses, and you keep leaving out critical evidence, like the exact command line you use to generate what you do show. It's hard to nail a problem when it appears to be a moving target. Did you read my last post, where I pointed up the inconsistent service names and ip addresses?
              • 19. Re: ORA-TNS:12541
                EdStevens
                Balamurali wrote:
                Hi steven,
                yesterday i was left office. thats y i couldn't reply to u.
                so where the exact problem resides?

                i have correct entry regarding the connecting database service names and ip including port.
                (i.e)
                clinet tnsnames.ora
                server listener.ora both ports are 1521 only.
                now ip,port,service_name everything is right but why still its not happen?
                please let me know and thanks for ur patience?

                Regards,
                M.Murali..

                Edited by: Balamurali on Sep 13, 2008 1:22 PM

                Edited by: Balamurali on Sep 13, 2008 1:24 PM
                OK, let's start at the very beginning and take this one simple step at a time. As I recall your db is on a windows box, and your client is on a nix box, is that correct?  If so, log on to your client (nix) box, issue the following commands, capture the entire session (commands as well as results) and post them.

                $> whoami
                $> echo $ORACLE_HOME
                $> echo $TNS_ADMIN

                IF you have value for TNS_ADMIN, issue

                $> cat $TNS_ADMIN/sqlnet.ora
                $> cat $TNS_ADMIN/tnsnames.ora

                ELSE issue

                $> cat $ORACLE_HOME/network/admin/sqlnet.ora
                $> cat $ORACLE_HOME/network/admin/tnsnames.ora
                • 20. ORA-TNS:12541
                  639811
                  Hi stevens,
                  find the answers for the command which u gave ..
                  1.)whoami
                  oracle
                  2.)echo $ORACLE_HOME
                  /oracle/product/92040
                  3.)echo $TNS_ADMIN

                  It returns no value.

                  4.)cat $ORACLE_HOME/network/admin/sqlnet.ora
                  SQLNET.AUTHENTICATION_SERVICES = (NONE)
                  NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

                  TRACE_LEVEL_CLIENT=16

                  LOG_DIRECTORY_CLIENT=/oracle/product/92040/network/log

                  LOG_FILE_CLIENT=sqlnet_client.log

                  SQLNET.EXPIRE_TIME=0

                  trace_level_client = ADMIN

                  TRACE_DIRECTORY_CLIENT=/oracle/product/92040/network/trace

                  TRACE_FILE_CLIENT=sqlnet_client.trc
                  5.) cat $ORACLE_HOME/network/admin/tnsnames.ora
                  STAGEDB =
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1)(PORT = 1521))
                  (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = STAGEDB)
                  )
                  )

                  OWAZUAT3=
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521))
                  (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = OWAZUAT3)
                  )
                  )
                  OWAZDEVP=
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521))
                  (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = OWAZDEVP)
                  )
                  )
                  These all are the results..

                  Regards,
                  M.Murali..
                  • 21. Re: ORA-TNS:12541
                    Maran Viswarayar
                    Can you comment out the below paramter and see
                    SQLNET.AUTHENTICATION_SERVICES = (NONE)
                    in the sqlnet.ora .this paramter is for windows not for unix AFAIK
                    • 22. Re: ORA-TNS:12541
                      639811
                      Hi
                      first i commented that line

                      sqlnet.authentication=(nts)

                      now i changed into

                      sqlnet.authentication=(none)

                      But there is no improvement at all..

                      Regards,
                      M.Murali..
                      • 23. Re: ORA-TNS:12541
                        Maran Viswarayar
                        Bala,

                        Just comment out that line and see it will work ;)
                        • 24. Re: ORA-TNS:12541
                          639811
                          I already comment that line.now u want me to comment again but i dont think so it will work
                          anyway i will try and let u know the result..

                          Regards,
                          M.Murali...
                          • 25. Re: ORA-TNS:12541
                            Maran Viswarayar
                            What i mean was to comment out the line itself and not the value to NTS or NONE

                            I believe thay are windows specifc

                            #SQLNET.AUTHENTICATION_SERVICES=NONE
                            • 26. Re: ORA-TNS:12541
                              639811
                              hi i tried all these things which u have mentioned.
                              thanks for ur pormpt reply.
                              but can u give me some more idea regarding this..
                              Now i commented the below line.
                              SQLNET_AUTHENTICATION_SERVICES=(NONE)

                              Now in client machine it throws ORA:12535 TNS:Operation timed out(LINUX)


                              Regards,
                              M.Murali..
                              • 27. Re: ORA-TNS:12541
                                Maran Viswarayar
                                This could be due to the firewall
                                • 28. Re: ORA-TNS:12541
                                  Maran Viswarayar
                                  see if this works since you are in linux

                                  sqlnet.authentication_services=kerberos5
                                  • 29. Re: ORA-TNS:12541
                                    antti.koskinen
                                    This could be due to the firewall
                                    What does "telnet <server_ip> <server_listener_port>" return?