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
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 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:
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
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).
Received on Thu Sep 20 2001 - 10:53:13 CDT
