Re: Solaris: How to make a new instance

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 - 11:51:35 CDT