Re: oralce 9i net config

czhu_at_worldnet.att.net (caobin zhu) wrote in message news:<3e66a2b1.2561162_at_netnews.worldnet.att.net>...
> Really it is very simple:
> I set it up in the net configuration with a regular name and default
> port (1521). Then try to use the same info to load SQL*Plus .
>
> or while I am in sql, trying to use:
>
> connect name/password_at_service_name
>
> then got an error:
>
> ORA-12154 TNS: could not resolve service name.
>
> Thanks again for any help.
>
> On Wed, 05 Mar 2003 08:38:47 -0800, DA Morgan
> <damorgan_at_exesolutions.com> wrote:
>
> >caobin zhu wrote:
> >
> >> Hi,
> >>
> >> I am trying to connect from 9i to 8 via sql applet. I tested from
> >> within net configuration and net manager and both ok. But just can not
> >> connect from sql. Any advise?
> >> Thank a lot.
> >> caobin
> >
> >Post code and full error messages. No one here can look over your
> >shoulder.
> >
> >Daniel Morgan

If service_name isn't your 'regular name' you won't connect. You have to use the same name you gave the 'alias' in your tnsnames.ora file. And that is what the message is telling you ... you don't have 'service_name' defined in TNSNAMES.ORA.

David Fitzjarrell Received on Thu Mar 06 2003 - 15:25:51 CST