Re: Problem with Oracle 11G on Fedora 16 and 17

> I have an oracle installation (11.2.0.3) and suddenly various system
> configuration tools, like the one for printer (I recently bought a
> refurbished HP LaserJet IV, after checking that it doesn't contain the
> Itanium chip) started crashing. The problem was in the expat library
> which exists in the $ORACLE_HOME/lib. Red Hat bug is:
>
> https://bugzilla.redhat.com/show_bug.cgi?id=829531
>
> The workaround is to install instant client and point the local
> ORACLE_HOME there. Oracle's libexpat.so.1 is patched and not the same as
> the OS library with the same name and version. That is really troubling
> because expat XML parser is used just about everywhere.

Another workaround is to distinguish between an interactive log-in and a batch one by using -t like this:

set -am
if [ -t 0 ]; then

   TERM=vt100
   tset -r
   stty quit '^Y' erase '^H' echoe;
   ORACLE_BASE=/oracle
   ORACLE_HOME=$ORACLE_BASE/product/11.2.0/11.2.0.3 else

   ORACLE_HOME=/usr/lib/oracle/11.2/client64 fi

That will make the full blown Oracle client available for terminal sessions and instant client home for the clients like SQL*Developer or Tora. BTW, Tora doesn't link on F17 (64 bit). I had to modify two source files to get it to work. That's probably a quirk of the compiler.

-- 
http://mgogala.byethost5.com