Re: Solaris: How to make a new instance

Okay,

    Step one create an init<sid>.ora file for your new instance. the easiest way is to copy the your initME1.ora file and just do the minimum editing needed to prevent conflicts.

    Step two run the CREATE DATABASE command from the server manager prompt -- but don't even attempt this until after you have read the manual. Better yet get a copy of the DBA Handbook by Kevin Loney (Oracle Press) and review the example.

regards

Jerry Gitomer

kgorman100_at_my-dejanews.com wrote in message <7ic02m$7kb$1_at_nnrp1.deja.com>...
>I am afraid I may have not communicated my problem correctly.
>
>There is an existing instance on the machine. So there are existing
>processes that go with that instance. I.E. The SID is ME1 and the
>processes are:
>
>ora_pmon_ME1
>ora_lgwr_ME1
>...
>
>Also, selecting from v$instance indicates that the instance name is ME1.
>
>NOW, what I want to do is create another instance. It would be called
>ME2. I would like new processes called:
>
>ora_pmon_ME2
>ora_lgwr_ME2
>...
>
>What is the mechanism for specifying this? Just setting a new SID does
>not seem to work. I have scoured every piece of documentation I can
>find. There does not seem to be a Solaris equivelent of ORADIM80.
>
>Please help.
>
>
>
>
>
>
>
>
>
>
>In article <7i5bg0$mb9$1_at_news1.skynet.be>,
> "Gerard H. Pille" <ghp_at_skynet.be> wrote:
>> Having a look at the installation guide would be wise.
>>
>> Otherwise, suppose you want to create a database-instance called RTFM:
>>
>> have $ORACLE_HOME/bin on your path
>> export ORACLE_SID=RTFM
>> create the initRTFM.ora file, in which, amongst others, you specify
>the
>> db-name
>> start svrmgrl
>> connect internal
>> startup nomount pfile=.../initRTFM.ora (or just startup nomount if
>pfile is
>> in $ORACLE_HOME/dbs)
>> create database RTFM ...
>>
>> Gerard (this is my name, please don't execute me)
>>
>> kgorman_at_match.com heeft geschreven in bericht
>> <7i43i8$361$1_at_nnrp1.deja.com>...
>> >I am wondering, how do I make a new instance on a Solaris Machine. I
>> >want to leave the existing instance in place (and it's processes) and
>> >create a new one (with new processes). In NT you would use the
>ORADIM80
>> >program. What is the equivalent in Solaris?
>> >
>> >Help would be cool...
>> >
>> >
>> >
>> >--== Sent via Deja.com http://www.deja.com/ ==--
>> >---Share what you know. Learn what you don't.---
>>
>>
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Mon May 24 1999 - 12:51:33 CDT