Archive for the ‘Linux/Unix’ Category

libxp.so.6 is missing in installation of BI Publisher

Friday, November 13th, 2009

I ran into this when I tried to install BI Publisher on Linux, I solved it by installing libXp (yum install libXp).

Also, extracting the downloaded tar file with WinRAR is not the way to go. Somehow my jar files ended up as directories which resulted in the following error:
Error loading library: generalQueries
Using tar to untar was the way to go here.

Installing database 11gR2 on linux

Thursday, November 12th, 2009

I am trying to install database 11gR2 onto a (virtual) Oracle Unbreakable Linux machine (do they still call it that?). Here are the things I ran into:

  • I downloaded 2 different zips, but they need to be extracted into the same folder.
  • Be sure to have configged the yum repository correctly, because you need to install some libraries with it before or during the installation (libaio, unixOCBD, sysstat)
  • Turn off SELinux (or set it to permissive at least)
  • To make the database start automatically, look here (and don’t forget to change /etc/oratab)
  • a .bashrc for user oracle with environment variables is useful!

FRM-92101 error

Wednesday, January 4th, 2006

Under windows this is not needed but a Forms application under Linux apparently needs an LD_LIBRARY_PATH in its env file to find libraries like libhpi.so
Mine looked like this:

LD_LIBRARY_PATH=/u02/app/oracle/as101202/lib/:/u02/app/oracle/
as101202/jdk/jre/lib/i386/server/:/u02/app/oracle/as101202/jdk/jre/
lib/i386/native_threads/:/u02/app/oracle/as101202/jdk/jre/lib/i386/:
/u02/app/oracle/product/as101202/jre/1.4.2/lib/i386/client/:/u02/app/
oracle/product/as101202/jre/1.4.2/lib/i386/native_threads/

Without it I got an FRM-92101 error, and in the application logfile in /j2ee/OC4J_BI_Forms/application-deployments/formsapp
/OC4J_BI_Forms_default_island_1/application.log
I saw this:
06/01/04 14:56:19 formsweb: Forms session <9> aborted: runtime process failed during startup with errors /u02/app/oracle/product/as101202/bin/frmweb: error while loading shared libraries: libhpi.so: cannot open shared object file: No such file or directory

Compiling forms on linux (no graphical interface)

Wednesday, January 4th, 2006

Today someone needed my help compiling forms under linux. We tried compiling whilst being logged in with Putty, but received the following error:

FRM-91500: Unable to start/complete the build.

Metalink came up with note 266731.1 which was too much of a hassle for me to read (I prefer short and concise solutions) and so I searched the oracle forums and found this:

http://forums.oracle.com/forums/thread.jspa?messageID=697343򪏿

The solution was as follows:

export TERM=vt220
export DISPLAY=:0.0
frmcmp.sh module=
.fmb userid=/ @ module_type=FORM compile_all=yes batch=yes

and voila!