Tags:
view all tags
---+ APPX 5 connectivity to Oracle on Linux _How to configure APPX 5 to store data inside Oracle on Linux._ <em>%TOC%<br /></em> ---++ Overview Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. ---++ Downloading the Oracle Instant Client 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 <a href="http://www.oracle.com/technology/software/tech/oci/instantclient/index.html" title="Download 32 bit Oracle Instant Client">here</a>. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to 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 chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below: <verbatim style="padding-left: 30px;">[root@appx502 10.2.0.4-32bit]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm Preparing... ########################################### [100%] 1:oracle-instantclient-ba########################################### [ 50%] 2:oracle-instantclient-sq########################################### [100%] [root@appx502 10.2.0.4-32bit]# [root@appx502 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm /usr/lib/oracle/10.2.0.4/client/bin/genezi /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so /usr/lib/oracle/10.2.0.4/client/lib/libocci.so.10.1 /usr/lib/oracle/10.2.0.4/client/lib/libociei.so /usr/lib/oracle/10.2.0.4/client/lib/libocijdbc10.so /usr/lib/oracle/10.2.0.4/client/lib/ojdbc14.jar /usr/bin/sqlplus /usr/lib/oracle/10.2.0.4/client/bin/sqlplus /usr/lib/oracle/10.2.0.4/client/lib/glogin.sql /usr/lib/oracle/10.2.0.4/client/lib/libsqlplus.so /usr/lib/oracle/10.2.0.4/client/lib/libsqlplusic.so [root@appx502 10.2.0.4-32bit]#</verbatim> The location isn't terribly important, only that you know where the library files libclntsh, libnnz10, libocci, libociei and the executable file sqlplus are located. -- Main.JoeOrtagus - 2010-07-07
Edit
|
Attach
|
Watch
|
P
rint version
|
H
istory
:
r43
|
r10
<
r9
<
r8
<
r7
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
Topic revision: r8 - 2010-07-08
-
JoeOrtagus
Home
Site map
Main web
MedicaidBilling web
Sandbox web
TWiki web
Main Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
View
Raw View
Print version
Find backlinks
History
More topic actions
Edit
Raw edit
Attach file or image
Edit topic preference settings
Set new parent
More topic actions
Account
Log In
Edit
Attach
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback