1 2 Previous Next 16 Replies Latest reply on Mar 9, 2013 3:04 PM by 972355 Go to original post
      • 15. Re: TNS-03505: Failed to resolve name
        969352 wrote:
        If the TNS alias matches the ORACLE_SID, then all is OK.

        In my case , i mentioned uniq names. So i should use net sevice_name from tnsnames.ora

        In my env training session : always using same name  so i  got confused. (sid_name , tns_alias_name , global_name)

        Thank you very much sb;
        You still have a lot of confusion about how it all fits together. You may have got it working, but you really don't understand WHY.

        read: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
        read: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex)
        read: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154tns-03505 
        1 person found this helpful
        • 16. Re: TNS-03505: Failed to resolve name
          Thanks Ed Stevens ..

          I red your blog . It pretty well explained. Given informations are very beyond from my llittle knowledge.

          *I need to learn  many things to understand  experts  blogs [ http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/]*

          - Thanks for kind help ..
          1 2 Previous Next