From NIRMALK@qtel.com.qa Thu, 20 Sep 2001 07:42:57 -0700 From: Nirmal Kumar Muthu Kumaran Date: Thu, 20 Sep 2001 07:42:57 -0700 Subject: RE: Two Instances at one oracle Server Message-ID: MIME-Version: 1.0 Content-Type: text/plain No.. Not necessary for more listeners. One listener is enough to listen many servers. Nirmal. > -----Original Message----- > From: tday6@csc.com [SMTP:tday6@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 > > > .com.qa> cc: > > Sent by: Subject: Two Instances at one > oracle Server > root@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@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@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@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@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@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@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).