Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: changing service name

Re: changing service name

From: <markg22003_at_yahoo.com>
Date: 29 Nov 2006 12:16:52 -0800
Message-ID: <1164831412.793483.270520@j44g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US