Difference: APPX500ToOracleOnLinux (42 vs. 43)

Revision 432023-02-06 - JohnSelvage

Line: 1 to 1

META TOPICPARENT	name="APPX500ToOracle"

APPX 5 on Linux connectivity to Oracle

Line: 119 to 119

APPX_OCI_LIB=libclntsh.so.10.1 [appx@appx502 services]$

Changed:

<
<

The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

>
>

The two environment variables needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

FMS settings

We need to create an FMS group of type 5 (Oracle) that will point to the Oracle server. To do this we will need the same five pieces of Oracle configuration data that we used when we performed a test connection to Oracle using the Instant Client version of SQL*Plus. The values that I'm using in this example are listed below in parenthesis.

Line: 217 to 217

Troubleshooting APPX to Oracle connection

Changed:

<
<

If you try to make a connection to Oracle from APPX and receive a message "*Can't load Oracle Call Interface (libclntsh)" then you might be missing the environment variables required, or you might have them set to incorrect paths. Make sure you downloaded the correct Oracle Instant Client files for your platform and that it maches the bitness of your APPX engine.

>
>

Verify environment variable values via the following path: System Administration > System Setup > Release Information > Environment Variables. Did you set the environment variables inside appx.env? Setting these Oracle connectivity environment variables inside appx.env will not work. These environment variables must be present prior to the appx session starting. Try setting them in the appxLoginMgr environment variable file and then make sure you restart the daemon and reconnect to try the Oracle connection again.

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