Re: DBAs : SID Change ?

Dipankar (dasdipa_at_zeus.franklin.edu) wrote:

: >In article nalini.vallampati_at_daytonoh.attgis.com writes:
 

: >>In article <463pd4$5nv_at_news4.digex.net> Joe Nardone writes:
: >>Harshan Ramarathnam (dbhayes_at_amoco.com) wrote:
: >>: If you are on UNIX , you can set the environmental ORACLE_SID.
: >>
: >>I think they meant "change the SID of an existing database".
: >>
: >>Joe
: >>
: >
: >Would it help to change the SID in all the files that has a SID ( oratab,
: >init.ora/config.ora, .profile ) and then restart the database ? Or does
: >the SID get into some Oracle binary file somewhere along the line and
: >really cannot be changed ?
: >
: >Nalini
: >
: >
: >
: >
: >Nalini Vallampati
: >UNIX Admin/Oracle DBA
: >AT&T Capital - GIS
: >Miamisburg, OH 45342
: >
: >
 

: Control file (binary) will have the SID or existing DB name. As this file
 can't
: be edited, it needs to be reproduced by "ALTER DATABASE BACKUP CONTROLFILE
 TO
: TRACE". This trace file containing necessary commands to create the control
 file
: can then be edited. Assuming necessary modifications in other files have
 already
: been made at this point, the database may be started with the new SID.
  However, I would backup my entire database before I attempt to change SID of   an existing
: database this way.
 

: Hope this helps,
 

: Dasdipa

We run on unix.

The SID of an instance and DB name of a database are separate entities. You can change the SID, as mentioned above and leave DB name as is, simply by editing and renaming files as necessary. When the database is started with ORACLE_SID set to the new instance value this is automatically recorded in the control file.

eg

	Control file	SID ben DB name ben.
	Change SID to wal.
	Control file	SID wal DB name ben.

You only need to recreate the control file if you change DB name.

Whichever the case make sure you have a good backup before you start and backup again after change.

For more detailed information contact Oracle Worldwide Customer Support for RTSS Bulletin Board Document

	No:		106373.655
	Date:		22-SEP-94
	Title:		Changing dbname or ORACLE_SID
	Abstract:	This bulletin describes how to change the dbanme
			for a database, or th ORACLE_SID for an instance,
			without having to recreate the database.

Hope this of help.

        Helen Received on Tue Oct 24 1995 - 00:00:00 CET