Wendy and the Oracle

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

Snuffel — Fri, 13 Nov 2009 13:19:02 +0000

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

Snuffel — Thu, 12 Nov 2009 14:23:38 +0000

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!

Forms: the order of items in a block

Snuffel — Mon, 15 Jun 2009 12:35:08 +0000

Today I manually added items to a block in a form, but I forgot to place them in the right order. They were added at the bottom of the block, but somewhere in the middle of my screen (in the layout editor). After saving the values at runtime, somehow, the values ended up in the wrong boxes!
After correcting the order in the block this issue was solved.

usesUpload=”true”

Snuffel — Tue, 21 Apr 2009 13:42:06 +0000

Whenever you use an inputFile component in a JSF page, don’t forget to set usesUpload of the form to true.
I think JDeveloper should do this automagically whenever you drag it in.

But it doesn’t, so this is a reminder

Datasources in Weblogic

Snuffel — Tue, 17 Mar 2009 13:15:48 +0000

Yay for JDeveloper 11g and Weblogic. I have to learn everything all over again. Like datasources. These are the things I need to think about when creating a datasource in Weblogic:

- In the target section I need to tick the AdminServer checkbox.

- The JNDI name of the datasource should be jdbc/somethingDS

- The name of the connection in JDeveloper should also be “something” (don’t know why)

block status-”CHANGED” after post-query trigger fills nondatabase items

Snuffel — Thu, 01 Nov 2007 12:57:36 +0000

A very annoying bug that has apparently been around for ages and never been solved:

When you have a lookup field (nondatabase) with an LOV and set ‘validate-from-lov’ to true, your blockstatus is set to ‘CHANGED’ when you fill the lookup in the post_query trigger.

This is silly because you are changing nondatabase items. The following post shows that this has been a problem since 2000:

http://forums.oracle.com/forums/thread.jspa?messageID=253582𽺎

I found a document on metalink about this, which is dated 31 oct 2007.
I tested the solution provided in the document and it works!

Compile all your forms at once

Snuffel — Fri, 28 Sep 2007 10:17:20 +0000

This is the script I use to compile all forms in a directory using ifcmp90.

set ORACLE_HOME=c:oracle10gdevsuite
for %%p in (”*.fmb”) do c:oracle10gdevsuitebinifcmp90 module=.%%p module_type=form userid=/

@ batch=YES
don’t forget the ORACLE_HOME bit, if it is not set correctly you might end up with an ORA-12538: No such protocol adapter

ora-12538

Snuffel — Fri, 28 Sep 2007 10:14:34 +0000

I have this script that uses ifcmp90 to compile all forms in one directory. I sometimes need it when I change a library, but lately it has been failing me with an ORA-12538: No such protocol adapter. I had been fiddling around with my oracle homes and apparently I broke this.

It turned out that the error occurs when you have your oracle_home environment variable not set correctly. It is usually set to the home of the database but for ifcmp90 i needed to set it to the devsuite home.
This solved it

iAS 10.1.3.0

Snuffel — Fri, 28 Sep 2007 10:13:52 +0000

If you try to log into iAS 10.1.3.0 and you get the following error:

This OC4J is configured to make JMX connections via RMIS and fall back to RMI if the RMIS port is not configured. The RMIS connection on the OC4J instance home on Application Server iashome.asdes is configured but a connection could
not be established. The JMX proto is specified by the oracle.oc4j.jmx.internal.connection.proto property in opmn.xml

go to metalink note 365062.1 if you are running iAS 10.1.3.0 and db 10.2.0.1. on the same machine. It worked for me

Or install 10.1.3.1, it’s alot better….

ADF JSF : selected row in a table, get rid of it

Snuffel — Tue, 01 May 2007 12:35:46 +0000

By default, when creating a table with the wizard and indicating that selection is possible, JDeveloper creates an option in your table that always selects the first row when entering the page. This is the following line:

selectionState=”….”

If you delete this option, no rows are selected when you first load the page.