Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Two Instances at one oracle Server

RE: Two Instances at one oracle Server

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Wed, 19 Sep 2001 06:40:13 -0700
Message-ID: <F001.00392866.20010919060028@fatcity.com>

Also be sure your ORACLE_SID is set properly in the environment.  I believe that will take care of the confusion with the pfile.   It's a knee-jerk reaction for me - before signing in to svrmgrl I always check the $ORACLE_SID

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Sinardy [SMTP:sinardyxing_at_bcsis.com]
Sent:   Wednesday, September 19, 2001 8:46 AM
To:     Multiple recipients of list ORACLE-L
Subject:        RE: Two Instances at one oracle Server

Hi,

I think you must do something like

startup pfile=...

pfile is your parameter file for 2nd db(your init<SID>.ora)

That error message mean that Oracle try to start db1 again...

Sinardy

-----Original Message-----
Kumar Muthu Kumaran
Sent: Wednesday, 19 September 2001 7: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: 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).
Received on Wed Sep 19 2001 - 08:40:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US