APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX System Administration :
Oracle Instant Client and Appx
Try and start appx in character mode. Run the character mode client because the error will not be displayed if you are running the Appx Desktop Client (java client).
The appx.oracle engine might give you an error such as:
====================================
# /vg01/appx.426/appx.oracle
/usr/lib/dld.sl: Can't open shared library:
/vg01/oracle/oracle-9/OraHome1/lib32/libclntsh.sl.9.0
/usr/lib/dld.sl: No such file or directory Abort #
====================================

You could also run the command (if you have it on the system of course) ldd:

====================================
# ldd /vg01/appx.426/appx.oracle

         =>
/usr/lib/libc.2 => /usr/lib/libc.2
/usr/lib/libdld.2 => /usr/lib/libdld.2
/usr/lib/libc.2 => /usr/lib/libc.2
/usr/lib/libm.2 => /usr/lib/libm.2
/usr/lib/libnss_dns.1 => /usr/lib/libnss_dns.1
/usr/lib/libdld.2 => /usr/lib/libdld.2
/usr/lib/libc.2 => /usr/lib/libc.2
/usr/lib/libpthread.1 => /usr/lib/libpthread.1
/usr/lib/librt.2 => /usr/lib/librt.2
/usr/lib/libcl.2 => /usr/lib/libcl.2
/usr/lib/libisamstub.1 => /usr/lib/libisamstub.1
/usr/lib/libdld.2 => /usr/lib/libdld.2
/usr/lib/dld.sl: Can't open shared library:
/vg01/oracle/oracle-9/OraHome1/lib32/libclntsh.sl.9.0
/usr/lib/dld.sl: No such file or directory


====================================

An alternative to ldd is strace and truss, here is the syntax I've used. However, none of these tools (ldd, strace, truss) should be needed, just attempting to start APPX in character mode should expose the missing oracle library and library path.

====================================
# strace -o/tmp/appx.oracle.out /usr/local/appx.oracle


or


# truss -o/tmp/appx.oracle.out /usr/local/appx.oracle


Grepping that file might give you something like:

# grep libclntsh /tmp/appx.oraacle.out


open("/lib/tls/libclntsh.so.9.0", O_RDONLY) = -1 ENOENT (No such file or
directory)
====================================


Do a file system search on the oracle file libclntsh.sl.9.0


====================================
# find / -name libclntsh.sl.9.0 -print
====================================

You should get something back such as:


====================================
/usr/lib/libclntsh.sl.9.0
====================================


You can then create the directory structure that APPX is wanting and
create a link from the real libclntsh.sl.9.0 file into the newly created
directory like so:


====================================
mkdir -p /vg01/oracle/oracle-9/OraHome1/lib32/
cd /vg01/oracle/oracle-9/OraHome1/lib32/
ln -s /usr/lib/libclntsh.sl.9.0 libclntsh.sl.9.0
====================================

Then you should be able to start appx. If APPX complains about another
library that is missing, then you would repeat the process described above.


Ohters have also used the same idea to mix and APPX built against Oracle
version x when you have Oracle version y installed.


For instance, say you have oracle 10 installed, but your APPX install is
looking for Oracle 9 libraries and giving you and error such as:


====================================
Can't open shared library:
/vg01/oracle/oracle-9/OraHome1/lib32/libclntsh.sl.9.0
====================================

If you don't have the Oracle 9 Client library installed, you won't find
it on the file system, what you could do is find the corresponding
version 10 file and create a link to it. For instance you might have:


====================================
/usr/lib/libclntsh.sl.10.0
====================================

In that case you would create a directory and create a link with the
version 9 name:


====================================
mkdir -p /vg01/oracle/oracle-9/OraHome1/lib32/
cd /vg01/oracle/oracle-9/OraHome1/lib32/
ln -s /usr/lib/libclntsh.sl.10.0 libclntsh.sl.9.0
====================================

That way APPX built against Oracle 9, would see the Oracle 10 client
library, and think it was Oracle Client 9.


[Append to This Answer]
2005-Dec-06 1:32pm
Previous: (Answer) Why is my sqlcmd log is truncated? In prior versions, I've seen logs with create table lines in excess of 3000 char?
Next: (Answer) Is Appx a multi-threaded Application? WIll it take advantage of multiple CPUs?
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=613
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.