Difference: APPX500ToOracleOnAIX (9 vs. 10)

Revision 102010-07-09 - JoeOrtagus

  APPX 5 connectivity to Oracle on AIX 

How to configure APPX 5 to store data inside Oracle on IBM AIX.
 Notice the failure to find libsqlplus.so in the text above. You can resolve this on AIX with an OS environment variable LIBPATH. An example is below.
-<
<
+ Success with LD_LIBRARY_PATH 
[root@appx502 ~]# export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib
[root@appx502 ~]#
[root@appx502 ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/customer
->
>
+ Success with LIBPATH 
#
# export LIBPATH=/opt/instantclient_10_2
#
# /opt/instantclient_10_2/sqlplus larry/yacht@10.50.0.6:1521/customer
-<
<
+SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 8 13:06:38 2010
->
>
+SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 8 11:07:25 2010
 Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
 SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
-<
<
+[root@appx502 ~]#
->
>
+#
  APPX
-<
<
+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.
->
>
+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, APPX 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 APPX sessions started in that shell session. 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 

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).
->
>
+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).
 [appx@appx502 services]$ pwd
/usr/local/appx/services
[appx@ocportal services]$

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