Re: How to specify SID during db creation?

From: Mark Powell <Mark.Powell_at_eds.com>
Date: 18 May 1999 18:37:10 GMT
Message-ID: <01bea15d$880f7f20$a12c6394_at_J00679271.ddc.eds.com>


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.

ewong74_at_netscape.net wrote in article <7hr0tv$n4f$1_at_nnrp1.deja.com>...
> Hi,
>
> I am running Oracle 8.05 on Solaris 2.6. I have an old db instance
'ORCL'
> with db block 2k. I am now trying to create a new db instance 'ORCL2'
with
> 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
think
> I can specify it in 'Create database' statement. Thanks.
>
> BTW, what's the difference between db_name and SID?
>
> Ed
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>
Received on Tue May 18 1999 - 20:37:10 CEST

Original text of this message