protocol.ora file is no longer supported in 9i.
joe
>>> ctrassens_at_YAHOO.COM 09/26/01 11:25AM
>>>You can use Connection Manager and define rules.Although you
will need to change the net servicesentries of the tnsnames.ora or from the
names or fromLDAP, just to source the client to the ConnectionManager
before the server itself.Or if you use TCP/IP as the protocol for Net8,
you canuse the file protocol.ora. In order to restrict theaccess you
must include these two
lines:tcp.validnode_checking=TRUEtcp.excluded_nodes=(<ip or
name>,.....).....or better if there two many:tcp.included_nodes
(<ip or name>....)Regards.--- "O'Neill, Sean"
<Sean.ONeill_at_organon.ie> wrote:> If I wish to do work on a database
logging in to> server itself and want to> prevent users from
accessing the system via network> is there another way to> do this
if I don't want to use the "enable> restricted session">
functionality. I'm thinking there's probably a neat> way to
utiltise the> listener process but have not figured it out.
> > Also what If I need to work on DB over network but>
don't want any other> users using DB what can I do to prevent
their> connecting?> > > Sean :)> >
Data Base Administrator> Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K>
[0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O> [0%] OCP Oracle9i
DBA> -------------------------------- ------------ > Organon
(Ireland) Ltd.> E-mail: sean.oneill_at_organon.ie [subscribed:
Digest> Mode]> > Visit: <A
href="
http://groups.yahoo.com/group/Oracle-OCP-DBA">
http://groups.yahoo.com/group/Oracle-OCP-DBA>
> "Nobody loves me but my mother... and she could be> jivin'
too." - BB King> > > > > > --
> Please see the official ORACLE-L FAQ:> <A
href="
http://www.orafaq.com">
http://www.orafaq.com> -- >
Author: O'Neill, Sean> INET: Sean.ONeill_at_organon.ie>
> 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).=====Eng. Christian
TrassensSenior DBASystems
Engineerctrassens_at_yahoo.comctrassens_at_hotmail.comPhone :
541149816062__________________________________________________Do You
Yahoo!?Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger.
http://im.yahoo.com--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
Christian Trassens INET: ctrassens_at_yahoo.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 Wed Sep 26 2001 - 11:05:41 CDT
