10g Application Server Installation and Errors

Had to setup 10g Application Server on Oracle Enterprise Linux 5 and came across few errors.


1. Infra-tire Installation failed to startup the service.
Error:
httpd: error while loading shared libraries: libdb.so.2

Solution: 
create a symbolic link "ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2" 


2. Mid-tire Installation failed

Error:
/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4'
/usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4'
/usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4'
collect2: ld returned 1 exit status
make: *** [rwproxy] Error 1

Solution:
A) The following i386 packages are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux for both OEL 5 and RHEL 5) and installed manually:

* openmotif21-2.1.30-11.EL5.i3861
* xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
* binutils-2.17.50.0.6-6.0.1.i3862

B) Link to Motif library for Oracle Application Server 10.1.2 (on OEL 5 and RHEL 5 only)

Perform the following command (as root on your system) to update a required link to a Motif library prior to relinking or patching the 10.1.2 Application Server Oracle Home:

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6


3. MiddleTire Installation failed to start the Discoverer Service


Errors:
dis51pr: error while loading shared libraries: libpthread.so.0


Solution:
Remove LD_ASSUME_KERNEL parameter from the opmn.xml (in the Discoverer section) file then reloaded it with "opmnctl reload"

ompnctl startproc ias-component=Discoverer

Limitation in DECODE Function

If you happen to receive "ORA-00939: too many arguments for function" in a complex query then you may need to first look into the DECODE statement. There seems to be some limitation with the decode function that it can hold a maximum number of 255 components. It includes the expression , search and the results arguments.

Interestingly in Discoverer Environment the complex folders which holds the decode function disappears when it exceeds this limit. Creating a large decode will also generate the same error in the Desktop Edition; however, the complex folder will not disappear in this case.