Re: How to specify SID during db creation?

From: Bass Chorng <bass_at_octel.com>
Date: 18 May 1999 20:46:44 GMT
Message-ID: <7hsjjk$mt5$2@news.eng.octel.com>

Brian Gallagher (briang_at_iona.com) wrote:
: create database "ORCL2"

: the above part of the create dataabse statement will determine the
: SID

: regards
: brian
: Kenny Gump wrote in message <374170e9.0_at_news.mountain.net>...
: >A SID is just an Environment Variable that Oracle uses to find the files.
: >So to create a new one just ORACLE_SID=ORCL2; export ORACLE_SID
: >

I think Kenny is right.

SID has nothing to do with db_name, although in most environments they are identical, but it does not mean they have to be the same.

SID is strickly an OS thing. It works together with your environment variable, oratab, and init.ora file - these are the things you need to take care of when changing SID.

Your database name is branded into controlfile. To change it, you have to drop and recreate controlfile.

SO, SID and db_name ( which has to match your create database xxxx statement ) can be irrelevent.

Regards

-Bass Chorng Received on Tue May 18 1999 - 15:46:44 CDT