RE: Two Instances at one oracle Server

how do you start the database ?
with the servermanager ??

If you do so, so you have to set the
variable for the SID value on the value of the other instance.

On Unix-maschines it looks like:

ORACLE_SID=new_sid
export ORACLE_SID

Then you are able to start the second instance.

Wolfgang Ludewig

                                                                                       
                         
                      Nirmal Kumar                                                     
                         
                     Muthu Kumaran       To:  Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                   <NIRMALK_at_qtel.c       cc:                                           
                         
                            om.qa>       Subject:  RE: Two Instances at one oracle 
Server                       
                   Sent by:                                                            
                         
                   root_at_fatcity.co                                                     
                         
                   m                                                                   
                         
                                                                                       
                         
                                                                                       
                         
                                                                                       
                         
                    19.09.01 13:30                                                     
                         
                    Please respond                                                     
                         
                       to 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: 
  INET: wolfgang.ludewig_at_systor.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).