Re: Can I rename an Oracle Instance to another Name?

Your on the right path ....

In the create controlfile command change the line

REUSE "<database name>"

to

SET "<database name>"

You'll also have to change the NORESETLOGS to RESETLOGS. After the control file(s) have been created, the database will then have to be opened with the RESETLOGS parameter.

Hope this helps,

Andy T.
Spirocom Analysts Ltd.

Chi-Wai (Dominica) Leung wrote in message <6guftv$9im$1_at_skylark.ucr.edu>...
>Hi ALL,
>
>
>
> How do you rename a database Instance?
> Or is it possible??
>
>For example, originally, I have an Oracle Instance named DOM01.
>
>I want it to be called DATAWHSE now.
>What is the quickest way of doing it?
>
>
>1) I create
>
> $ORACLE_HOME/../../admin/DATAWHSE subdirectory
>and underneath has pfile create udump..
>
>2) I rename initDOM01.ora to initDATAWHSE.ora
> rename initDOM01_0.ora to initDATAWHSE_0.ora
> rename configDOM01.ora to configDATAWHSE.ora
> Change the content of initDATAWHSE.ora from DOM01 to DATAWHSE.
>
>3) I rename redoDOM0101.log to redoDATAWHSE0101.log
> rename redoDOM0102.log to redoDATAWHSE0102.log
> rename redoDOM0103.log to redoDATAWHSE0103.log
>
>
>shutdown the old instance.
>
>change environmental variables to:
>
>unsetenv ORACLE_SID
>setenv ORACLE_SID DATAWHSE
>
>
>svrmgrl
>
>I try to re-create a control file.
>I have create a trace file.
>Inside whatever it say "DOM01" become "DATAWHSE".
>
>I got the following error:
>
>SVRMGR> @/u1/app/oracle/admin/NEWDOM01/udump/create_control
>ORACLE instance started.
>Total System Global Area 8344844 bytes
>Fixed Size 39696 bytes
>Variable Size 7170556 bytes
>Database Buffers 1126400 bytes
>Redo Buffers 8192 bytes
>CREATE CONTROLFILE DATABASE "NEWDOM01" NORESETLOGS ARCHIVELOG
>*
>ORA-01503: CREATE CONTROLFILE failed
>ORA-01161: database name DOM01 in file header
>does not match given name of NEWDOM01
>ORA-01110: data file 1: '/u5/oradata/NEWDOM01/system01.dbf'
>ORA-01507: database not mounted
>ORA-01507: database not mounted
>ALTER DATABASE OPEN
>*
>
>
>Thank you in advance,
>
>
>
>Dominica Leung
>
>Please email me directly to
>
>dleung_at_cs.ucr.edu
>
>
Received on Tue Apr 14 1998 - 12:29:24 CDT