Re: SERVICE_NAME and SID ???

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 May 2001 19:58:15 +0200
Message-ID: <tgdctn93p8upba@beta-news.demon.nl>

<astrodan_at_tiscalinet.it> wrote in message news:fopget030dqk2dm4m55can32sr48eioibt_at_4ax.com...
> Hello! This is Danilo from Rome.
> I've the following error message:
>
> TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
> (Oracle 8.1.6 on Solaris)
>
> In listener.ora and tnsnames.ora there are no entry like
> SERVICE_NAME=.....
>
> Which are the differences between SERVICE_NAME and SID?
> I know the SID from $ORACLE_SID, but how may I know SERVICE_NAME?
>
> And, which entries have I put in listener.ora and tnsnames.ora ??
>
> Please help me !!!
>
> Danilo

You should use the net8 assistant (netasst.sh) to configure your network and nothing can go wrong. Ok, I agree you will need to have X-windows running.

If you still prefer to do it manually:

If you don't need to support Oracle 7.3 and 8.0 clients and/or Oracle Enterprise Manager,
the only thing you need to do with respect to the listener is to configure the address list.
If you set the service_name parameter in init.ora, the database will register itself with the listener.
On the client side the service_name needs to be present in the connect_data section of the service alias in tnsnames.ora

Of course, this is all discussed in the Net8 administrators manual, and simple configuration files are included.

Please don't post 4 times in sucession.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat May 19 2001 - 12:58:15 CDT