6 Replies Latest reply: Mar 28, 2013 11:40 PM by sam995972 RSS

    LDAP connectivity issue

    sam995972
      Hi All,

      OS:solaris 10
      Database version: Oracle10g R2 (10.2.0.5)

      We are connecting to Oracle DB through LDAP, by that time facing below error.

      Error occurred : TNS-12535: TNS Operation timed out
      ORA-12170: Connect Timeout Occurred.

      we are using oracle 10g (10.2.0.1) client.
      is it client bug?
      please suggest.
        • 1. Re: LDAP connectivity issue
          sb92075
          sam995972 wrote:
          Hi All,

          OS:solaris 10
          Database version: Oracle10g R2 (10.2.0.5)

          We are connecting to Oracle DB through LDAP, by that time facing below error.

          Error occurred : TNS-12535: TNS Operation timed out
          ORA-12170: Connect Timeout Occurred.

          we are using oracle 10g (10.2.0.1) client.
          is it client bug?
          please suggest.
          The most common cause for TNS-12535 is due to Firewall on or between client & DB Server.

          when was the last time connections worked without error?
          What changed since then?
          • 2. Re: LDAP connectivity issue
            sam995972
            its new connection.

            from local desktop we are able to ping the server.port burn also done,no firewall problem...

            we have two types of networks to connect the db server from one network is connecting ,not connecting other.

            please tell me what are the parameters do i need to check,wether LDAP are configure properly or not?
            • 3. Re: LDAP connectivity issue
              moreajays
              Hi Sam,

              Make sure ping as well as telnet is also working from both n/w

              As it is connecting from one n/w , identify what is the change in second n/w

              Get tnsping o/p , check if ldap servers is reachable from db & vice versa

              Check below links if ldap is properly configured

              http://www.orafaq.com/wiki/Ldap.ora
              http://laurentschneider.com/wordpress/2006/10/migration-of-tnsnamesora-to-ldap-sun-java-system-directory-server.html


              Thanks,
              Ajay More
              http://www.moreajays.com
              • 4. Re: LDAP connectivity issue
                KR10822864
                refer below notes.
                Troubleshooting Guide TNS-12535 or ORA-12535 or ORA-12170 Errors [ID 119706.1]
                • 5. Re: LDAP connectivity issue
                  KR10822864
                  refer:
                  http://docs.oracle.com/cd/E23824_01/html/821-1455/setupproblems-3.html#scrolltoc
                  • 6. Re: LDAP connectivity issue
                    sam995972
                    we have checked with network team,its a network issue.its been resolved.
                    thanks all.