Re: TNS cannot solve the Service Name

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 May 2003 06:46:56 -0700
Message-ID: <2687bb95.0305210546.d3f8540@posting.google.com>

"myhome" <myhome_at_home.hk> wrote in message news:<3ecae8f6$1_at_shknews01>...
> I have installed oracle9i on solaris 9. When I use Net configuration
> assisant to set the local net service name configuration, It tell me that
> the "TNS: listener could not resolve SERVICE_NAME".
> The global database name of my database is: test.person.net
> SID is: test
>
> this error occur even I set service name to test.person.net or test. And I
> have set listener to TCP before setting local net service name. Is there any
> thing I have done in wrong way?
>
> thx in ur help
>
> pulse

Pulse, where is the client? On the PC or DB server?

If would probably help if you posted the listener.ora and tnsnames.ora files for DB in question. Also what is the value of the init.ora service_name parameter for the database?

IMHO -- Mark D Powell -- Received on Wed May 21 2003 - 08:46:56 CDT