Re: protocol.ora

Hi

I only have one database running on this machine..

I have read somewhere that you can use sqlnet.ora instead of protocol.ora ?

Regards

Saj Iqbal

On Mon, 15 Apr 2002, Xiaohong Yang (Sharon) wrote:

> Sajid,
>
> I used protocol.ora to restrict connection based on ip on oracle 8.1.6.3.0
> and now 8.1.7.2.0 (Solaris 8). I don't have problem.
>
> However, when I had two sets of databases running on the same ORACLE_HOME
> and using two listeners for these two sets of databases, I had
> complications. The behavior was that the listener that had the
> protocol.ora in the directory had to be started after the other one
> (somehow the restriction stayed in the memory). If you failed to start the
> restricted-listener last, or restarted the open-connection listener after
> the restricted-listener is running, then the open-set of databases don't
> have open connections.
>
> Hope this helps.
> Sharon
>
> -------------------------------------------------------
> Xiaohong Yang (Sharon)
> certified Oracle DBA
> Center for Bioinformatics
> CB#7100
> UNC-CH,
> Chapel Hill, NC 27599
> (919)843-6106 (office)
> (919)966-6821 (fax)
>
> ----------------------------------------------------
> Date: Mon, 15 Apr 2002 08:59:01 +0100 (BST)
> Subject: Re: protocol.ora
>
> Hi
>
> I tried this however I get the same result as in it doesn't allow any
> connections at all..even IP addresses which are included in the
> .protocol.ora file.
>
> Regards
>
> Saj Iqbal
>
>
> On Fri, 12 Apr 2002, Jeremiah Wilton wrote:
>
> > If you trace the listener you will see that it is looking for
> > .protocol.ora with a leading period. This is a documented bug. Just
> > copy protocol.ora to .protocol.ora.
> >
> > --
> > Jeremiah Wilton
> > http://www.speakeasy.net/~jwilton
> >
> > On Fri, 12 Apr 2002, Sajid Iqbal wrote:
> >
> > > We used to use the protocol.ora file to restrict access to the database,
> > > on oracle 8.0.5
> > >
> > > However since moving to Oracle 8.1.6.3 this doesn't work.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jeremiah Wilton
> > INET: jwilton_at_speakeasy.net
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Xiaohong Yang (Sharon)
> INET: yangx_at_email.unc.edu
>
> 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).
>

-- 
Sajid Iqbal
Database Team Leader

VIA NET.WORKS
620 Birchwood Boulevard
Birchwood
Warrington
WA3 7QZ
DDI: +44 (0) 1925 484485  Fax: +44 (0) 1925 484466
Email: siqbal_at_vianetworks.co.uk
Website: http://www.vianetworks.co.uk

local touch global reach





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sajid Iqbal
  INET: siqbal_at_vianetworks.co.uk

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).