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@longab To: Multiple recipients of list ORACLE-L
erger.com> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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
>>> [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).
--
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).
