Re: tnsnames and such... HELP!

Pings work fine.

Put the NAMES.DEFAULT_DOMAIN = world
and NAME.DEFAULT_ZONE = world into sqlnet.ora.

The parens seem to match up in tnsnames.ora. I count 8 left and 8 right that are uncommented in that section. I added one anyway just in case you saw one that I'm not seeing.

In any event, I still have the same problem. I'm stumped! Any idea where to go from here?

TIA, Wayne

T. Schwickert wrote in message
<5fcc15a8.0108230016.6ac0a795_at_posting.google.com>...
>Hi,
>
>first, be sure that you can reach your host, i.e. ping pctas109 is
succesfull ?
>Then, look in sqlnet.ora and be sure that
>NAMES.DEFAULT_DOMAIN = world
>and NAME.DEFAULT_ZONE = world
>
>(after second looking through your post)
>
>and than, edit your tnsnames.ora and remove the last # in the w98 section
:-)
> W98.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = pctas109)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = W98)))
> # (CONNECT_DATA =
> # (SERVICE_NAME = W98)
> # )
> # ) <--- this # is too much i would say
>
>Hth
> Thomas
>
>
>"Wayne" <bruzek_at_erols.com> wrote in message
news:<9m0li0$fvv$1_at_bob.news.rcn.net>...
>> I'm about ready to shoot myself!
>>
>> I installed 8i on a Win/98 box and all was well. Then installed
>> Developer 6i - had to use a different home, so I made another
>> and did the install. All well, except when I try to connect to the
>> database from forms builder, I get ORA-12154: TNS could not
>> resolve service name. I use SCOTT/TIGER and a database name
>> of W98. I started the listener with LSNRCTL and it appeared
>> happy enough. I get the exact same error when trying to do
>.....
Received on Thu Aug 23 2001 - 08:14:43 CDT