Difference: DatabaseInterfaceUpgrades (8 vs. 9)

Revision 92008-06-06 - JoeOrtagus

Line: 1 to 1
 
META TOPICPARENT name="APPX43Features"

Database Interface Upgrades

Compatibility with newer versions of popular databases is among the many features of APPX 4.3.
Line: 8 to 8
 
  • Oracle 11g
The Oracle connectivity is provided by the Oracle Instant Client.
Changed:
<
<		Quick installation steps:
>
>

Quick installation steps:

 
  • Install Oracle Instant Client Basic.
  • Make the Oracle Instant Client library files visible to the system with the ldconfig tool or it's equivalent.
  • Set, in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_OCI_LIB equal to the file name of the liblcntsh.so contained in the Oracle Instant Client library files (For example APPX_OCI_LIB=libclntsh.so.10.1).
Added:
>
>
  • Define APPX FMS settings.
 
Changed:
<
<		Detailed installation example:
>
>

Detailed installation example:

  Here are the steps I used to make connection with APPX 4.3.0 and Oracle 10gR2 with both installed on the same Red Hat Enterprise 5.1, 32 bit server.
Added:
>
>

Create directory for Oracle Instant Client bundle to download to.

 I'm going to create a directory to place the zipped bundled Oracle Instant Client files. For my example, I'm going to use /usr/local/src/oracle/instantclient/. 
[root@tubes /]# mkdir -p /usr/local/src/oracle/instantclient/ 
[root@tubes /]# cd /usr/local/src/oracle/instantclient/
[root@tubes instantclient]#
Changed:
<
<		Download the Oracle Instant Client files for Linux. APPX requires at least the Basic package, but it is recommended that you grab the SQL*Plus package too for debugging.
>
>

Download the Oracle Instant Client files for Linux.

APPX requires at least the Basic package, but it is recommended that you grab the SQL*Plus package too for debugging. http://www.oracle.com/technology/tech/oci/instantclient/index.html

For 10gR2

If you are running Oracle 10gR2, then use the 10gR2 Instant Client. At the time this document was created, the current version for Linux X86 is 10.2.0.4, oracle-instantclient-basic-10.2.0.4-1.i386.zip (34,687,861 bytes), and oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip (744,730 bytes). Place the downloaded files in the /usr/local/src/oracle/instantclient/ directory.

 
Changed:
<
<		For 10gR2, the current versions are, oracle-instantclient-basic-10.2.0.4-1.i386.zip (34,687,861 bytes), and oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip (744,730 bytes)
>
>
For 11g
 
Changed:
<
<		For 11g, the current versions are, basic.zip (42,285,643 bytes), and sqlplus.zip (784,417 bytes)
>
>		If you are running Oracle 11g, then use the 11g Instant Client. At the time this document was created, the current version is 11.1.0.6.0 , basic.zip (42,285,643 bytes), and sqlplus.zip (784,417 bytes). Place the downloaded files in the /usr/local/src/oracle/instantclient/ directory, then unzip them.
 
Changed:
<
<		Place the basic and sqlplus zipped files into /usr/local/src/oracle/instantclient/, and unzip them:
>
>

Place the basic and sqlplus zipped files into /usr/local/src/oracle/instantclient/, and unzip them:

  
[root@tubes instantclient]# pwd
Line: 85 to 95
 -rw-rw-r-- 1 root root 242 Feb 17 03:58 SQLPLUS_README [root@tubes instantclient]#
Added:
>
>

Place unzipped Oracle Instant Client files into permanent installation target directory.

 Now move the unzipped directory (instantclient_10_2) that contains both the basic and SQL*Plus files from the Oracle Instant Client, into the desired permanent directory. In my example, I'm using /usr/local/, so that the Oracle files will be in a directory /usr/local/instantclient_10_2/. 
[root@tubes instantclient]# pwd
Line: 103 to 115
 appx appx.tgz basic.zip bin etc games include instantclient_10_2 lib libexec sbin share src [root@tubes instantclient]#
Added:
>
>

Configure the operating system's dynamic linker run time bindings

 Now we must register the Oracle Instant Client library files with the system to make the shared library's path known. I'm going to use ldconfig. 
[root@tubes instantclient]# ldconfig -v|grep libclntsh
Line: 116 to 130
 /usr/local/instantclient_10_2/ [root@tubes instantclient]#
Added:
>
>

Build cache used by the operating system's run-time linker

 Now, let's rebuild the ldconfig cache, and verify that the library's are available system wide. 
[root@tubes instantclient]# ldconfig
Line: 125 to 141
 /usr/local/instantclient_10_2: [root@tubes instantclient]#
Added:
>
>

Identify version of libclntsh.so that is included with downloaded Oracle Instant Client bundle

 APPX needs to know the name of the Oracle libclntsh.so file on your system. This file name changes from version to version. We must now identify the libclntsh file name that was distributed in the Oracle Instant Client bundle. Look inside the instantclient directory for a file that begins with libclntsh. To show you examples of Oracle Instant Client 10.2 and Oracle Instant Client 11.1, I have installed both versions in /usr/local/. 
[joe@tubes instantclient_10_2]$ ls -la /usr/local/instantclient_1*/libclnt*
Line: 134 to 152
  As you can see my libclntsh files are libclntsh.so.10.1, which came bundled with the Oracle Instant Client 10.2 Basic bundle, and libclntsh.so.11.1, which came bundled with the Oracle Instant Client 11.1 Basic bundle.
Changed:
<
<		To let APPX know the version of the Instant client you have installed, perform just one of the following two options:
>
>
To let APPX know the version of the Instant client you have installed, perform just one of the following two options:
Create libclntsh.so symbolic link and set the APPX_OCI_DIR environment variable
 
  • I can now either create a symbolic link named libclntsh.so that points to the version I want to use and set the APPX_OCI_DIR environment variable equal to the location of the Oracle Instant Client files:
Line: 150 to 170
 APPX_OCI_DIR=/usr/local/instantclient_10_2/ [root@tubes appx]#
Added:
>
>

Set APPX_OCI_LIB
 
  • Or I can set an APPX environment variable equal to the name of the file. First let's see if it is set in the %APPXPATH%/appx.env file:
Line: 162 to 187
 APPX_OCI_LIB=libclntsh.so.10.1 [root@tubes appx]#
Added:
>
>

Use the Oracle Instant Client's version of SQL*Plus to verify connectify to Oracle.

 Now let's verify that we can connect to Oracle using Oracle's SQL*Plus tool. I'm going to use the following parameters for my example, be sure and use values that are correct for your Oracle instance. user=scott, password=password, server=tubes, port=1521, and Oracle Instance=appx. 
[root@tubes instantclient_10_2]# /usr/local/instantclient_10_2/sqlplus scott/password@tubes:1521/appx
Line: 246 to 274
 With the Partitioning, OLAP and Data Mining options [root@tubes instantclient_10_2]#
Added:
>
>

Configure APPX FMS settings

 Well, that looks good. Let's configure our FMS settings inside APPX and make a connection!

  • In APPX, Go to System Administration, then File Management, then FMS Groups.
Line: 266 to 296
 
  • Enter the Oracle account's password.
oracle-fms-06.jpg
Deleted:
<
<		Some environment variables to keep in mind.
  • APPX
    • APPX_OCI_DIR
    • APPX_OCI_LIB
    • APPX_OCI_LIBS
    • APPX_SS_LOG
    • APPX_SS_CODE
    • APPX_SQL_CMD=/usr/local/appx/appx_sql_cmd.log
    • APPX_DBG_CODE=0xFFFFFFFF
  • Oracle
    • ORACLE_SID
    • ORACLE_HOME
    • TNS_ADMIN
Some OS tools to aid in debugging
  • strace
  • ldd
 

ODBC

Changed:
<
<
  • MySQL 5.0.22
  • PostgreSQL 8.1.9
  • IBM DB/2
  • Microsoft SQL-Server (2000, 2005, 2008, Express)
>
>

MySQL 5.0.22

PostgreSQL 8.1.9

IBM DB/2

Microsoft SQL-Server

SQL Server 2000

SQL Server 2005

SQL Server 2008

SQL Server Express

Database connectivity debug tools

APPX Environment Variables

APPX_OCI_DIR

APPX_OCI_LIB

APPX_OCI_LIB

APPX_OCI_LIBS

APPX_SS_LOG

APPX_SS_CODE

APPX_SQL_CMD=/usr/local/appx/appx_sql_cmd.log

APPX_DBG_CODE=0xFFFFFFFF

Oracle

ORACLE_SID

ORACLE_HOME

TNS_ADMIN

Some OS tools to aid in debugging

strace

ldd

Bugs:

  1. Fixed - Bug Description 1.
  2. OPEN - Bug 2209 - Lengthen field FMS Group Options - Server Name.
 

Comments:

Changed:
<
<		_Read what other users have said about this page or add your own comments.
>
>		Read what other users have said about this page or add your own comments.
 
<--/commentPlugin-->
-- AlKalter - 04 Apr 2008
View topic | History: r25 < r24 < r23 < r22 | 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