Re: Rename an Oracle Instance

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B4DE696.2EB3170C_at_attws.com...
> Brian Peasland wrote:
>
> > Stelios,
> >
> > Yes, you can rename your database on NT. Use the ORADIM80 utility to
> > delete your old services and create new ones. Just type 'ORADIM80' on
> > the command line for help information.
> >
> > HTH,
> > Brian
> >
> > Stelios Karkazis wrote:
> > >
> > > Hi all,
> > >
> > > I have an NT 4.0 server with an Oracle Database (8.05) installation,
> > >
> > > I wonder if I can rename my instance to DEV, I mean if there is a way
 to
> > > change also the Services in NT without create a new database and copy
 the
> > > whole thing in it, 'cause I have not enough space.
> > >
> > > Thanks in advance
> > >
> > > Stelios Karkazis
>
> Or just go into TNSNAMES.ORA, change the alias to DEV, and save the file.
 The
> instance's name is irrelevant.
>
> Daniel A. Morgan
>

How about when you are on the server and use the ORACLE_SID env var or registry key.
Your advice is going to result in a hybrid environment!

Other than that the initial advice is incomplete because controlfile names, the init.ora's name and some init.ora's contents need to be changed as well.

And of course : 8.0.5 is desupported

Regards,

Sybrand Bakker, Received on Thu Jul 12 2001 - 13:40:28 CDT