tag:blogger.com,1999:blog-8884584404576003487.post338184513514198597..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: TNS-03505: Failed to resolve nameoraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8884584404576003487.post-42514144676404361042010-09-03T09:56:23.357-04:002010-09-03T09:56:23.357-04:00Hi, With OBIEE11g you should put another tnsnames....Hi, With OBIEE11g you should put another tnsnames.ora file to Oracle BI Home under {Oracle_BI1}\network\admin directory.salihoztophttps://www.blogger.com/profile/17410707544410563394noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-2779797291892422962010-09-03T05:46:29.037-04:002010-09-03T05:46:29.037-04:00Great addition. I had those kind of questions so m...Great addition. I had those kind of questions so many times I "even" wrote a blog post about it.<br /><br />The following might help<br /><br /><a href="http://www.liberidu.com/blog/?p=115" rel="nofollow">Small introduction to SQL*Net debugging [client side]</a><br /><br />Grz<br /><br />MarcoMarco Gralikehttps://www.blogger.com/profile/12810709424310804316noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-57526248583331724522010-09-02T23:49:56.042-04:002010-09-02T23:49:56.042-04:00Gergo,
I tried that one (a bunch) too. Problem w...Gergo,<br /><br />I tried that one (a bunch) too. Problem was, I was using tnsping <b>testing</b> not tnsping <b>ORACLR_CONNECTION_DATA</b><br /><br />Amusingly, "testing" worked, I'm sure there's a good reason for that (I think I had a "testing" service name defined).<br /><br />chetoraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-34369724540987699952010-09-02T23:47:43.755-04:002010-09-02T23:47:43.755-04:00Hi
tnsping -?
it shows the sqlnet.ora file
sqlne...Hi<br /><br />tnsping -?<br />it shows the sqlnet.ora file<br /><br />sqlnet.ora should be :<br />#--------------------------<br />SQLNET.AUTHENTICATION_SERVICES= (NTS)<br />NAMES.DIRECTORY_PATH= (TNSNAMES)<br />#---------------------------<br />...<br />after test your tns:<br />tnsping ORACLR_CONNECTION_DATA<br /><br />... have a look on TNS_ADMIN variable<br />If TNS_ADMIN set that this would be the tnsnames.ora location.<br /><br /><br />Regards<br />GergoGergo Bacskaihttps://www.blogger.com/profile/11682292736444280407noreply@blogger.com