how to rename a database SID

2001-06-18 Thread Andrey Bronfin
Title: how to rename a database SID HI ! How can i rename a database on NT / UNIX ? Thanks a lot in advance !

RE: how to rename a database SID

2001-06-18 Thread Cale, Rick T (Richard)
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

Re: how to rename a database SID

2001-06-18 Thread Lucy Lin
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

RE: how to rename a database SID

2001-06-18 Thread Cale, Rick T (Richard)
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 /

RE: how to rename a database SID

2001-06-18 Thread Vergara, Michael (TEM)
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