| 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
LOL. You want be to give up all my secrets? OK. You also have a maintenance listener which is not on ONAMES or the user's TNSNAMES.ORA. Your DBA group keeps working without worrying about stepping on users or having users lock objects. It's simplistic but it works great if your DBA group is geographically distributed.
JOE TESTA
<JTESTA_at_longab To: Multiple recipients of list ORACLE-L
erger.com> <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.c Subject: RE: Two Instances at one oracle
om Server
09/20/2001
12:52 PM
Please respond
to ORACLE-L
ok i give, what is the difference between
1. shutting down a listener
2. alter database enable restricted session where only the DBAs have
restricted session.
and without a listener, the local connected people can still connect to the database, so you've only stoppped remote connections by stopping the listener.
joe
>>> tday6_at_csc.com 09/20/01 12:20PM >>>
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 oflist ORACLE-L
<NIRMALK_at_qtel <ORACLE-L_at_fatcity.com> .com.qa> cc: Sent by: Subject: RE: Two Instancesat 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). -- 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 - 11:33:29 CDT
 |
 |