Difference: APPX500ToOracleOnLinux (1 vs. 43)

Revision 432023-02-06 - JohnSelvage

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

APPX 5 on Linux connectivity to Oracle

Line: 119 to 119
 APPX_OCI_LIB=libclntsh.so.10.1 [appx@appx502 services]$
Changed:
<
<		The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.
>
>		The two environment variables needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.
 

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: 217 to 217
 

Troubleshooting APPX to Oracle connection

Changed:
<
<		If you try to make a connection to Oracle from APPX and receive a message "*Can't load Oracle Call Interface (libclntsh)" then you might be missing the environment variables required, or you might have them set to incorrect paths. Make sure you downloaded the correct Oracle Instant Client files for your platform and that it maches the bitness of your APPX engine.
>
>		If you try to make a connection to Oracle from APPX and receive a message "*Can't load Oracle Call Interface (libclntsh)" then you might be missing the environment variables required, or you might have them set to incorrect paths. Make sure you downloaded the correct Oracle Instant Client files for your platform and that it matches the bitness of your APPX engine.
  Verify environment variable values via the following path: System Administration > System Setup > Release Information > Environment Variables. Did you set the environment variables inside appx.env? Setting these Oracle connectivity environment variables inside appx.env will not work. These environment variables must be present prior to the appx session starting. Try setting them in the appxLoginMgr environment variable file and then make sure you restart the daemon and reconnect to try the Oracle connection again.

Revision 422016-04-07 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="APPX500ToOracle"
Changed:
<
<

APPX 5 connectivity to Oracle on Linux

>
>

APPX 5 on Linux connectivity to Oracle

 
Changed:
<
<		How to configure APPX 5 to store data inside Oracle on Linux.
>
>		How to configure APPX 5 on Linux to store data inside Oracle.
 
Changed:
<
<

>
>

 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Oracle Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Oracle Solaris SPARC, and Microsoft Windows.
 

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

Revision 412016-04-07 - JeanNeron

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

APPX 5 connectivity to Oracle on Linux

Line: 25 to 27
 

Oracle Instant Client

Downloading

Changed:
<
<		If you are running APPX 5.4.3 or earlier, you will need the 32 bit Oracle interface. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. If you are running APPX 6.0 or greater, you need to know if you are running 32 or 64 bit APPX engine and download the appropriate Instant Client.
>
>		If you are running an APPX release prior to 6.0, you will need the 32 bit Oracle interface. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. If you are running APPX 6.0 or greater, you need to know if you are running 32 or 64 bit APPX engine and download the appropriate Instant Client.
  On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:

Installing

Revision 402016-01-08 - JeanNeron

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="APPX500ToOracle"
 

APPX 5 connectivity to Oracle on Linux

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

Line: 12 to 13
  This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.
Deleted:
<
<
 Unix/Linux will ignore environment variables such as LD_LIBRARY_PATH, SHLIB_PATH and LIBPATH required for Oracle's Instant Client when called from a SUID binary (which APPX typically is). To accomodate this, you'll want to remove the SUID on appx and configure APPX Login Manager to impersonate the appx user (typically appx) and appx group (typically appxgrp). This is accomplished via the service .ini parameters:
Deleted:
<
<
 
ImpersonateGroup            = NamedGroup(appxgrp)               #[LogonUser, NamedGroup(groupname), ServiceOwner]
Changed:
<
<		ImpersonateUser = NamedUser(appx) #[LogonUser, NamedUser(username), ServiceOwner]
>
>		ImpersonateUser = NamedUser(appx) #[LogonUser, NamedUser(username), ServiceOwner]
  Connections via the APPX Login Manager will then be able to make use of the Oracle Instant Client connection. From the command line, you can connect to the APPX Login Manager via the -c argument to appx like so:
Deleted:
<
<
 
Changed:
<
<		appx -c
>
>		appx -c
 

Oracle Instant Client

Downloading

Changed:
<
<		APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:
>
>		If you are running APPX 5.4.3 or earlier, you will need the 32 bit Oracle interface. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. If you are running APPX 6.0 or greater, you need to know if you are running 32 or 64 bit APPX engine and download the appropriate Instant Client.

On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:

 

Installing 

[root@appx502 10.2.0.4-32bit]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm 
Preparing...                ########################################### [100%]
Line: 64 to 62
 
[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@appx502 ~]#
>
>		[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

Line: 85 to 82
 SQL> quit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
Changed:
<
<		[root@appx502 ~]#
>
>		[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.

Line: 120 to 117
 # APPX_DBG_CODE=0xFFFFFFF # APPX_OCI_DIR=/usr/lib/oracle/10.2.0.4/client/lib/ APPX_OCI_LIB=libclntsh.so.10.1
Changed:
<
<		[appx@appx502 services]$
>
>		[appx@appx502 services]$
  The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

FMS settings

Line: 137 to 133
  After creating the FMS group, we will define an APPX DMO PROSPECT to make use of this FMS group, finally performing a CREATE FILE from within APPX to create the file in Oracle. These steps are documented in screen shots below.
Changed:
<
<		001.png
>
>		001.png
  Fig. 1
Changed:
<
<		First we need to go to our FMS seetings inside APPX.
>
>		First we need to go to our FMS settings inside APPX.
 
Changed:
<
<		002.png
>
>		002.png
  Fig. 2

Go into APPX ADD mode and create an FMS group with a meaningful name of a type 5 for your Oracle data.

Changed:
<
<		003.png
>
>		003.png
  Fig. 3
Changed:
<
<		Now you need to fill out at least Server Name and Table Naming Scheme. You can select the HINTS button to see other suggested formats for the Table Naming Scheme if you wish.
>
>		Now you need to fill out at least Server Name and Table Naming Scheme. You can select the HINTS button to see other suggested formats for the Table Naming Scheme if you wish. Note: The server name must be in the format <servername or ip>:port/Oracle SID
 
Changed:
<
<		004.png
>
>		004.png
  Fig. 4

I'm going to create a default identity that all my APPX connections to Oracle will use that don't have a specific matching identity.

Changed:
<
<		005.png
>
>		005.png
  Fig. 5

My default identity is Oracle user ID larry. Any APPX user without a specified Oracle Identity will connect to Oracle with this user ID.

Changed:
<
<		006.png
>
>		006.png
  Fig. 6
Line: 177 to 173
  We're now finished with the creation of the FMS group. In the six screen shots above, you can see the creation of the FMS type 5 group named oracle10. We now are going to define APPX DMO PROSPECT to make use of this FMS group so that the data can be stored in Oracle. This will be documented in the following seven screen shots.
Changed:
<
<		007.png
>
>		007.png
  Fig. 7

Let's go to Database Definitions for DMO.

Changed:
<
<		008.png
>
>		008.png
  Fig. 8

Select DMO

Changed:
<
<		009.png
>
>		009.png
  Fig. 9

Select Database Management

Changed:
<
<		010.png
>
>		010.png
  Fig. 10

Go to File Selection

Changed:
<
<		011.png
>
>		011.png
  Fig. 11

Select PROSPECT

Changed:
<
<		012.png
>
>		012.png
  Fig. 12

In File Specifications change the FMS type to 5, and the FMS GROUP name to be whatever you used as your Oracle FMS group name. I used a name of oracle10.

Changed:
<
<		013.png
>
>		013.png
  Fig. 13
Line: 221 to 217
 

Troubleshooting APPX to Oracle connection

Changed:
<
<		If you try to make a connection to Oracle from APPX and receive a message "*Can't load Oracle Call Interface (libclntsh)" then you might be missing the environment variables required, or you might have them set to incorrect paths. Make sure you downloaded the correct Oracle Instant Client files for your platform and that the bitness is 32 and not 64.
>
>		If you try to make a connection to Oracle from APPX and receive a message "*Can't load Oracle Call Interface (libclntsh)" then you might be missing the environment variables required, or you might have them set to incorrect paths. Make sure you downloaded the correct Oracle Instant Client files for your platform and that it maches the bitness of your APPX engine.
  Verify environment variable values via the following path: System Administration > System Setup > Release Information > Environment Variables. Did you set the environment variables inside appx.env? Setting these Oracle connectivity environment variables inside appx.env will not work. These environment variables must be present prior to the appx session starting. Try setting them in the appxLoginMgr environment variable file and then make sure you restart the daemon and reconnect to try the Oracle connection again.

Revision 392012-01-27 - 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: 11 to 11
 

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

Added:
>
>

Unix/Linux will ignore environment variables such as LD_LIBRARY_PATH, SHLIB_PATH and LIBPATH required for Oracle's Instant Client when called from a SUID binary (which APPX typically is). To accomodate this, you'll want to remove the SUID on appx and configure APPX Login Manager to impersonate the appx user (typically appx) and appx group (typically appxgrp). This is accomplished via the service .ini parameters: 

ImpersonateGroup            = NamedGroup(appxgrp)               #[LogonUser, NamedGroup(groupname), ServiceOwner] 
ImpersonateUser             = NamedUser(appx)          #[LogonUser, NamedUser(username), ServiceOwner]

Connections via the APPX Login Manager will then be able to make use of the Oracle Instant Client connection. From the command line, you can connect to the APPX Login Manager via the -c argument to appx like so: 

appx -c
 

Oracle Instant Client

Downloading

Revision 382010-07-09 - 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: 7 to 7
 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity,Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Oracle Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
 

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

Revision 372010-07-09 - 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: 7 to 7
 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX , HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity,Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
 

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

Revision 362010-07-09 - 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: 7 to 7
 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX , HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX , HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
 

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

Line: 203 to 203
  Fig. 13
Changed:
<
<		Finally, in figure 13, you see the Create Files screen with a message that the Oracle DMO PROSPECT file was created.
>
>		Finally, in figure 13, you see the Create Files screen with a message that the Oracle DMO PROSPECT file was created. If you receive a message similar to "*Can't load Oracle Call Interface (libclntsh)" see Troubleshooting section below.

Troubleshooting APPX to Oracle connection

If you try to make a connection to Oracle from APPX and receive a message "*Can't load Oracle Call Interface (libclntsh)" then you might be missing the environment variables required, or you might have them set to incorrect paths. Make sure you downloaded the correct Oracle Instant Client files for your platform and that the bitness is 32 and not 64.

Verify environment variable values via the following path: System Administration > System Setup > Release Information > Environment Variables. Did you set the environment variables inside appx.env? Setting these Oracle connectivity environment variables inside appx.env will not work. These environment variables must be present prior to the appx session starting. Try setting them in the appxLoginMgr environment variable file and then make sure you restart the daemon and reconnect to try the Oracle connection again.

  -- JoeOrtagus - 2010-07-07

Revision 352010-07-09 - JoeOrtagus

Line: 1 to 1
 

APPX 5 connectivity to Oracle on Linux

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

Revision 342010-07-09 - 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: 7 to 7
 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, IBM AIX, HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.
 

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

Revision 332010-07-09 - 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: 7 to 7
 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product. This wiki site also has instructions for other platforms performing APPX to RDBMS connectivity, Linux x86-64, HPUX PARISC, HPUX Itanium, Sun Solaris SPARC, Microsoft Windows and SQL Server 2005, Microsoft Windows and SQL Server 2008.

Prerequisites

This document assumes you already have Oracle installed on your network and configured to accept connections. For performance reasons, it is recommended that your RDBMS and APPX be on the same server. APPX should also already be installed with the AppxLoginMgr configured to accept logins.

 

Oracle Instant Client

Downloading

Revision 322010-07-09 - 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: 7 to 7
 

Overview

Changed:
<
<		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.
>
>		Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you where to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.
 

Oracle Instant Client

Downloading

Revision 312010-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: 164 to 164
  Fig. 7
Added:
>
>		Let's go to Database Definitions for DMO.
 008.png

Fig. 8

Added:
>
>		Select DMO
 009.png

Fig. 9

Added:
>
>		Select Database Management
 010.png

Fig. 10

Added:
>
>		Go to File Selection
 011.png

Fig. 11

Added:
>
>		Select PROSPECT
 012.png

Fig. 12

Added:
>
>		In File Specifications change the FMS type to 5, and the FMS GROUP name to be whatever you used as your Oracle FMS group name. I used a name of oracle10.
 013.png

Fig. 13

Added:
>
>		Finally, in figure 13, you see the Create Files screen with a message that the Oracle DMO PROSPECT file was created.
 -- JoeOrtagus - 2010-07-07

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"

Revision 302010-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: 116 to 116
 
  • Resolvable DNS name or IP address of the Oracle server (10.50.0.6)
  • Oracle user ID (larry)
  • Oracle password (yacht)
Added:
>
>
FMS Group Creation
  After creating the FMS group, we will define an APPX DMO PROSPECT to make use of this FMS group, finally performing a CREATE FILE from within APPX to create the file in Oracle. These steps are documented in screen shots below.
Line: 153 to 154
  Fig. 6
Added:
>
>		Figure 6 shows the entry of the default identity password. This is the password for my Oracle user ID larry.

Define Data file to point to Oracle

We're now finished with the creation of the FMS group. In the six screen shots above, you can see the creation of the FMS type 5 group named oracle10. We now are going to define APPX DMO PROSPECT to make use of this FMS group so that the data can be stored in Oracle. This will be documented in the following seven screen shots.

 007.png

Fig. 7

Revision 292010-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: 131 to 129
  Fig. 2
Changed:
<
<
Go into APPX ADD mode and create an FMS group with a meaningful name of a type 5 for your Oracle data.
>
>		Go into APPX ADD mode and create an FMS group with a meaningful name of a type 5 for your Oracle data.
  003.png

Fig. 3

Changed:
<
<
Now you need to fill out at least Server Name and Table Naming Scheme. You can select the HINTS button to see other suggested formats for the Table Naming Scheme if you wish.
>
>		Now you need to fill out at least Server Name and Table Naming Scheme. You can select the HINTS button to see other suggested formats for the Table Naming Scheme if you wish.
  004.png

Fig. 4

Added:
>
>		I'm going to create a default identity that all my APPX connections to Oracle will use that don't have a specific matching identity.
 005.png

Fig. 5

Added:
>
>		My default identity is Oracle user ID larry. Any APPX user without a specified Oracle Identity will connect to Oracle with this user ID.
 006.png

Fig. 6

Revision 282010-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: 109 to 109
 The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

FMS settings

Added:
>
>		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.

  • 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)
  • Oracle password (yacht)

After creating the FMS group, we will define an APPX DMO PROSPECT to make use of this FMS group, finally performing a CREATE FILE from within APPX to create the file in Oracle. These steps are documented in screen shots below.

 001.png

Fig. 1

Added:
>
>		First we need to go to our FMS seetings inside APPX.

 002.png

Fig. 2

Added:
>
>
Go into APPX ADD mode and create an FMS group with a meaningful name of a type 5 for your Oracle data.
 003.png

Fig. 3

Added:
>
>
Now you need to fill out at least Server Name and Table Naming Scheme. You can select the HINTS button to see other suggested formats for the Table Naming Scheme if you wish.
 004.png

Fig. 4

Revision 272010-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: 141 to 141
  Fig. 8
Changed:
<
<		009.png
>
>		009.png
 
Changed:
<
<		Fig. 9
>
>		 Fig. 9
 
Changed:
<
<		010.png
>
>		010.png
 
Changed:
<
<		Fig. 10
>
>		 Fig. 10
 
Changed:
<
<		011.png
>
>		011.png
 
Changed:
<
<		Fig. 11
>
>		 Fig. 11
  012.png

Revision 262010-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: 143 to 143
  009.png
Added:
>
>		Fig. 9
 010.png
Added:
>
>		Fig. 10
 011.png
Changed:
<
<		012.png
>
>		Fig. 11

012.png

Fig. 12

013.png

 
Changed:
<
<		013.png
>
>		Fig. 13
  -- JoeOrtagus - 2010-07-07

Revision 252010-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: 115 to 115
  002.png
Changed:
<
<		Fig. 2
>
>		 Fig. 2
  003.png
Changed:
<
<		Fig. 3
>
>		 Fig. 3
  004.png
Changed:
<
<		Fig. 4
>
>		 Fig. 4
  005.png
Changed:
<
<		Fig. 5
>
>		 Fig. 5
  006.png
Changed:
<
<		Fig. 6
>
>		 Fig. 6
 
Changed:
<
<		007.png
>
>		007.png
 
Changed:
<
<		008.png
>
>		Fig. 7

008.png

Fig. 8

  009.png

Revision 242010-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: 111 to 111
  001.png
Changed:
<
<		Fig. 1
>
>		 Fig. 1
  002.png
Line: 119 to 119
  003.png
Changed:
<
<		004.png
>
>		Fig. 3
 
Changed:
<
<		005.png
>
>		004.png
  Fig. 4
Changed:
<
<		006.png
>
>		005.png

Fig. 5

006.png

Fig. 6

  007.png

Revision 232010-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: 111 to 111
  001.png
Changed:
<
<		002.png
>
>		Fig. 1
 
Changed:
<
<		003.png
>
>		002.png
 
Changed:
<
<		004.png
>
>		Fig. 2

003.png

004.png

  005.png
Added:
>
>		Fig. 4
 006.png

007.png

Revision 222010-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: 109 to 109
 The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

FMS settings

Changed:
<
<		001.png
>
>		001.png
  002.png

Revision 212010-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: 109 to 109
 The two environment varialbes needed for for the Oracle connection are LD_LIBRARY_PATH and APPX_OCI_LIB.

FMS settings

Added:
>
>		001.png

002.png

003.png

004.png

005.png

006.png

007.png

008.png

009.png

010.png

011.png

012.png

013.png

 -- JoeOrtagus - 2010-07-07

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"

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"

Revision 192010-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 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.
 

Environment variables

Changed:
<
<		I'm going to set two environment variables one for the OS (LD_LIBRARY_PATH) and one for APPX (APPX_OCI_LIB) inside.
>
>		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).
 

FMS settings

-- JoeOrtagus - 2010-07-07

Revision 182010-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: 71 to 71
 [root@appx502 ~]#

APPX

Added:
>
>		 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

Added:
>
>		 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.
 

Environment variables

Added:
>
>		 I'm going to set two environment variables one for the OS (LD_LIBRARY_PATH) and one for APPX (APPX_OCI_LIB) inside.
 

FMS settings

-- JoeOrtagus - 2010-07-07

Revision 172010-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: 70 to 70
 With the Partitioning, OLAP and Data Mining options [root@appx502 ~]#
Changed:
<
<		 APPX

Configuration

Environment variables

FMS settings

>
>

APPX

Configuration

Environment variables

FMS settings

  -- JoeOrtagus - 2010-07-07

Revision 162010-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: 71 to 71
 [root@appx502 ~]#
Added:
>
>		APPX

Configuration

Environment variables

FMS settings

 -- JoeOrtagus - 2010-07-07

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

Revision 142010-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: 43 to 43
 
  • Oracle password (yacht)

I'll use the Oracle Easy Connect syntax to log in.

Changed:
<
<
[root@appx502l ~]#
[root@appx502l ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10
>
>

Failure without LD_LIBRARY_PATH 

[root@ocportal ~]#
[root@ocportal ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus scott/password@192.168.1.213:1521/oracle10
 /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@appx502 ~]# [root@appx502 ~]# export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib
>
>		[root@ocportal ~]#

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 ~]# [root@appx502 ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10

Revision 132010-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.

Revision 122010-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: 41 to 41
 
  • Resolvable DNS name or IP address of the Oracle server (10.50.0.6)
  • Oracle user ID (larry)
  • Oracle password (yacht)
Added:
>
>		 I'll use the Oracle Easy Connect syntax to login.
 
[root@appx502l ~]#
[root@appx502l ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10
/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

Revision 112010-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: 13 to 13
  APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:

Installing

Changed:
<
<
[root@appx502 10.2.0.4-32bit]# <strong>rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm</strong>
>
>
[root@appx502 10.2.0.4-32bit]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
 Preparing... ########################################### [100%]
  1. :oracle-instantclient-ba########################################### [ 50%]
  2. :oracle-instantclient-sq########################################### [100%]
[root@appx502 10.2.0.4-32bit]#
Changed:
<
<		[root@appx502 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
>
>		[root@appx502 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
 /usr/lib/oracle/10.2.0.4/client/bin/genezi /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so
Line: 42 to 42
 
  • Oracle user ID (larry)
  • Oracle password (yacht) 
[root@appx502l ~]#
Changed:
<
<		[root@appx502l ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10
>
>		[root@appx502l ~]# /usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10
 /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 [root@appx502 ~]#
Changed:
<
<		[root@appx502 ~]# export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib
>
>		[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/oracle10
  SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 8 13:06:38 2010
Line: 58 to 58
 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
Changed:
<
<		SQL> quit
>
>		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 ~]#

Revision 102010-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: 13 to 13
  APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:

Installing

Changed:
<
<
[root@appx502 10.2.0.4-32bit]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
>
>
[root@appx502 10.2.0.4-32bit]# <strong>rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm</strong>
 Preparing... ########################################### [100%]
  1. :oracle-instantclient-ba########################################### [ 50%]
  2. :oracle-instantclient-sq########################################### [100%]
[root@appx502 10.2.0.4-32bit]#
Changed:
<
<		[root@appx502 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
>
>		[root@appx502 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
 /usr/lib/oracle/10.2.0.4/client/bin/genezi /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so
Line: 34 to 34
 [root@appx502 10.2.0.4-32bit]#

Testing

Changed:
<
<		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.
>
>		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:

  • Oracle SID (oracle10)
  • 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)
  • Oracle password (yacht) 
[root@appx502l ~]#
[root@appx502l ~]# <strong>/usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10</strong>
/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
[root@appx502 ~]#
[root@appx502 ~]# <strong>export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib</strong>
[root@appx502 ~]#
[root@appx502 ~]# <strong>/usr/lib/oracle/10.2.0.4/client/bin/sqlplus larry/yacht@10.50.0.6:1521/oracle10</strong>

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 8 13:06:38 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> <strong>quit</strong>
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[root@appx502 ~]#
  -- JoeOrtagus - 2010-07-07

Revision 92010-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: 8 to 8
 

Overview

Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.

Changed:
<
<

Downloading the Oracle Instant Client

>
>

Oracle Instant Client

Downloading

  APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:
Added:
>
>

Installing

 
[root@appx502 10.2.0.4-32bit]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm 
Preparing...                ########################################### [100%]
   1:oracle-instantclient-ba########################################### [ 50%]
Line: 30 to 32
 /usr/lib/oracle/10.2.0.4/client/lib/libsqlplus.so /usr/lib/oracle/10.2.0.4/client/lib/libsqlplusic.so [root@appx502 10.2.0.4-32bit]#
Added:
>
>

Testing

 
Changed:
<
<		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.
>
>		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.
  -- JoeOrtagus - 2010-07-07

Revision 82010-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: 11 to 11
 

Downloading the Oracle Instant Client

APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below:

Changed:
<
<
[root@ocportal 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
>
>
[root@appx502 10.2.0.4-32bit]# rpm -ivh oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm 
Preparing...                ########################################### [100%]
   1:oracle-instantclient-ba########################################### [ 50%]
   2:oracle-instantclient-sq########################################### [100%]
[root@appx502 10.2.0.4-32bit]#
[root@appx502 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
 /usr/lib/oracle/10.2.0.4/client/bin/genezi /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1 /usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so
Line: 24 to 29
 /usr/lib/oracle/10.2.0.4/client/lib/glogin.sql /usr/lib/oracle/10.2.0.4/client/lib/libsqlplus.so /usr/lib/oracle/10.2.0.4/client/lib/libsqlplusic.so
Changed:
<
<		[root@ocportal 10.2.0.4-32bit]#
>
>		[root@appx502 10.2.0.4-32bit]#
  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.

Revision 72010-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: 26 to 26
 /usr/lib/oracle/10.2.0.4/client/lib/libsqlplusic.so [root@ocportal 10.2.0.4-32bit]#
Changed:
<
<		The location isn't terribly important, only that you know where the library files libclntsh, libnnz10, libocci, libociei and executable sqlplus are located.
>
>		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.
  -- JoeOrtagus - 2010-07-07

Revision 62010-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: 10 to 10
 Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.

Downloading the Oracle Instant Client

Changed:
<
<		APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles Instant Client Package - Basic and Instant Client Package - SQL*Plus.
>
>		APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles, Instant Client Package - Basic and Instant Client Package - SQL*Plus. I chose the rpm, but the zip packages work just as well. The rpms deposited the Oracle Instant client files as shown below: 
[root@ocportal 10.2.0.4-32bit]# rpm -qlp oracle-instantclient-basic-10.2.0.4-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm 
/usr/lib/oracle/10.2.0.4/client/bin/genezi
/usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so.10.1
/usr/lib/oracle/10.2.0.4/client/lib/libnnz10.so
/usr/lib/oracle/10.2.0.4/client/lib/libocci.so.10.1
/usr/lib/oracle/10.2.0.4/client/lib/libociei.so
/usr/lib/oracle/10.2.0.4/client/lib/libocijdbc10.so
/usr/lib/oracle/10.2.0.4/client/lib/ojdbc14.jar
/usr/bin/sqlplus
/usr/lib/oracle/10.2.0.4/client/bin/sqlplus
/usr/lib/oracle/10.2.0.4/client/lib/glogin.sql
/usr/lib/oracle/10.2.0.4/client/lib/libsqlplus.so
/usr/lib/oracle/10.2.0.4/client/lib/libsqlplusic.so
[root@ocportal 10.2.0.4-32bit]#

The location isn't terribly important, only that you know where the library files libclntsh, libnnz10, libocci, libociei and executable sqlplus are located.

  -- JoeOrtagus - 2010-07-07

Revision 52010-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: 10 to 10
 Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.

Downloading the Oracle Instant Client

Added:
>
>		APPX requires a 32 bit Oracle interface for all Oracle connections. Even if your OS is 64 bit, even if your Oracle is 64 bit, APPX requires you to connect to Oracle via the 32 bit version of the Oracle Instant Client. You can download the 32 bit version of Oracle Instant Client here. On my test server here I have APPX installed on Red Hat Enterprise 5 64 bit OS. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine to Oracle 10.2.0.4 and above (including 11). I downloaded the 32 bit version of Oracle's Instant Client 10.2.0.4, selecting two file bundles Instant Client Package - Basic and Instant Client Package - SQL*Plus.
 -- JoeOrtagus - 2010-07-07

Revision 42010-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.


Changed:
<
<

Overview

>
>

Overview

  Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.
Changed:
<
<

Downloading the Oracle Instant Client

>
>

Downloading the Oracle Instant Client

  -- JoeOrtagus - 2010-07-07

Revision 32010-07-07 - JoeOrtagus

Line: 1 to 1
 

APPX 5 connectivity to Oracle on Linux

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

Changed:
<
<
>
>

 

Overview

Revision 22010-07-07 - JoeOrtagus

Line: 1 to 1
Added:
>
>

APPX 5 connectivity to Oracle on Linux

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


Overview

Release 5.0.0 or higher of the APPX Utility allows APPX to connect to Oracle via Oracle's Instant Client instead of the Oracle Client Interface. This allows for an easier configuration because the files can be placed on the server by hand instead of making use of an Oracle install routine to place the Client. This document will show you were to get the Oracle Instant Client, where you might place the Instant Client Files from Oracle, and how to make APPX aware of the Oracle Instant Client files so that you can store APPX data inside Oracle. This document will focus on the Linux platform, specifically the Red Hat Enterprise product.

Downloading the Oracle Instant Client

 -- JoeOrtagus - 2010-07-07

Revision 12010-07-07 - JoeOrtagus

Line: 1 to 1
Added:
>
>		-- JoeOrtagus - 2010-07-07
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