Difference: APPX500ToOracleOnWindows (14 vs. 15)

Revision 152010-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: 36 to 36
  The location isn't terribly important, only that you know where the library files libclntsh, libnnz10, libocci, libociei and the executable file sqlplus are located. Let's test the Oracle Instant Client with SQL*Plus. You can't test the Oracle Instant Client with just any SQL*Plus. You must use a version of SQL*Plus that was developed to use the Instant Client library files. To perform the SQL*Plus connection we need five pieces of information from your Oracle DBA. My example values are listen in parenthesis below:
Changed:
<
<
  • Oracle SID (oracle10)
>
>
  • Oracle SID (customer)
 
  • TCP port number that Oracle is configured to listen (TCP 1521)
  • Resolvable DNS name or IP address of the Oracle server (10.50.0.6)
  • Oracle user ID (larry)
Line: 44 to 44
  I'll use the Oracle Easy Connect syntax to log in.

Failure without LD_LIBRARY_PATH

Changed:
<
<
[root@ocportal ~]#
[root@ocportal ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus scott/password@192.168.1.213:1521/oracle10
>
>
[root@appx502 ~]#
[root@appx502 ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/customer
 /usr/lib/oracle/10.2.0.4/client/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Changed:
<
<		[root@ocportal ~]#
>
>		[root@appx502 ~]#
 

Notice the failure to find libsqlplus.so in the text above. You can resolve this on Linux with LD_LIBRARY_PATH. 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 ~]#
Changed:
<
<		[root@appx502 ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10
>
>		[root@appx502 ~]# /usr/lib/oracle/10.2.0.4/client/bin/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
View topic | History: r43 < r42 < r41 < r40 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback