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

On 14 Apr 1998 01:59:27 GMT, dleung_at_cs.ucr.edu (Chi-Wai (Dominica) Leung) wrote:

>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
>
>

edit the initSID.ora file,, change the databsae name parameter to your new database name. Received on Wed Apr 15 1998 - 09:35:11 CDT