RE: Two Instances at one oracle Server

Hi,

It looks as though you are trying to start the instance from svrmgrl? In that case, use the SET ORACLE_SID=SIDNAME, to force the oracle name before you start svrmgrl.
Or try in svrmgrl: connect internal @SIDNAME

Another way of doing this is re-create the services using oradim and set starttype to srv,inst.
e.g. C:\> ORADIM - STARTUP -SID SID -USERPWD PASSWORD -STARTTYPE SRV,INST That way all you have to do is start the service from service manager and both the service and the instance will start.

I hope that helps
Denham :)

-----Original Message-----
Sent: Wednesday, September 19, 2001 1:30 PM To: Multiple recipients of list ORACLE-L

How?

I started first one, then i try to startup 2nd, it says, "Cann't start - already started, shut it down first".

Nirmal.

> -----Original Message-----
> From: Sinardy [SMTP:sinardyxing_at_bcsis.com]
> Sent: Wednesday, September 19, 2001 12:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Two Instances at one oracle Server
>
> Hi,
>
> I think you can do that ?
>
> Just start up both of them together
>
>
>
> Sinardy
>
>
> -----Original Message-----
> Kumar Muthu Kumaran
> Sent: Wednesday, 19 September 2001 3:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Guru's
>
> In my test oracle server, i created two different database with SID
> 'orclsvr' and 'ora817'.
>
> Is't possisle to create two oracle database instances on the same server?.
>
>
> Presently am able to create only one instance at a time either for the sid
> 'orclsvr' or 'ora817'.
>
> Oracle Server 817 on Win NT4 based.
>
> Regards,
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar Muthu Kumaran
> INET: NIRMALK_at_qtel.com.qa
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy
> INET: sinardyxing_at_bcsis.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denham Eva
  INET: EvaD_at_TFMC.co.za

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).