Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on AIXHow to configure APPX 5 to store data inside Oracle on IBM AIX. | ||||||||
Line: 14 to 14 | ||||||||
Oracle Instant ClientDownloading | ||||||||
Changed: | ||||||||
< < | APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on AIX 5.3. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine for Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I unzipped the Oracle Instant client files as shown below: | |||||||
> > | APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on AIX 5.3. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine for Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. | |||||||
Installing | ||||||||
Changed: | ||||||||
< < | [root@appx502 10.2.0.4-32bit]# fill in here | |||||||
> > |
I unzipped the Oracle Instant client files as shown below:
# find /opt/instantclient_10_2/ -print /opt/instantclient_10_2/ /opt/instantclient_10_2/BASIC_README /opt/instantclient_10_2/classes12.jar /opt/instantclient_10_2/genezi /opt/instantclient_10_2/libclntsh.a /opt/instantclient_10_2/libclntsh.so /opt/instantclient_10_2/libnnz10.so /opt/instantclient_10_2/libocci.a /opt/instantclient_10_2/libociei.so /opt/instantclient_10_2/libocijdbc10.so /opt/instantclient_10_2/ojdbc14.jar /opt/instantclient_10_2/SQLPLUS_README /opt/instantclient_10_2/glogin.sql /opt/instantclient_10_2/libsqlplus.so /opt/instantclient_10_2/libsqlplusic.so /opt/instantclient_10_2/sqlplus | |||||||
TestingThe location isn't terribly important, only that you know where the library files libclntsh, libnnz10, libocci, libociei and the executable file sqlplus are located. Let's test the Oracle Instant Client with SQL*Plus. You can't test the Oracle Instant Client with just any SQL*Plus. You must use a version of SQL*Plus that was developed to use the Instant Client library files. To perform the SQL*Plus connection we need five pieces of information from your Oracle DBA. My example values are listen in parenthesis below: |