| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Two Instances at one oracle Server
True. However, I find it useful to have one listener per instance so that I can restrict access to an instance without having to alter the database.
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: RE: Two Instances at one oracle
root_at_fatcity. Server
com
09/20/2001
11:30 AM
Please
respond to
ORACLE-L
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). -- 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).Received on Thu Sep 20 2001 - 10:18:30 CDT
 |
 |