Re: changing service name

markg22003_at_yahoo.com wrote:
> We are running ORACLE 8i on a SUN OS 5.8.
>
> I would like to change our service name from what it is now
> (database/instance name) to a new service name (for security purposes).
> If I take out the old entry from our listener sid list, will this be
> enough ?
> Or will the instance still register itself under the old name (which is
> the database/instance name) ?
> Thank you.

You must be mixing up the sid and the service_name. Service_name is a parameter in init<sid>.ora. Sid is registered (amongst others) in listener.ora You can't change the SID in listener.ora *without* changing it on O/S level.
If you change the service_name in init.ora, you will need to bounce the database.
Obviously, the old service name should disappear. You can easily verify this by lsnrctl services. If you still see the old service_name, just run lsnrctl reload.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA