Re: Simple way to rename an instance?

You say you are renaming an instance, but you are attempting to rename the database as well from you description. The way to rename a database is to recreate the controlfiles with a different database name. You can do this by doing an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, modifying the output of this command (which is a file in your BACKROUND_DUMP_DEST directory) by adding the SET DATABASE <db_name> clause to the genereate CREATE CONTROLFILE command, doing a full cold backup of the database as a saftey precaution, and then running the modified CREATE CONTROLFILE command. If I understand what you did about renaming datafiles, you will also have to make these changes in the database before opening the database for use. To be able to mount the database to do the ALTER DATABASE command, you will need to change the db_name parameter in you init.ora back to the original value.

Hope this helps.

John Durst

gary e. robinson wrote:

> Hi,
>
> Any suggestions?
>
> I just did a fresh install of Oracle 7.2.2 on Sun Sparc Solaris 2.5.1
> and I need to change the instance name due to a conflict.
>
> I impulsively edited and renamed lots o'files like initX.ora,
> configX.ora, data files, control files, listener.ora, tnsnames.ora,
> etc, etc, but find that the CONTROL FILE is now holding things up with
>
> the following error: (Silly me.)
>
> SQLDBA> startup
> ORACLE instance started.
> ORA-01103: database name 'A' in control file is not 'REPO'
> Attempting to shutdown instance........ORACLE instance shut down.
>
> Must I rename every object from *within* Oracle in order to keep the
> control file up to date?
>
> (Sure would be nice to take binary file editor to the control file.)
>
> Thanks in advance,
> Gary Robinson
> Gary E. Robinson
> ger_at_world.std.com
> "eschew obfuscation such as this."
Received on Sun Nov 02 1997 - 00:00:00 CST