Re: changing service name

Thank you, will try.

sybrandb wrote:
> 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
Received on Wed Nov 29 2006 - 14:16:52 CST