Re: Renaming a Database

used the CREATE CONTROLFILE and It worked great. I had to learn that you change the Init<sid>.ORA file first then STARTUP NOMOUNT the database with the new Init<sid>.ora file and run the CREATE CONTROLFILE command and the startup the database. It took alittle bit to get the syntax correct but all is well.

Thanks for everyone's help

Jimmy

Rick Henry wrote:
>
> Also keep in mind that if you use sql*net to connect to the
> database, you will need to modify the listener.ora and tnsnames.ora
> files to match the new instance name.
>
> HTH
> Rick
> =========================
>
> On Sat, 27 Feb 1999, Thomas Kyte wrote:
>
> > A copy of this was sent to "Yiannis Mavridis" <nm89035_at_central.ntua.gr>
> > (if that email address didn't require changing)
> > On Sat, 27 Feb 1999 05:03:01 +0200, you wrote:
> >
> > >No James there is no way to change the name. You should recreate the
> > >database
> > >
> > >James Lewthwaite wrote in message <36D727EA.3184BBDC_at_gte.net>...
> > >>Hello all,
> > >> I am Using Oracle8 for Novell. When I install the Database it creates
> > >>a seed database with a <SID> of ORCL and a DB name of ORACLE. If I
> > >>change this in the init<>.ora I get a database name mismatch.
> > >>
> > >>Do I need to drop the seed db and create a new one or is there an easy
> > >>way to rename it???
> > >>
> > >>Jimmy
> > >
> >
> > i didn't see the original post, however the create controlfile statement allows
> > you to rename the database. see the sql reference manual for more info...
> >
> > CREATE CONTROLFILE
> >
> > Purpose
> > To recreate a control file in one of the following cases:
> >
> > o All copies of your existing control files have been lost through
> > media failure.
> > o You want to change the name of the database.
> > o You want to change the maximum number of redo log file
> > groups, redo log file members, archived redo log files, data files,
> > or instances that can concurrently have the database mounted
> > and open.
> >
> >
> >
> >
> >
> >
> > Thomas Kyte
> > tkyte_at_us.oracle.com
> > Oracle Service Industries
> > Reston, VA USA
> >
> > --
> > http://govt.us.oracle.com/ -- downloadable utilities
> >
> > ----------------------------------------------------------------------------
> > Opinions are mine and do not necessarily reflect those of Oracle Corporation
> >
> >

Received on Tue Mar 02 1999 - 09:09:37 CST