RE: Two Instances at one oracle Server

No.. Not necessary for more listeners.
One listener is enough to listen many servers.

Nirmal.

> -----Original Message-----
> From: tday6_at_csc.com [SMTP:tday6_at_csc.com]
> Sent: Thursday, September 20, 2001 5:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Two Instances at one oracle Server
>
> I'm sure that someone will correct me if I'm wrong but:
>
> The database is the physical datafiles laid out on the storage devices -
> hard disks;
> The instance is the logical constructions (SGA) that exist, hopefully, in
> RAM;
> The services are the NT operating system equivalent of UNIX processes
> which
> run the Oracle engine against the instance to access the database.
>
> In theory, an instance could be used to access multiple databases;
> however,
> in practice, DBAs set up one instance that will be used to access one
> database (and no other database).
>
> Also, databases could, in theory, be accessed from multiple instances;
> however, in practice, DBAs set up a database to be accessed from only one
> instance (and no other instance).
>
> Microsoft NT sets up the service so that it executes against one, given
> instance. However, NT will allow multiple services.
>
> So, you can have two databases, two instances, and two services on the
> same
> NT server. You'll also need two listeners and two services to run those
> listeners.
>
> You'll probably need to read the manuals for the exact details.
>
>
>
>
>
> Nirmal Kumar
>
> Muthu Kumaran To: Multiple recipients of
> list ORACLE-L
> <NIRMALK_at_qtel <ORACLE-L_at_fatcity.com>
>
> .com.qa> cc:
>
> Sent by: Subject: Two Instances at one
> oracle Server
> root_at_fatcity.
>
> com
>
>
>
>
>
> 09/19/2001
>
> 03:55 AM
>
> Please
>
> respond to
>
> 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:
> INET: tday6_at_csc.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).