Title: how to rename a database SID
HI !
How can i rename a database on NT / UNIX ?
Thanks a lot in advance !
Title: how to rename a database SID
See
Note Note:15390.1Subject:How to Determine and Change
DB_NAME or ORACLE_SID on MetaLink
Here it is
below
Rick
Purpose This entry describes how
to find and change the "db_name" for a database, or the
ORACLE_SID for an instance, without
just recreate database control file.
On Mon, 18 Jun 2001, Andrey Bronfin wrote:
HI !
How can i rename a database on NT / UNIX ?
Thanks a lot in advance !
--
Lucy Lin Oracle DBA
condenet.com 212-286-3852
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lucy
You must also change the dbname parameter in the init.ora file
-Original Message-
Sent: Monday, June 18, 2001 2:18 PM
To: Multiple recipients of list ORACLE-L
just recreate database control file.
On Mon, 18 Jun 2001, Andrey Bronfin wrote:
HI !
How can i rename a database on NT /
Title: how to rename a database SID
Uday:
You forgot one important step. In the 'create
controlfile' command
line, where you change the database SID you must add
the word 'SET'.
For example, if the trace file was created
as...
CREATE CONTROLFILE REUSE DATABASE "OLDSID" N