Title: RE: Two Instances at one oracle Server

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:[EMAIL PROTECTED]]
    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:[EMAIL PROTECTED]]
    > 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: [EMAIL PROTECTED]
    >
    > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
    >
    > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

    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: [EMAIL PROTECTED] (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).

Reply via email to