Re: How to specify SID during db creation?

From: Mark Powell <>
Date: 18 May 1999 18:37:10 GMT
Message-ID: <01bea15d$880f7f20$>

You set your Oracle instance variable in UNIX and export it before you enter svrmgrl to create your database: $ORACLE_SID=ORCL2 and each instance of Oracle should have its own initSID.ora parameter file located in $ORACLE_HOME/dbs. You could also re-create the ORCL database to change the blocksize and import the data to bring it back to the same point in time if all the data will fit in a single export file. You can still do it if the database is too big it just involves more work. wrote in article <7hr0tv$n4f$>...
> Hi,
> I am running Oracle 8.05 on Solaris 2.6. I have an old db instance
> with db block 2k. I am now trying to create a new db instance 'ORCL2'
> 4k block size. I would like to know how to specify instance name(SID)
when I
> create a new db?? There is only 'db_name' in the init file and I don't
> I can specify it in 'Create database' statement. Thanks.
> BTW, what's the difference between db_name and SID?
> Ed
> --== Sent via ==--
> ---Share what you know. Learn what you don't.---
Received on Tue May 18 1999 - 20:37:10 CEST

Original text of this message