Re: listener cannot read SERVICE_NAME

On 28 Dec 2003 05:27:30 -0800, adachtler_at_web.de (Axel Dachtler) wrote:

>> 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.
>
>Hello,
>
>do you mean this file???
>IT CONTAINS NO service_name parameter !
>
>
>init.ora.1142003202414:

Due to the file name of the init.ora you must be using the spfile mechanism and your init.ora has been created from the spfile. Thus it will only contain the non-default parameters. This means in your case the service_name parameter still is used and has been defaulted to db_name||'.'||db_domain, in your case oracle.localhost.
You can verify this by issuing
show parameter service_name
in sql*plus

--
Sybrand Bakker, Senior Oracle DBA