Friday, August 15, 2008

How to get Discoverer4i working on Oracle Linux5

This morning I tested the sollution on another EBS 11.5.1.0.2 environment running on Oracle Linux 5. I also upgraded the database for this environment from 9i to 10.2.0.4, so it's also a test for Discoverer4i on 10gr2.
I tried starting the disco processes using the default start script addisctl.sh from Oracle in the $COMMON_TOP/admin/script/ORACLE_SID. When the script tried to start the locator, I received the same error again...

oebs/oracle/ora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM

Setting the LD_ASSUME_KERNEL didn't help. After setting this parameter on Linux 5, nothing else is working anymore. I solved this issue by performing the following steps :

1. adjust the discwb.sh in the $ORACLE_806_HOME/discwb4 directory.
In this file, change the VBROKER_JAVAVM parameter, it was pointing to the jre in the 8.0.6 home, to ...

VBROKER_JAVAVM="/usr/java/jdk1.5.0_06/jre/bin/java - Dorg.omg.CORBA.ORBClass=com.visigenic.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.visigenic.vbroker.orb.ORB"

After setting this parameter to it's new value, also edit the start,stop and status scripts.
Edit the start/stop script in the $8.0.6_HOME/discwb4/util directory and also the addisctl.sh script in the $COMMON_TOP/admin/scripts
In these script change the check for 'jre' to 'java' ...

for example in the startlocator.sh (8.0.6_home/discwb4/util) change
findprocess "JRE" ${lpid:-0} into findprocess "java" ${lpid:-0}

After these changes, the discoverer4i is working on Oracle Linux 5 and with a 10.2.0.4 database !!

2 comments:

Alexander Wilson said...

Good post, this had me stumped for quite some time. However, although I now have all Discoverer processes running as normal, I am faced with another issue. Can you help?

When opening Discoverer Plus via URL: host:port/discwb4/html/english/welcome.htm, I am faced with the 'Click to Start' icon. When I click this, it says 'Initializing' and does not go any further. After checking the Apache error logs, I can see the following error:

File does not exist: /iAS/Apache/Apache/htdocs/discwb4/applet/start//

Any ideas?

Bas Klaassen said...

I have no idea. Did it used to work ? Kind of strange it's missing a file, are you sure that the missing file is causing your problem ?