Re: oralce 9i net config

Thank you everyone for helping me making the connection between 9i to 8. I realized that I did not have my net service name in my oracle 8 server pc. After I use the net8 easy config to config one then I can make the connection.

Still a kind of strange? I don't remember if I ever created a service name in 9i. I only made on service name in net8 and than I can connect to 9i. Mybe there is a version difference.

Thanks again.
On 6 Mar 2003 13:25:51 -0800, oratune_at_msn.com (David Fitzjarrell) wrote:

>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 Sun Mar 09 2003 - 21:31:35 CST