ip restriction help
Hi Gurus, I would like to get your recommendation for connection restriction to the databases via tcp/ip based on ip addresses. The restriction is required for only the databases that is served by one listener, not the other. Any suggestions are welcome: OS, Oracle, network... Sun Solaris 2.7 Oracle EE 8.1.6.3.0 two listeners on the same server: listener1 serves a set of databases that has MTS setup, listener2 listens for a set of databases that is configured for dedicated connections. Thanks, Sharon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xiaohong Yang 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).
Re: protocol.ora
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).
oracle 8.1.7 patch 2 or 3?
Hi, I am managing a software that uses a set of 8 oracle databases. I am preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then apply a patch to the oracle software installation after the upgrade. The software that uses these databases are only certified on patch 2 level at the time of release. Since now the patchset 3 for 817 is available, I would like to get advice in whether to apply patch 3 instead of patch 2. Same amount of work, more benefits. The only thing is that the application vendor does not officially support the patch3. platform: Sun Solaris 2.8 Oracle EE server 8.1.6.3.0 Any input is appreciated. Xiaohong Yang (Sharon) Center for Bioinfomatics UNC -- 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).
Re: oracle 8.1.7 patch 2 or 3?
Thanks Bill. I will keep that in mind. Sometimes the vendor doesn't want to spend time to help out and find this as the reason to do so. Sharon --On Thursday, February 28, 2002 11:32 AM -0500 bill thater <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > >> Hi, >> >> I am managing a software that uses a set of 8 oracle databases. I am >> preparing to upgrade all my databases from 8.1.6.3.0 to 8.1.7.0.0 then >> apply a patch to the oracle software installation after the upgrade. >> The software that uses these databases are only certified on patch 2 >> level at the time of release. Since now the patchset 3 for 817 is >> available, I would like to get advice in whether to apply patch 3 >> instead of patch 2. Same amount of work, more benefits. The only >> thing is that the application vendor does not officially support the >> patch3. > > this can lead to problems getting support for the third party > applications. i have had support withdrawn when i was at anon supported > patch level. before doing this i'd check with the support of the > application. > > > -- > -- > Bill "Shrek" Thater ORACLE DBA > [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ---- > [Unix] is not necessarily evil, like OS/2. - Peter Norton > > > > > > -- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinfomatics, CB#7100 School of Medicine UNC-CH 919-843-6016 (o) -- 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).
Re: oracle 8.1.7 patch 2 or 3
To: [EMAIL PROTECTED] Date: Thu, 28 Feb 2002 10:33:29 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain What vendor, what product? The vendor is InforMax, the product is called GenoMax. Sharon -- 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).
re: help: compile ctxsys type body
I did try to use alter type compile body, but I got an error: SQL> alter type CATINDEXMETHODS compile body; Warning: Type Body altered with compilation errors. Please help. Thanks, Sharon -- 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).
help: compile ctxsys type body
Hi, Please help me with this one. I forgot how to compile the invalid type body in the ctxsys schema. The following is the invalid object. OWNER OBJECT_NAME OBJECT_TYP -- -- CTXSYS CATINDEXMETHODS TYPE BODY Thanks in advance. Sharon -- 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).
Re: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
I am sure that you don't have any invalid objects after the patch application. I had a lot of problem with that after a patch application two years ago. Sharon -- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinfomatics, CB#7100 School of Medicine UNC-CH --- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > We have a particular database that hangs on a regular basis. Here > are the > stats and symptoms. > > Oracle stats > -- > 8.1.7.3 (highest patch level applied) > Solaris 2.7 > UTF8 character set > > Symptoms > -- > Random hanging. > Hanging meaning SQL processing stops. > New connections "hang". > No traces files. > No messages in the alert log. > Killing the Oracle processes is the only way to recover from the > problem. > > This problem has been reported to Oracle Support, they are now > escalating it > up. > > I just wanted to PING the list to see if anyone else has encountered > this. > > TIA!!! > > Chris -- 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).