Re: creating 2nd instance of Oracle?(B

You may ask Oracle WorldWide Support fax you Document Id. "105289.301"; Title "Creating a Second Database in the Unix Environment" It describes three different methods you can create second or more instances on Unix box indetail, by manually, using CRDBxxx.sql, and using ORAINST.

Joseph Suh
Oracle DBA
ClientLink
Alpharetta, Georgia

Chakravarthy Nalamotu wrote:
>
> This is what I do to create a second instance
> name "TESTINSTANCE"...
> set your environment to the new SID i.e.,
> setenv ORACLE_SID TESTINSTANCE
>
> then sqldba and startup.
>
> This method will try to read the $ORACLE_HOME/dbs/initTESTINSTANCE.ora
> file for the intialization parameters.
>
> Hope this helps.
> Kittu.
>
> Yuri Ludevig (WBRD34A_at_prodigy.com) wrote:
> : I'm trying to create a second instance and database for the server that
> : already has one. I'm running into problems already just by executing
> : command "startup nomount pfile=(my startup file with a new sid in my
> : directory)". It looks like Oracle is trying to read smth from the catalog
> : of the first instance. I can't figure out why. What am I doing wrong?
> : Manuals are pretty vague on the exact steps of creating 2nd instance.
> : I've got a tar assigned but nobody called me back for a loooong time...
> : Please H-E-L-P!!!
> : Yuri in NY
> :
Received on Mon May 13 1996 - 00:00:00 CEST