4 Replies Latest reply: Jun 14, 2012 4:42 AM by orabackus RSS

    issue with tnsnames.ora file

    942006
      Hi All,

      This is my tns file,while connecting to the server database i am getting this error number
      ORA-12545. but keep on trying again and again i am able to connect.
      Plese help me on this issue.

      Old:

      dmsrp01r.world =
      (description =
      (address = (protocol = tcp)(host = xyz1.org)(port = 1521))
      (address = (protocol = tcp)(host = xyz2.org)(port = 1521))
      (load_balance = yes)
      (connect_data =
      (server = dedicated)
      (service_name = dmsrp01r)
      (failover_mode =
      (type = select)
      (method = basic)
      (retries = 180)
      (delay = 5)
      )
      )
      )
      -----------------------------------------------------------
      with this tns file i am able to login successfully every time.

      NEW:
      dmsrp01r.world =
      (description =
      (address = (protocol = tcp)(host = xyz1.org)(port = 1521))
      (address = (protocol = tcp)(host = xyz2.org)(port = 1521))
      (load_balance = yes)
      (connect_data =
      (service_name = dmsrp01r)
      )
      )
      if I am using this tns entry is it any problem?

      Thanks
      Vij