Can I rename an Oracle Instance to another Name?

From: Chi-Wai <dleung_at_cs.ucr.edu>
Date: 14 Apr 1998 01:59:27 GMT
Message-ID: <6guftv$9im$1@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?

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 Mon Apr 13 1998 - 20:59:27 CDT