Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tnsnames and such... HELP!
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)
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
![]() |
![]() |