Difference: APPX500ToOracleOnWindows (40 vs. 41)

Revision 412016-04-07 - JeanNeron

 			 META TOPICPARENT 
			 name="APPX500ToOracle"
- META TOPICPARENT
+ name="APPX500ToOracle"
-<
<
+ APPX 5 connectivity to Oracle on Linux
->
>
+ APPX 5 connectivity to Oracle on Window
-<
<
+How to configure APPX 5 to store data inside Oracle on Linux.
->
>
+How to configure APPX 5 to store data inside Oracle on Windows.
   APPX 5 on Windows connectivity to Oracle 
  Overview
   Prerequisites
   Oracle Instant Client 
  Downloading
   Installing
   Testing
 
   APPX 
  Configuration 
  FMS settings 
  FMS Group Creation
   Define Data file to point to Oracle
 
 
 
   Troubleshooting APPX to Oracle connection
 
 



 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 where 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. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Oracle Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
->
>
+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 where 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 Windows platform. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, and Oracle Solaris SPARC.
  Prerequisites 

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.
  Oracle Instant Client 
 Downloading
-<
<
+If you are running APPX 5.4.3 or earlier, you will need the 32 bit Oracle interface. 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. If you are running APPX 6.0 or greater, you need to know if you are running 32 or 64 bit APPX engine and download the appropriate Instant Client.
->
>
+If you are running an APPX release prior to 6.0, you will need the 32 bit Oracle interface. 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. If you are running APPX 6.0 or greater, you need to know if you are running 32 or 64 bit APPX engine and download the appropriate Instant Client.
 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:
 Installing

View topic | History: r43 < r42 < r41 < r40 | More topic actions...