3 Replies Latest reply: Mar 11, 2013 11:38 PM by 956800 RSS

    Database link works with os authentication but not with tns alias

    883404
      Hi All,
      Today we had faced one strange issue,Database links suddenly stopped working.When checked, db links are working fine in OS authentication with the same user.But when we run after logged in using TNS_ALIAS from client as well database server,it throws "tns could not resolve the connect identifier specified" error.But we were able to tnsping the remote database.When we checked sqlnet.ora file was missing,so we copied it from backup and recycled listener.But as far as I know,we should be able to connect to remote database without sqlnet.ora.

      Please let me know the role of sqlnet.ora in this situation.why it is not working with tnsnames.ora?


      Thanks
      SRJ