RE: Two Instances at one oracle Server

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Thu, 20 Sep 2001 09:34:15 -0700
Message-ID: <F001.00393D61.20010920093527@fatcity.com>

Well one advantage to playing with the
listener is if you have to test an application which connects from a client. We have some applications where there is no direct connection to the server; everything is through the listener. We can change ports on the listener and tnsnames.ora to allow just a privileged subset to use the application.

Henry

  <FONT
  face=Tahoma>-----Original Message-----From: JOE TESTA   [mailto:JTESTA_at_longaberger.com]Sent: Thursday, September 20, 2001   12:52 PMTo: Multiple recipients of list ORACLE-LSubject:   RE: Two Instances at one oracle Server   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 thatI 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

respond

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 atone> 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 sameserver?.>> Presently am able to create only one instance at a time either for thesid> 'orclsvr' or 'ora817'.>> Oracle Server 817 on Win NT4 based.>> Regards,> Nirmal.> --> Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com">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: <A
  href="http://www.orafaq.com">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: <A
href="http://www.orafaq.com">http://www.orafaq.com--Author: Nirmal Kumar Muthu Kumaran INET: NIRMALK_at_qtel.com.qaFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

  Lists--------------------------------------------------------------------To

  REMOVE yourself from this mailing list, send an E-Mail messageto:   ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message   BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing   list you want to be removed from). You mayalso send the HELP command   for other information (like subscribing).-- Please see the   official ORACLE-L FAQ: <A
  href="http://www.orafaq.com">http://www.orafaq.com-- Author:
INET: tday6_at_csc.comFat City Network
  Services    -- (858) 538-5051 FAX: (858) 538-5051San   Diego, California        -- Public Internet   access / Mailing

  Lists--------------------------------------------------------------------To