Difference: APPX500ToOracleOnAIX (10 vs. 11)

Revision 112010-07-09 - JoeOrtagus

Line: 1 to 1

APPX 5 connectivity to Oracle on AIX

How to configure APPX 5 to store data inside Oracle on IBM AIX.

Line: 84 to 84

Environment variables

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

Changed:

<
<

[appx@appx502 services]$ pwd
/usr/local/appx/services
[appx@ocportal services]$
[appx@ocportal services]$ cat appx-8060.env

>
>

pwd
/usr/local/appx/appx.502/services
#
cat appxd-8060.env

# Appx connection manager environment variables # # The entries in this file will become

Line: 100 to 100

# # letter case IS important in this file # --------------------------------------------------

Added:

>
>

APPX_KEYMAP=WINDOWS APPXPATH=/usr/local/appx/appx.502/data # APPX_DBG_CODE = 0xFFFFFFFF APPX_OCI_DIR = /opt/instantclient_10_2 # APPX_OCI_LIB = /opt/instantclient_10_2/libclntsh.so # APPX_SQL_CMD = /usr/local/appx/appx.502/appx_sql_cmd.txt # LDR_PRELOAD = libclntsh.so LIBPATH = /opt/instantclient_10_2 #

Changed:

<
<

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.

>
>

The two environment varialbes needed for for the Oracle connection on AIX are LIBPATH and APPX_OCI_DIR.

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: 210 to 209

-- JoeOrtagus - 2010-07-07

META FILEATTACHMENT	attachment="001.png" attr="h" comment="" date="1278622712" name="001.png" path="001.png" size="244896" stream="001.png" tmpFilename="/tmp/SNMMsHWjlv" user="JoeOrtagus" version="1"

Changed:

<
<

META FILEATTACHMENT	attachment="002.png" attr="h" comment="" date="1278622718" name="002.png" path="002.png" size="33230" stream="002.png" tmpFilename="/tmp/pvNk0p4Sm6" user="JoeOrtagus" version="1"

>
>

META FILEATTACHMENT	attachment="002.png" attr="h" comment="" date="1278681769" name="002.png" path="002.png" size="32481" stream="002.png" tmpFilename="/tmp/5b8auehun9" user="JoeOrtagus" version="2"

META FILEATTACHMENT	attachment="003.png" attr="h" comment="" date="1278622728" name="003.png" path="003.png" size="40004" stream="003.png" tmpFilename="/tmp/HIk2PvPAb5" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="004.png" attr="h" comment="" date="1278622735" name="004.png" path="004.png" size="34259" stream="004.png" tmpFilename="/tmp/U4NPOw5n9D" user="JoeOrtagus" version="1"
META FILEATTACHMENT	attachment="005.png" attr="h" comment="" date="1278622743" name="005.png" path="005.png" size="35355" stream="005.png" tmpFilename="/tmp/GDIEYnjU3o" user="JoeOrtagus" version="1"

View topic | History: r22 < r21 < r20 < r19 | More topic actions...