Re: listener cannot read SERVICE_NAME

On 26 Dec 2003 11:25:10 -0800, adachtler_at_web.de (Axel Dachtler) wrote:

>Hi,
>
>I have a listener problem. The listener cannot read SERVICE_NAME in
>TNS-Descriptor. The service-name I specified in Oracle Net Manager for
>this database is testdb as well.
>
>(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=axel-0560nntbn1)
>(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testdb)))
>
>It is a local database so I tried testdb.localhost, but this didn't
>work too!
>
>Thanks
>
>Axel

Listener's don't read service_names. The database register itselfs with the listener. The listener gets the service_name from the service_name parameter in init.ora.
 The service_name parameter in init.ora is the only thing which counts.

--
Sybrand Bakker, Senior Oracle DBA