Re: tnsnames and such... HELP!

From: T. Schwickert <schwickert_at_yahoo.com>
Date: 23 Aug 2001 01:16:16 -0700
Message-ID: <5fcc15a8.0108230016.6ac0a795@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 - 03:16:16 CDT