Configuring APPX and RDBMS

Compatibility with newer versions of popular databases is among the many features of APPX 5.0 & higher. This page gives some examples of configuring APPX to work with various RDBMS's

• Oracle 12c

Microsoft SQL Server (2000, 2005, 2008, SQL Server Express)

The setup steps for the Microsoft SQL Server family are the same as ODBC above, except you use the Windows ODBC Administrator tool to define the ODBC Data Source. The FMS group is set up the same way as above. Please note that if you are running a 64 bit OS, you need to use the 32 bit ODBC data source administrator. It can be found in C:\Windows\SysWow64\odbcad32.exe.

You can also set the following environment variables to get a full log of the SQL commands & results:

• APPX_SQL_CMD=<some path & flle name>
• APPX_DBG_CODE=0xFFFFFFFF

Comments:

Comments:

[root@tubes /]# *mkdir -p /usr/local/src/oracle/instantclient/* 
[root@tubes /]# *cd /usr/local/src/oracle/instantclient/*

[root@tubes instantclient]# *pwd*

[root@tubes instantclient]# *pwd*

[root@tubes instantclient]# *ldconfig -v|grep libclntsh*
[root@tubes instantclient]# *ldconfig -v|grep instant*

[root@tubes instantclient]# *ldconfig*
[root@tubes instantclient]# *ldconfig -v|grep libclntsh*

[joe@tubes instantclient_10_2]$ *ls -la /usr/local/instantclient_1*/libclnt**

[root@tubes appx]# *cd /usr/local/instantclient_10_2/*
[root@tubes instantclient_10_2]# *ln -s /usr/local/instantclient_10_2/libclntsh.so.10.1 /usr/local/instantclient_10_2/libclntsh.so*
[root@tubes appx]# *ls -la /usr/local/instantclient_10_2/libclntsh.so*

[root@tubes appx]# 
[root@tubes appx]# *grep APPX_OCI_LIB /usr/local/appx/data/appx.env*

[root@tubes instantclient_10_2]# */usr/local/instantclient_10_2/sqlplus scott/password@tubes:1521/appx*

[root@tubes ~]# *cd /usr/local/src*
[root@tubes src]# *mkdir mysql-connector-odbc.from.mysql.com*
[root@tubes src]# *cd mysql-connector-odbc.from.mysql.com/*
[root@tubes mysql-connector-odbc.from.mysql.com]# *wget http://mirror.trouble-free.net/mysql_mirror/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.25-0.i386.rpm*

[root@tubes mysql-connector-odbc.from.mysql.com]# *yum install mysql mysql-server unixODBC*

[root@tubes mysql-connector-odbc.from.mysql.com]# *rpm -ivh mysql-connector-odbc-3.51.25-0.i386.rpm* 

[root@tubes mysql-connector-odbc.from.mysql.com]# *yum install libtool-ltdl*

[root@tubes mysql-connector-odbc.from.mysql.com]# *rpm -ivh mysql-connector-odbc-3.51.25-0.i386.rpm* 

[root@tubes mysql-connector-odbc.from.mysql.com]# *mysql -uroot -p*

[root@tubes tools]# *odbcinst -j*

[root@tubes tools]# 
[root@tubes tools]# *cat /etc/odbc.ini*

[root@tubes tools]# *cat /etc/odbcinst.ini*

[root@tubes mysql-connector-odbc.from.mysql.com]# *isql -v mysql*

 *isql -v mysql*

[root@tubes tools]# *updatedb*
[root@tubes tools]# *locate libodbc.so*

[root@tubes tools]# *grep APPX_ODBC_LIB /usr/local/appx/data/appx.env*

1. Fixed - Bug Description 1.
2. OPEN - Bug 2209 - Lengthen field FMS Group Options - Server Name.

PostgreSQL 8.1.11

Quick installation steps for the APPX to PostgreSQL connection:

• Install PostgreSQL.
• Install UnixODBC.
• Define DSN files, odbc.ini and odbcinst.ini
• Set in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_ODBC_LIB equal to the file name of the unixodbc shared library file from the UnixODBC install. (For example APPX_ODBC_LIB=/usr/lib/libodbc.so).
• Now define APPX FMS settings.

Detailed installation example for the APPX to PostgreSQL connection:

Here are the steps I used to make connection with APPX 4.3.0 and PostgreSQL 8.1.11 with both installed on the same Red Hat Enterprise 5.1, 32 bit server. The PostgreSQL database and UnixODBC will be provided by Red Hat. UnixODBC will also be provided by Red Hat.

Install PostgreSQL, PostgreSQL-Server, PostgreSQL-libs, PostgreSQL-ODBC and UnixODBC

We need to build the odbc.ini file. The odbc.ini file can contain stanzas for different drivers. The content of each driver's stanza is driver specific (MySQL, PostgreSQL, FreeTDS, MiniSQL etc...). My /etc/odbc.ini file looks like this:

The mysql-connector-odbc that we downloaded from mysql.com did not have a Setup library included, so we skipped that property. The Setup property points to a shared lib containing functions to be called by ODBC Config. By convention it usually has a capitol S towards the end of the file name such as libmyodbc3S.so. ODBC Config would call this library to get driver specific property names during data source configuration. If ODBC Config can not find or use this file it will assume some defaults.

Troubleshoot isql problems.

isql -v mysql
[08S01][unixODBC][MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[ISQL]ERROR: Could not SQLConnect
[root@tubes mysql-connector-odbc.from.mysql.com]# updatedb
[root@tubes mysql-connector-odbc.from.mysql.com]# locate mysql.sock
/var/lib/mysql/mysql.sock
[root@tubes mysql-connector-odbc.from.mysql.com]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

[root@tubes tools]# updatedb
[root@tubes tools]# locate libodbc.so
/usr/lib/libodbc.so
/usr/lib/libodbc.so.1
/usr/lib/libodbc.so.1.0.0
[root@tubes tools]# ls -la /usr/lib/libodbc.so*
lrwxrwxrwx 1 root root     16 Jun 11 15:37 /usr/lib/libodbc.so -> libodbc.so.1.0.0
lrwxrwxrwx 1 root root     16 Jun 11 15:37 /usr/lib/libodbc.so.1 -> libodbc.so.1.0.0
-rwxr-xr-x 1 root root 447700 Jan  7  2007 /usr/lib/libodbc.so.1.0.0
[root@tubes tools]#

[root@tubes tools]# grep APPX_ODBC_LIB /usr/local/appx/data/appx.env
[root@tubes tools]# 
[root@tubes tools]# ./appxLoginMgr -install -SockPort=8071 APPX_KEYMAP=WINDOWS APPX_ODBC_LIB=/usr/lib/libodbc.so APPX_SS_LOG=/usr/local/appx/appx_ss_log.txt APPX_SS_CODE=0xFFFFFFFF APPX_SQL_CMD=/usr/local/appx/appx_sql_cmd.txt APPX_DBG_CODE=0xFFFFFFFF
Warning - the engine that you named has the setuid bit enabled,
          you may not want that bit set for the authentication
          method that you have chosen (OS-User)
 	   To turn off the setuid bit, chmod u-s ../appx
Configuration written to:  appxd-8071.ini
Environment written to:    appxd-8071.env
Service script written to: /etc/init.d/appxd-8071
Configuration complete
Registering service
Starting appxd-8071: serviceName: appxd-8071
servicePath: /usr/local/appx/tools/
Looking for config file in appxd-8071.ini
Warning - the engine that you named has the setuid bit enabled,
          you may not want that bit set for the authentication
          method that you have chosen (OS-User)
 	   To turn off the setuid bit, chmod u-s ../appx
Writing process ID to /var/run/appxd-8071.pid
running as process 2652 servicing port 8071

Warning - the engine that you named has the setuid bit enabled,
          you may not want that bit set for the authentication
          method that you have chosen (OS-User)
 	   To turn off the setuid bit, chmod u-s ../appx
up and running (process 2652 servicing port 8071)
Installation Complete

[root@tubes tools]# License server started as process 2657, logging to /usr/local/appx/tools/../data/license.log

[root@tubes tools]# 

• In APPX, Go to System Administration, then File Management, then FMS Groups.

• Create an FMS group with an appropriate name, and specify type 6 for ODBC.

• File in the ODBC DSN name for MySQL, followed by the Table Naming Scheme in the FMS Group Attributes of your new FMS group. The Table Naming Scheme could be picked from the suggestions shown when clicking on the Hints button. Also, add any three character value to the Proxy Lock field, I used LOK.

• Under Identities, define at least a default identity.

• Enter the MySQL account to use for the Default Identity, leave Realm empty.

• Enter the MySQL account's password.

Determine where UnixODBC expects odbc.ini and odbcinst.ini configuration files to be located.

[root@tubes tools]# odbcinst -j
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
[root@tubes tools]# 

APPX to Oracle quick installation steps, with the assumption that you have a working install of Oracle 10g R2:

[MySQL 5]
Comment = New MySQL Driver
Driver =  /usr/lib/libmysql.so.11
Setup = /usr/lib/libmysqlS.so.11
FileUsage = 1

The Driver file name ( ie /usr/lib/libsybase.so.11 ) should be unique. The friendly name ( ie MySQL 5 ) must also be unique.

The Setup property points to a shared lib containing functions to be called by ODBC Config. ODBC Config will call this share to get driver specific property names during data source configuration. If ODBC Config can not find/use this file it will assume some defaults such as; Data Source Name, Host, and default Database.

One should always modify this file either using the ODBCINST share library or by using the command line equivalent odbcinst.

We need to build the odbcinst.ini file. The odbc.ini file content is driver specific (MySQL, PostgreSQL, FreeTDS, MiniSQL etc...). My file looks like this:

[root@tubes tools]# cat /etc/odbcinst.ini
[PostgreSQL]
Description		= ODBC for PostgreSQL
Driver		= /usr/lib/libodbcpsql.so
Setup		= /usr/lib/libodbcpsqlS.so
FileUsage		= 1

[MySQL ODBC 3.51 Driver]
DRIVER		= /usr/lib/libmyodbc3.so
UsageCount		= 1

[mysql]
Description	= mysql odbc connection for appx
Driver		= /usr/lib/libmyodbc3.so
UsageCount	= 1
[root@tubes tools]# 

APPX to Oracle quick installation steps:

APPX to Oracle detailed installation example:

• File in the Server Name and Table Naming Scheme in the FMS Group Attributes of your new FMS group. The Server Name field has a format of ORACLE-HOST-NAME:ORACLE-PORT/ORACLE-SID. The Table Naming Scheme could be picked from the suggestions shown when clicking on the Hints button.

Quick installation steps of the APPX to MySQL connection:

• Install mysql-connector-odbc (version 3.51.22 or newer)

• Set, in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_ODBC_LIB equal to the file name of the unixodbc shared library file from the UnixODBC install. (For example APPX_ODBC_LIB=/usr/lib/libodbc.so).

Detailed installation example of the APPX to MySQL connection:

Download mysql-connector-odbc from MySQL.com website.

[root@tubes ~]# cd /usr/local/src
[root@tubes src]# mkdir mysql-connector-odbc.from.mysql.com
[root@tubes src]# cd mysql-connector-odbc.from.mysql.com/
[root@tubes mysql-connector-odbc.from.mysql.com]# wget http://mirror.trouble-free.net/mysql_mirror/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.25-0.i386.rpm

Resolving mirror.trouble-free.net... 66.45.230.130
Connecting to mirror.trouble-free.net|66.45.230.130|:80... connected.


15:35:31 (158 KB/s) - `mysql-connector-odbc-3.51.25-0.i386.rpm' saved [1862076/1862076]
 

Install MySQL, MySQL-Server, and UnixODBC

[root@tubes mysql-connector-odbc.from.mysql.com]# yum install mysql mysql-server unixODBC
Loading "installonlyn" plugin
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:5.0.22-2.2.el5_1.1 set to be updated
---> Downloading header for mysql-server to pack into transaction set.
mysql-server-5.0.22-2.2.e 100% |=========================|  33 kB    00:00     
---> Package mysql-server.i386 0:5.0.22-2.2.el5_1.1 set to be updated
---> Downloading header for unixODBC to pack into transaction set.
unixODBC-2.2.11-7.1.i386. 100% |=========================|  28 kB    00:00     
---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated
--> Running transaction check
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for perl-DBD-MySQL to pack into transaction set.
perl-DBD-MySQL-3.0007-1.f 100% |=========================| 8.3 kB    00:00     
---> Package perl-DBD-MySQL.i386 0:3.0007-1.fc6 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size 
=============================================================================
Installing:
 mysql                   i386       5.0.22-2.2.el5_1.1  updates           3.0 M
 mysql-server            i386       5.0.22-2.2.el5_1.1  updates            10 M
 unixODBC                i386       2.2.11-7.1       base              832 k
Installing for dependencies:
 perl-DBD-MySQL          i386       3.0007-1.fc6     base              147 k

Transaction Summary
=============================================================================
Install      4 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 14 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): perl-DBD-MySQL-3.0 100% |=========================| 147 kB    00:01     
(2/3): mysql-server-5.0.2 100% |=========================|  10 MB    01:20     
(3/3): unixODBC-2.2.11-7. 100% |=========================| 832 kB    00:05     
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: mysql                        ######################### [1/4] 
  Installing: perl-DBD-MySQL               ######################### [2/4] 
  Installing: mysql-server                 ######################### [3/4] 
  Installing: unixODBC                     ######################### [4/4] 

Installed: mysql.i386 0:5.0.22-2.2.el5_1.1 mysql-server.i386 0:5.0.22-2.2.el5_1.1 unixODBC.i386 0:2.2.11-7.1
Dependency Installed: perl-DBD-MySQL.i386 0:3.0007-1.fc6
Complete!
[root@tubes mysql-connector-odbc.from.mysql.com]# 

Install mysql-connector-odbc version 3.51.22 or newer.

[root@tubes mysql-connector-odbc.from.mysql.com]# rpm -ivh mysql-connector-odbc-3.51.25-0.i386.rpm 
error: Failed dependencies:
	libltdl.so.3 is needed by mysql-connector-odbc-3.51.25-0.i386

[root@tubes mysql-connector-odbc.from.mysql.com]# yum install libtool-ltdl
Loading "installonlyn" plugin
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for libtool-ltdl to pack into transaction set.
libtool-ltdl-1.5.22-6.1.i 100% |=========================|  15 kB    00:00     
---> Package libtool-ltdl.i386 0:1.5.22-6.1 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size 
=============================================================================
Installing:
 libtool-ltdl            i386       1.5.22-6.1       base               37 k

Transaction Summary
=============================================================================
Install      1 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 37 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): libtool-ltdl-1.5.2 100% |=========================|  37 kB    00:00     
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: libtool-ltdl                 ######################### [1/1] 

Installed: libtool-ltdl.i386 0:1.5.22-6.1
Complete!
[root@tubes mysql-connector-odbc.from.mysql.com]# 

[root@tubes mysql-connector-odbc.from.mysql.com]# rpm -ivh mysql-connector-odbc-3.51.25-0.i386.rpm 
Preparing...                ########################################### [100%]
   1:mysql-connector-odbc   ########################################### [100%]
[myodbc3i.c][589][INFO] Driver registered. Usage count is 1. Location "/etc" 
[root@tubes mysql-connector-odbc.from.mysql.com]# 

Create MySQL database and database user.

[root@tubes mysql-connector-odbc.from.mysql.com]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database appx;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on appx.* to appx@localhost identified by "password";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
[root@tubes mysql-connector-odbc.from.mysql.com]# 

Configure /etc/odbc.ini

[root@tubes tools]# 
[root@tubes tools]# cat /etc/odbc.ini
[mysql]
Driver		= mysql
Database	= appx
Description	= mysql odbc connection for appx
Pwd		= password
Port		= 3306
Server		= localhost
UID		= appx
[root@tubes tools]# 

Configure /etc/odbcinst.ini

Verify DSNs are working.

[root@tubes mysql-connector-odbc.from.mysql.com]# isql -v mysql
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> show databases;
+-----------------------------------------------------------------+
| Database                                                        |
+-----------------------------------------------------------------+
| information_schema                                              |
| appx                                                            |
| test                                                            |
+-----------------------------------------------------------------+
SQLRowCount returns 3
3 rows fetched
SQL> quit
[root@tubes mysql-connector-odbc.from.mysql.com]# 

Set the APPX_ODBC_LIB environment variable

Configure APPX FMS parameters.

Quick installation steps:

• Install MySQL.
• Install UnixODBC
• Define DSN files, odbc.ini and odbcinst.ini.
• Set, in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_ODBC_LIB equal to the file name of the unixodbc shared library file from the UnixODBC install. (For example APPX_ODBC_LIB=libclntsh.so.10.1).
• Define APPX FMS settings.

Detailed installation example:

Here are the steps I used to make connection with APPX 4.3.0 and Oracle 10gR2 with both installed on the same Red Hat Enterprise 5.1, 32 bit server.

Quick installation steps:

• Define APPX FMS settings.

Detailed installation example:

Create directory for Oracle Instant Client bundle to download to.

Download the Oracle Instant Client files for Linux.

APPX requires at least the Basic package, but it is recommended that you grab the SQL*Plus package too for debugging. http://www.oracle.com/technology/tech/oci/instantclient/index.html

For 10gR2

If you are running Oracle 10gR2, then use the 10gR2 Instant Client. At the time this document was created, the current version for Linux X86 is 10.2.0.4, oracle-instantclient-basic-10.2.0.4-1.i386.zip (34,687,861 bytes), and oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip (744,730 bytes). Place the downloaded files in the /usr/local/src/oracle/instantclient/ directory.

For 11g

Place the basic and sqlplus zipped files into /usr/local/src/oracle/instantclient/, and unzip them:

Place unzipped Oracle Instant Client files into permanent installation target directory.

Configure the operating system's dynamic linker run time bindings

Build cache used by the operating system's run-time linker

Identify version of libclntsh.so that is included with downloaded Oracle Instant Client bundle

To let APPX know the version of the Instant client you have installed, perform just one of the following two options:

Create libclntsh.so symbolic link and set the APPX_OCI_DIR environment variable

Set APPX_OCI_LIB

Use the Oracle Instant Client's version of SQL*Plus to verify connectify to Oracle.

Configure APPX FMS settings

MySQL 5.0.22

PostgreSQL 8.1.9

IBM DB/2

Microsoft SQL-Server

SQL Server 2000

SQL Server 2005

SQL Server 2008

SQL Server Express

Database connectivity debug tools

APPX Environment Variables

APPX_OCI_DIR

APPX_OCI_LIB

APPX_OCI_LIB

APPX_OCI_LIBS

APPX_SS_LOG

APPX_SS_CODE

APPX_SQL_CMD=/usr/local/appx/appx_sql_cmd.log

APPX_DBG_CODE=0xFFFFFFFF

Oracle

ORACLE_SID

ORACLE_HOME

TNS_ADMIN

Some OS tools to aid in debugging

strace

ldd

Bugs:

1. Fixed - Bug Description 1.
2. OPEN - Bug 2209 - Lengthen field FMS Group Options - Server Name.

• Set, in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_OCI_LIB equal to the file name of the liblcntsh.so contained in the Oracle Instant Client library files (For example APPX_OCI_LIB=libclntsh.so.10.1).

[root@tubes instantclient]# ldconfig
[root@tubes instantclient]# ldconfig -v|grep libclntsh
 libclntsh.so.10.1 -> libclntsh.so.10.1
[root@tubes instantclient]# ldconfig -v|grep instant

• I can now either create a symbolic link named libclntsh.so that points to the version I want to use and set the APPX_OCI_DIR environment variable equal to the location of the Oracle Instant Client files:

[root@tubes appx]# cd /usr/local/instantclient_10_2/
[root@tubes instantclient_10_2]# ln -s /usr/local/instantclient_10_2/libclntsh.so.10.1 /usr/local/instantclient_10_2/libclntsh.so
[root@tubes appx]# ls -la /usr/local/instantclient_10_2/libclntsh.so
lrwxrwxrwx 1 root root 47 Jun  5 15:56 libclntsh.so -> /usr/local/instantclient_10_2/libclntsh.so.10.1
[root@tubes instantclient_10_2]# 
[root@tubes appx]# grep APPX_OCI_DIR /usr/local/appx/data/appx.env

• Or I can set an APPX environment variable equal to the name of the file. First let's see if it is set in the %APPXPATH%/appx.env file:

[root@tubes appx]# 
[root@tubes appx]# grep APPX_OCI_LIB /usr/local/appx/data/appx.env
[root@tubes appx]# 
[root@tubes appx]# echo APPX_OCI_LIB=libclntsh.so.10.1 >> /usr/local/appx/data/appx.env
[root@tubes appx]# 
[root@tubes appx]# grep APPX_OCI_LIB /usr/local/appx/data/appx.env
APPX_OCI_LIB=libclntsh.so.10.1
[root@tubes appx]# 

• In APPX, Go to System Administration, then File Management, then FMS Groups.

• Create an FMS group with an appropriate name, and specify type 5.

• File in the Server Name and Table Naming Scheme in the FMS Group Attributes of your new FMS group.  The Server Name field has a format of ORACLE-HOST-NAME:ORACLE-PORT/ORACLE-SID. The Table Naming Scheme could be picked from the suggestions shown when clicking on the Hints button.

• Under Identities, define at least a default identity.

• Enter the Oracle account to use for the Default Identity, leave Realm empty.

• Enter the Oracle account's password.

Some environment variables to keep in mind.

• APPX
  • APPX_OCI_DIR
  • APPX_OCI_LIB
  • APPX_OCI_LIBS
  • APPX_SS_LOG
  • APPX_SS_CODE
  • APPX_SQL_CMD=/usr/local/appx/appx_sql_cmd.log
  • APPX_DBG_CODE=0xFFFFFFFF
• Oracle
  • ORACLE_SID
  • ORACLE_HOME
  • TNS_ADMIN

• strace
• ldd

Oracle Instant Client

Quick installation steps:

• Install Oracle Instant Client Basic.
• Make the Oracle Instant Client library files visible to the system with the ldconfig tool or it's equivalent.
• Set, in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_OCI_DIR to the directory containing the Oracle Instant Client library files.

Detailed installation example:

Here are the steps I used to make an Oracle connection with APPX 4.3.0 and Oracle 10gR2 on the same Red Hat Enterprise 5.1 32bit server.

mkdir -p /usr/local/src/oracle/instantclient/ 
cd /usr/local/src/oracle/instantclient/ 

For 10gR2, oracle-instantclient-basic-10.2.0.4-1.i386.zip (34,687,861 bytes), and oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip (744,730 bytes)

For 11g, basic.zip (42,285,643 bytes), and sqlplus.zip (784,417 bytes)

Place the basic and sqlplus zipped files into /usr/local/src/oracle/instantclient/, and unzip them:

[root@tubes instantclient]# pwd
/usr/local/src/oracle/instantclient/
[root@tubes instantclient]# ls -la
total 34656
drwxr-xr-x 2 root root     4096 Jun  4 08:41 .
drwxr-xr-x 7 root root     4096 Jun  3 16:03 ..
-rw-r--r-- 1 root root 34687861 Jun  3 16:03 oracle-instantclient-basic-10.2.0.4-1.i386.zip
-rw-r--r-- 1 root root   744730 Jun  4 08:41 oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
[root@tubes instantclient]# 
[root@tubes instantclient]# unzip oracle-instantclient-basic-10.2.0.4-1.i386.zip 
Archive:  oracle-instantclient-basic-10.2.0.4-1.i386.zip
  inflating: instantclient_10_2/BASIC_README  
  inflating: instantclient_10_2/classes12.jar  
  inflating: instantclient_10_2/genezi  
  inflating: instantclient_10_2/libclntsh.so.10.1  
  inflating: instantclient_10_2/libnnz10.so  
  inflating: instantclient_10_2/libocci.so.10.1  
  inflating: instantclient_10_2/libociei.so  
  inflating: instantclient_10_2/libocijdbc10.so  
  inflating: instantclient_10_2/ojdbc14.jar  
[root@tubes instantclient]# unzip oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip 
Archive:  oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
  inflating: instantclient_10_2/SQLPLUS_README  
  inflating: instantclient_10_2/glogin.sql  
  inflating: instantclient_10_2/libsqlplus.so  
  inflating: instantclient_10_2/libsqlplusic.so  
  inflating: instantclient_10_2/sqlplus  
[root@tubes instantclient]# ls /usr/local
appx  bin  etc  games  include  lib  libexec  sbin  share  src

[root@tubes instantclient]# mv instantclient_10_2/ /usr/local/
[root@tubes instantclient]# ls /usr/local
appx   bin  etc  games  include  instantclient_10_2  lib  libexec  sbin  share  src
[root@tubes instantclient]# 
[root@tubes local]# cd /usr/local/instantclient_10_2/

[root@tubes instantclient_10_2]# cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
[root@tubes instantclient_10_2]# echo /usr/local/instantclient_10_2/ >> /etc/ld.so.conf
[root@tubes instantclient_10_2]# cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/local/instantclient_10_2/
[root@tubes instantclient_10_2]# ldconfig
[root@tubes instantclient_10_2]# ldconfig -v|grep instant
/usr/local/instantclient_10_2:
[root@tubes instantclient_10_2]# ldconfig -v|grep libclnt
	libclntsh.so.10.1 -> libclntsh.so.10.1
[root@tubes instantclient_10_2]# 

[root@tubes instantclient_10_2]# echo APPX_OCI_DIR=/usr/local/instantclient_10_2/ >> /usr/local/appx/data/appx.env
[root@tubes instantclient_10_2]# tail /usr/local/appx/data/appx.env
#
#  Setting APPX_UNIXIO_PROCS will cause Appx to include the current process name
#  in the logfile.
#
#APPX_UNIXIO_STATS=/tmp/file_stats
#APPX_UNIXIO_PROCS=1
#APPX_MONITOR_KEY=12345
#APPX_MONITOR_SLOTS=100

APPX_OCI_DIR=/usr/local/instantclient_10_2/
[root@tubes instantclient_10_2]# 

[root@tubes instantclient_10_2]# /usr/local/instantclient_10_2/sqlplus scott/password@tubes:1521/appx

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 4 09:17:55 2008

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show all
appinfo is OFF and set to "SQL*Plus"
arraysize 15
autocommit OFF
autoprint OFF
autorecovery OFF
autotrace OFF
blockterminator "." (hex 2e)
btitle OFF and is the first few characters of the next SELECT statement
cmdsep OFF
colsep " "
compatibility version NATIVE
concat "." (hex 2e)
copycommit 0
COPYTYPECHECK is ON
define "&" (hex 26)
describe DEPTH 1 LINENUM OFF INDENT ON
echo OFF
editfile "afiedt.buf"
embedded OFF
escape OFF
escchar OFF
FEEDBACK ON for 6 or more rows
flagger OFF
flush ON
heading ON
headsep "|" (hex 7c)
instance "local"
linesize 80
lno 14
loboffset 1
logsource ""
long 80
longchunksize 80
markup HTML OFF HEAD "" BODY "" TABLE "border='1' width='90%' align='center' summary='Script output'" SPOOL OFF ENTMAP ON PREFORMAT OFF
newpage 1
null ""
numformat ""
numwidth 10
pagesize 14
PAUSE is OFF
pno 0
recsep WRAP
recsepchar " " (hex 20)
release 1002000100
repfooter OFF and is NULL
repheader OFF and is NULL
serveroutput OFF
shiftinout INVISIBLE
showmode OFF
spool OFF
sqlblanklines OFF
sqlcase MIXED
sqlcode 0
sqlcontinue "> "
sqlnumber ON
sqlpluscompatibility 10.2.0
sqlprefix "#" (hex 23)
sqlprompt "SQL> "
sqlterminator ";" (hex 3b)
suffix "sql"
tab ON
termout ON
timing OFF
trimout ON
trimspool OFF
ttitle OFF and is the first few characters of the next SELECT statement
underline "-" (hex 2d)
USER is "SCOTT"
verify ON
wrap : lines will be wrapped
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[root@tubes instantclient_10_2]# 

• Oracle 10g R2 (10.2.0.1)
• Oracle 11g

• IBM DB/2
• Microsoft SQL-Server (2000, 2005, 2008, Express)

• PostgreSQL 8.1.9
• DB/2
• SQL-Server
  

• Oracle 10g R2 (10.2.0.1)
  

• MySQL 5.0.22
• PostgreSQL 8.1.9
  

SQL-Server

Database Interface Upgrades

Oracle

ODBC

Comments:

<--/commentPlugin-->

-- AlKalter - 04 Apr 2008