Difference: APPX500ToOracleOnWindows (19 vs. 20)

Revision 202010-07-08 - JoeOrtagus

Line: 1 to 1

APPX 5 connectivity to Oracle on Linux

How to configure APPX 5 to store data inside Oracle on Linux.

Line: 75 to 75

We can configure APPX now that we know that we can connect to Oracle using the Instant Client library files via the special Instant Client version of SQL*Plus (you did perform that test right?). In order for APPX to successfully connect to Oracle via the Oracle Instant Client, it must have visibility of certain environment variables prior to the start of APPX. Setting these environment variables in the commonly used appx.env file will not work. Setting them in the shell would work for command line APPX sessions. You should consider setting them inside the service environment variable file so that all connections to APPX via TCP (even the text based ones via appx -c) will be able to connect to Oracle via the Oracle Instant Client.

Configuration

Changed:

<
<

Since these environment variables needed to enable APPX to make use of the Oracle Instant Cleint need to be present prior to the start of APPX, I've decided to place them in the APPX Login Manager environment variable file.

>
>

Since the environment variables needed to enable APPX make use of the Oracle Instant Client must be present prior to the start of APPX, I've decided to place them in the APPX Login Manager environment variable file.

Environment variables

I'm going to set two environment variables, the first is for the OS (LD_LIBRARY_PATH) and the second is for APPX (APPX_OCI_LIB). These will be placed inside my APPX Login Manager environment variable file /usr/local/appx/services/appx-8060.env).

Added:

>
>

[appx@appx502 services]$ pwd
/usr/local/appx/services
[appx@ocportal services]$
[appx@ocportal services]$ cat appx-8060.env
# Appx connection manager environment variables
#
#   The entries in this file will become
#   environment variables in the engines
#   spawned by this service
#
#   blank lines are ignored
#
#   anything following a '#' is treated as a comment
#
#   letter case IS important in this file
# --------------------------------------------------

APPX_KEYMAP = Windows
APPXPATH = /usr/local/appx/data
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib/
# APPX_SQL_CMD=/usr/local/appx/appx_sql_cmd.txt
# APPX_DBG_CODE=0xFFFFFFF
# APPX_OCI_DIR=/usr/lib/oracle/10.2.0.4/client/lib/
APPX_OCI_LIB=libclntsh.so.10.1
[appx@appx502 services]$

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

FMS settings

-- JoeOrtagus - 2010-07-07

Added:

>
>

META FILEATTACHMENT	attachment="001.png" attr="h" comment="" date="1278616793" name="001.png" path="001.png" size="244896" stream="001.png" tmpFilename="/tmp/qjbJiTHok6" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="002.png" attr="h" comment="" date="1278616806" name="002.png" path="002.png" size="33230" stream="002.png" tmpFilename="/tmp/K2AJJlg0UR" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="003.png" attr="h" comment="" date="1278616827" name="003.png" path="003.png" size="40004" stream="003.png" tmpFilename="/tmp/cAPGeQjWtG" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="004.png" attr="h" comment="" date="1278616834" name="004.png" path="004.png" size="34259" stream="004.png" tmpFilename="/tmp/lagQNPKRs1" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="005.png" attr="h" comment="" date="1278616843" name="005.png" path="005.png" size="35355" stream="005.png" tmpFilename="/tmp/fEl3OZdh1q" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="006.png" attr="h" comment="" date="1278616849" name="006.png" path="006.png" size="37871" stream="006.png" tmpFilename="/tmp/AuwOAa34Lf" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="007.png" attr="h" comment="" date="1278616858" name="007.png" path="007.png" size="240528" stream="007.png" tmpFilename="/tmp/PtWWwCkWJP" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="008.png" attr="h" comment="" date="1278616865" name="008.png" path="008.png" size="32912" stream="008.png" tmpFilename="/tmp/yz78W43Em1" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="009.png" attr="h" comment="" date="1278616870" name="009.png" path="009.png" size="35723" stream="009.png" tmpFilename="/tmp/AkkVW5jrK9" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="010.png" attr="h" comment="" date="1278616877" name="010.png" path="010.png" size="39241" stream="010.png" tmpFilename="/tmp/0LQRb5gaqQ" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="011.png" attr="h" comment="" date="1278616883" name="011.png" path="011.png" size="46314" stream="011.png" tmpFilename="/tmp/WTcWqBsdak" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="012.png" attr="h" comment="" date="1278616888" name="012.png" path="012.png" size="36004" stream="012.png" tmpFilename="/tmp/FFMd1JFBTs" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="013.png" attr="h" comment="" date="1278616894" name="013.png" path="013.png" size="32207" stream="013.png" tmpFilename="/tmp/P0hGp0qGTp" user="JoeOrtagus" version="1"

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