RE: Two Instances at one oracle Server

[Henry Poras]

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 -----Original Message----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 12:52 PM To: Multiple recipients of list ORACLE-L Subject: 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 >>> [EMAIL PROTECTED] 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 of list ORACLE-L                          <NIRMALK@qtel        <[EMAIL PROTECTED]>                                                .com.qa>             cc:                                                                   Sent by:             Subject:     RE: Two Instances at one oracle                          root@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:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > 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@qtel        <[EMAIL PROTECTED]> > >                     .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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).