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: [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Xiaohong Yang (Sharon) > 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). > -- 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: [EMAIL PROTECTED] 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: [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).
