1 2 3 Previous Next 44 Replies Latest reply on Sep 17, 2008 3:16 AM by Maran Viswarayar Go to original post
      • 30. Re: ORA-TNS:12541
        639811
        Hi

        [oracle@inp1db02 admin]$ telnet 10.1.3.30 1521
        Trying 10.1.3.30...
        Connected to 10.1.3.30 (10.1.3.30).
        Escape character is '^]'.

        These are the o/p of the telnet
        pls find this.. and let me know if u have any other ideas than this.
        i think telnet is not a issue..
        its happening ..

        Regards,
        M.Murali..
        • 31. Re: ORA-TNS:12541
          639811
          Hi maran,
          i tried this sqlnet_authentication_services=(kerberos5)
          in database server(windows)
          and then i restart the listener also.
          pls let me know any other needs to be done on linux box(client)
          and telnet also happening .. on port 1521

          Regards
          M.Murali..
          • 32. Re: ORA-TNS:12541
            antti.koskinen
            The telnet thing was just to make sure you have connectivity from the client machine to the server machines listener port.

            If that goes smooth, the next thing would be to check that the client has connectivity to the port assigned by the listener after the handshake phase. If you need more data, set the listeners TRACE_LEVEL to SUPPORT for example.
            • 33. Re: ORA-TNS:12541
              EdStevens
              OK, you have 3 databases to choose from:

              STAGEDB at (HOST = 10.1.1.1)

              OWAZUAT3 at (HOST = 10.1.3.30)

              OWAZDEVP at (HOST = 10.1.3.30)

              Which one are we dealing with? Take that one and, on the client machine issue the following and report back. I'm going to show the commands assuming we want STAGEDB. You will adjust according to which db we are dealing with. Pick one and stay with it.

              $> whoami
              $> echo $ORACLE_HOME
              $> tnsping stagedb
              $> sqlplus system@stagedb
              • 34. Re: ORA-TNS:12541
                639811
                Hi stevens
                see the below o/p which u asked me in earlier mail..
                [oracle@inp1db02 ~]$ tnsping owazdevp

                TNS Ping Utility for Linux: Version 9.2.0.5.0 - Production on 15-SEP-2008 19:05:
                17

                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.3
                0)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OWAZDEVP))
                )
                OK (10 msec)

                [oracle@inp1db02 ~]$ echo $ORACLE_HOME
                /oracle/product/92040


                [oracle@inp1db02 ~]$ sqlplus customer@owazdevp

                SQL*Plus: Release 9.2.0.5.0 - Production on Mon Sep 15 19:05:24 2008

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

                Enter password:


                ORA:12535: TNS:operation timed out

                FYI,
                telnet is also happening

                [oracle@inp1db02 ~]$ telnet 10.1.3.30 1521
                Trying 10.1.3.30...
                Connected to 10.1.3.30 (10.1.3.30).
                Escape character is '^]'.

                Regards,
                M.Murali..
                • 35. Re: ORA-TNS:12541
                  EdStevens
                  Balamurali wrote:
                  Hi stevens
                  see the below o/p which u asked me in earlier mail..
                  Yes, but in various posts you were showing results without command lines,and we were seeing discrepancies in database/services names, and discrepancies in IP address. That's why I'm going through it like this.
                  [oracle@inp1db02 ~]$ tnsping owazdevp

                  <snip>

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


                  [oracle@inp1db02 ~]$ sqlplus customer@owazdevp

                  SQL*Plus: Release 9.2.0.5.0 - Production on Mon Sep 15 19:05:24 2008

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

                  Enter password:


                  ORA:12535: TNS:operation timed out
                  Ok, so you've got your addressing problems resolved. That is connect string matches tnsnames, which matches listener, which matches server. Now you are getting a connect timeout. Searching MetaLink for tns-12535 (any ora-12nnn errors are really tns-12nnn and should be searched that way), the very first hit we get is Note:119706.1, "Troubleshooting Guide TNS-12535 & ORA-12535 Errors". That's where you should go next.
                  • 36. Re: ORA-TNS:12541
                    antti.koskinen
                    The fact that telnet and tnsping succeed means that you have connectivity to port 1521 on the server machine. Unless you're using shared_socket (which imo isn't the best of options), that's only half a victory though, because you also need to be able to connect to the actual client port assigned by the listener.
                    • 37. Re: ORA-TNS:12541
                      639811
                      so how to proceed now? is there problem in the network?

                      Regards
                      M.Murali..
                      • 38. Re: ORA-TNS:12541
                        antti.koskinen
                        so how to proceed now?
                        EdStevens has already provided you with a valid starting point.

                        You can of course just set shared_socket if you want to try something quick & dirty.
                        • 39. ORA-TNS:12541
                          639811
                          Hi
                          i made the entry on windows-server registry-->oracle home
                          USE_SHARED_SOCKET=TRUE

                          But that also not works..
                          • 40. Re: ORA-TNS:12541
                            antti.koskinen
                            Double-check that you've set it correctly, restart your services and try again.

                            If the problem persists, continue troubleshooting as suggested earlier in the thread.
                            • 41. ORA-TNS:12541 PROBLEM RESOLVED!!!!!!
                              639811
                              Hi koskinen,
                              atlast after a five days struggle frustration comes to an end....

                              yes that problem is resolved and i can able to connect to the all databases which are residing in the server(windows
                              after made the **USE_SHARED_SOCKET=TRUE** in regedit)
                              where i did the mistake is i haven't restart the services i just start the database and listener. after i saw ur mail i tried once again (almost hopeless!!!!)
                              But after start the services,listener and db when i tried the same in linux it immediately connects to the database..

                              Thanks a lot for u and stevens and rest of all those who spend ur valuable time and give so many tips for me...

                              have a great day..

                              see u all soon in a next problem..

                              Regards,
                              M.Murali...
                              • 42. Re: ORA-TNS:12541 PROBLEM RESOLVED!!!!!!
                                Maran Viswarayar
                                Timed out error is mostly raised when the firewall block the connections

                                The parameter USE_SHARED_SOCKET in the DB server makes sure it responds back in the same listener port
                                • 43. Re: ORA-TNS:12541 PROBLEM RESOLVED!!!!!!
                                  639811
                                  Hi maran
                                  yes exactly its a very usefull parameter.prev i dont know what it does?but now i got some idea about this.

                                  Regards
                                  M.Murali..
                                  • 44. Re: ORA-TNS:12541 PROBLEM RESOLVED!!!!!!
                                    Maran Viswarayar
                                    You can normally avoid this problem by

                                    1.setting this paramter
                                    2.by configuring connection manager
                                    3.in the firewall level,it’s stateful, analyzing SQLNET2 protocol and letting only valid oracle connections get through.You have to initiate connection on listener port with a valid SQLNET2 request, and firewall takes care of the rest.

                                    but the third one depeds on the Firewall vendor whether they support this feature or not

                                    From 10g onwards you can set this parameter in listener.ora to avoid this

                                    DIRECT_HANDOFF_TTC_<listener_name>

                                    Cortesy to Metalink,internet
                                    1 2 3 Previous Next