Monday, August 18, 2008

Meet the experts on the OCP blog !

Mohan Dutt, a.k.a. OCP Advisor, is presenting a new weekly feature on his OCP blog (http://ebizocp.blogspot.com). It is called 'Meet the Experts' and its' a Q/A with certain Oracle Certified professionals. I am proud to say that I was also asked to be part of this new feature. So, I delivered my certification experience and it will soon be on the OCP blog. So keep checking the OCP blog for the Q/A sessions !!

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 !!

Thursday, August 14, 2008

Issue solved....

I solved the issue with Discoverer on Linux 5.
I will post the workaround tomorrow, because I have to test it on another enviroment also. To get Discoverer working I had to edit some config files, change it back later on. Patch the disco libraries, undo the patch and so on. To get a good image of the sollution I want to test it on another Linux 5 EBS environment.
The service request is still open, no answer from Oracle yet. Maybe because Disco 4 is desupported....

Wednesday, August 13, 2008

Discoverer on Oracle Linux 5

After I had the EBS 11.5.10.2 running on Oracle Linux 5, I noticed another problem.
When trying to start the disco proces using addisctl.sh in the $COMMON_TOP/admin/scripts directory I noticed the following error :

/oebs/pubtar21/pubtar21ora/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/ThreadCould not create Java VM

In my last post about Oracle Linux 5, I mentioned that the LD_ASSUME_KERNEL must be unset. In earlier versions this parameter had to be set if you wanted to install or work with EBS 11i. I searched Metalink for a sollution for my Disco problem. The answer was found on Metalink....
Before starting the Disco processes, set the LD_ASSUME_KERNEL parameter !!!!
But when the parameter is set, nothing else is working anymore. So, here is another problem with Linux 5. I already logged an service request. To be continued.

Thursday, August 07, 2008

Cloning 11i EBS on Oracle Linux 5

We have upgrade our Linux OS to Oracle Linux 5. We have 11i running on release 5, and today I tried to clone an EBS environment. At the beginning of the db_Tier the clone script runsinto an error.

Enter the APPS password [APPS]:
apps
Checking for make... found - /usr/bin/make
Checking for ld... found - /usr/bin/ld
Checking for cc... found - /usr/bin/cc
Checking for ar... found - /usr/bin/ar
Checking for ksh...
Unable to find 'kshell' in path Unable to locate all utilities with system path.

Strange error, because ksh is located in de /usr/bin and this is in the $PATH

Oracle appl: /oebs/oracle/home/oracle> which ksh
/usr/bin/ksh

I searched Metalink and Google, and found thsi problem also occurs when installing 11.5.10 on Oracle Linux 5.
I checked the adchkutl.sh script and found the problem :

## Verify for ksh if its a linux only platform#
if test $UNAME = "Linux"; then

printf "Checking for ksh...\t";
VERSN=`/bin/ksh -c 'echo $KSH_VERSION' grep "PD KSH";`;
EC=$?
if test $EC != "0" ; then
printf "\nUnable to find 'kshell' in path\n";
SHOW_PATH=1
else
printf "found - $VERSN\n";
fi
fi

It's checking for ' PD KSH' and that's not installed when installing Oracle Linux 5 !!!!!!
So, it looks like an error in the script. I searched Metalink again, but could not find anything in the documents (316806.1)
I removed the ksh check from the script to see if it would run this time.
And it did......
Another problem is the adgetlnxver.sh script. This sh script is called by the .env file in your ORACLE_HOME and it produces library errors. A patch has to be installed, patch 6365595 from Metalink solves this issue. The patch replaces the shell script in the $AD_TOP/bin directory. But not in your 9.2.0 ORACLE_HOME ???? You have to copy the adgetlnxver.sh manually to your $ORACLE_HOME/appsutil/bin (9.2.0) directory...


The same error also occurs when running the app_Tier clone. So dont forget to edit the same script in the $COMMON_TOP/clone/bin