Integrating Discoverer 9iAS SSO Logins With 9i Database Logins

Wednesday, December 17th, 2003 by Mark Rittman

“When using Discoverer 9iAS (the one that comes with 9iASr2) and public connections, the row-level security i’d set up on the Oracle database doesn’t work any more. How can we integrate the SSO logins and discoverer logins such that our database row-level security now works?”
I had a similar situation happen with a recent client, and this […]

Which Versions Of Linux Work With Oracle RAC?

Wednesday, December 17th, 2003 by Mark Rittman

“I was wondering what Oracle 9i RAC could be installed on. I had a look around and it seams to be tested on Redhat linux enterprise. The current version is is 3 and there are WS,AS & ES version. I could download and compile & build, but it’s loads of work, can I use the […]

Oracle Collaboration Suite 2.0 Certified With Symantec Antivirus Engine

Tuesday, December 16th, 2003 by Mark Rittman

Interesting bit of news on OCS: Oracle Collaboration Suite 2.0 has been certified to work against the Symantec Antivirus Engine, in order to scan data in the Email module. Looks like you install Symantec’s Antivirus tool on either the same server as OCS (in the case of a Solaris or RedHat installation) or connect to it […]

Don Burleson On Buffer Busy Waits

Saturday, December 13th, 2003 by Mark Rittman

“One of the most confounding problems with Oracle is the resolution of buffer busy wait events. Buffer busy waits are common in an I/O-bound Oracle system, as evidenced by any system with read (sequential/scattered) waits in the top-five waits in the Oracle STATSPACK report … The main way to reduce buffer busy waits is to […]

Installing Oracle 9iR2 On RedHat Enterprise Server 3.0 and Fedora

Thursday, December 4th, 2003 by Mark Rittman

Looking to install Oracle 9i Release 2 on RedHat’s new Enterprise Server 3.0?
Werner Puschitz has produced a comprehensive guide to getting 9i Release 2 installed and running on RHES 3.0, including a number of useful hints such as;

make sure you download and install the 9.2.0.4 patchset
relink gcc so that the older gcc will be […]