Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154: TNS:could not resolve service name
Just be aware that the setting for the TNS_ADMIN environment variable ( make it a system one to be safe)
will be ( assume for this example that OraHome90 is c:\oracle\ora90 ) :
TNS_ADMIN=c:\oracle\ora90\network\admin
Hth,
"iulian" <4spam_at_mail.com> wrote:
>Thanks. The first one suit my needs, I guess. I just didn't want to copy the
>tnsnames.ora to all existing homes, every time I change something.
>
>iulian
>
>
>"Karsten Farrell" <kfarrell_at_medimpact.com> wrote in message
>news:7sYt9.556$nh1.32699675_at_newssvr13.news.prodigy.com...
>> iulian wrote:
>> > Hi guys. My problem is:
>> > I installed Oracle Server 9i and Developer Forms & Reports 6i on the
>same
>> > machine, in this order, and now there are 2 oracle homes OraHome90 and
>> > OraDev.
>> > I keep getting this error (ORA-12154: TNS:could not resolve service
>name)
>> > when I try to connect using Forms Builder, or a third party Oracle
>client or
>> > SQLPlus in OraDev. Yet, I am able to connect using the SQLPlus in the
>> > OraHome90 or Entrprise Manager.
>> > I've created an entry in tnsnames.ora in OraHome90 pointed to my server,
>but
>> > not similar one in the OraDev. I made the OraHome90 the default home.
>What
>> > else? What did I miss?
>> > Thanks in advance.
>> >
>> > iulian
>> >
>> >
>> BTW, I removed all but one of your cross-posts ... so you'll only see my
>> answer here. Most of the regulars monitor all the NGs you cross-posted to.
>>
>> You have two choices:
>>
>> 1. Set TNS_ADMIN environment variable to your OraHome90. That will tell
>> all your software in OraDev to look over there. Of course, you'll have
>> to make sure your OraHome90 tnsnames.ora has all the necessary entries
>> from your OraDev tnsnames.ora.
>>
>> 2. Make one copy with all the necessary entries from both and copy that
>> one to *every* other tnsnames.ora you can find. In Windows, do a Start /
>> Search (or Find); in Unix do a 'find $ORACLE_HOME -name tnsnames.ora
>> -print'. They should all be identical.
>>
>
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Oct 24 2002 - 15:42:11 CDT