Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Changed: | ||||||||
< < | APPX 5 connectivity to Oracle on HP-UX PA-RISC | |||||||
> > | APPX 5 on HP-UX PA-RISC connectivity to Oracle | |||||||
Changed: | ||||||||
< < | How to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | |||||||
> > | How to configure APPX 5 on HP-UX PA-RISC to store data inside Oracle. | |||||||
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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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. | |||||||
PrerequisitesThis 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: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISC | ||||||||
Line: 15 to 15 | ||||||||
Oracle Instant ClientDownloading | ||||||||
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 HP-UX 11.23. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine for 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.
Installing |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > |
| |||||||
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
Line: 14 to 15 | ||||||||
Oracle Instant ClientDownloading | ||||||||
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 HP-UX 11.23. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine for 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. | |||||||
> > | 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 HP-UX 11.23. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine for 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. | |||||||
InstallingI unzipped the Oracle Instant client files as shown below: | ||||||||
Line: 54 to 57 | ||||||||
/usr/lib/dld.sl: Can't open shared library: /b/216/lib//libnnz10.sl /usr/lib/dld.sl: No such file or directory Abort(coredump) | ||||||||
Changed: | ||||||||
< < | # | |||||||
> > | # | |||||||
Notice the failure to open libnnz10 in the text above. You can resolve this on HP-UX PA-RISC with an OS environment variable SHLIB_PATH. An example is below.
Success with SHLIB_PATH | ||||||||
Line: 77 to 79 | ||||||||
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: | ||||||||
< < | # | |||||||
> > | # | |||||||
APPXWe 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. | ||||||||
Line: 127 to 128 | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 1 First we need to go to our FMS seetings inside APPX. | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 6 | ||||||||
Line: 167 to 168 | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 7 Let's go to Database Definitions for DMO. | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 8 Select DMO | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 9 Select Database Management | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 10 Go to File Selection | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 11 Select PROSPECT | ||||||||
Changed: | ||||||||
< < | ||||||||
> > | ||||||||
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: | ||||||||
< < | ||||||||
> > | ||||||||
Fig. 13 | ||||||||
Line: 211 to 212 | ||||||||
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 the bitness matches 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. |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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. | |||||||
PrerequisitesThis 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: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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. | |||||||
PrerequisitesThis 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: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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. | |||||||
PrerequisitesThis 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: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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. | |||||||
PrerequisitesThis 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: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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. | |||||||
PrerequisitesThis 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: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
Line: 213 to 213 | ||||||||
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. | ||||||||
Changed: | ||||||||
< < | Verify your what your environment variables are set to 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. | |||||||
> > | 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-09 |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
Line: 213 to 213 | ||||||||
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. | ||||||||
Added: | ||||||||
> > | Verify your what your environment variables are set to 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-09
|
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. | ||||||||
Line: 207 to 207 | ||||||||
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 connectionIf 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. | |||||||
-- JoeOrtagus - 2010-07-09 |
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC. |
Line: 1 to 1 | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Added: | |||||||||||||||||||||||||||
> > | APPX 5 connectivity to Oracle on HP-UX PA-RISCHow to configure APPX 5 to store data inside Oracle on HP-UX PA-RISC.OverviewRelease 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 HP-UX PA-RISC platform, specifically HP's HP-UX PA-RISC 11.23 (aka 11iv2) 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.PrerequisitesThis 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 ClientDownloadingAPPX 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 HP-UX 11.23. Oracle is installed on a secondary server - Red Hat Enterprise 4 32 bit. The connection from APPX to Oracle should work fine for 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.InstallingI unzipped the Oracle Instant client files as shown below:# find /usr/lib/instantclient_10_2/ -print /usr/lib/instantclient_10_2 /usr/lib/instantclient_10_2/BASIC_README /usr/lib/instantclient_10_2/classes12.jar /usr/lib/instantclient_10_2/genezi /usr/lib/instantclient_10_2/libclntsh.sl.10.1 /usr/lib/instantclient_10_2/libnnz10.sl /usr/lib/instantclient_10_2/libocci.sl.10.1 /usr/lib/instantclient_10_2/libociei.sl /usr/lib/instantclient_10_2/libocijdbc10.sl /usr/lib/instantclient_10_2/ojdbc14.jar /usr/lib/instantclient_10_2/SQLPLUS_README /usr/lib/instantclient_10_2/glogin.sql /usr/lib/instantclient_10_2/libsqlplus.sl /usr/lib/instantclient_10_2/libsqlplusic.sl /usr/lib/instantclient_10_2/sqlplus /usr/lib/instantclient_10_2/core /usr/lib/instantclient_10_2/sqlnet.log # TestingThe 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:
Failure without SHLIB_PATH# /opt/instantclient_10_2/sqlplus larry/yacht@10.50.0.6:1521/customer Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory #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 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 11:07:25 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> quit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options # APPXWe 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.ConfigurationSince 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 variablesI'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).pwd /usr/local/appx/appx.502/services # cat appxd-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/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 #The two environment varialbes needed for for the Oracle connection on AIX are LIBPATH and APPX_OCI_DIR. FMS settingsWe 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.
FMS Group CreationAfter 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. Fig. 1 First we need to go to our FMS seetings inside APPX. Fig. 2 Go into APPX ADD mode and create an FMS group with a meaningful name of a type 5 for your Oracle data. Fig. 3 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. 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. 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. Fig. 6 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 OracleWe'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. Fig. 7 Let's go to Database Definitions for DMO. Fig. 8 Select DMO Fig. 9 Select Database Management Fig. 10 Go to File Selection Fig. 11 Select PROSPECT 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. Fig. 13 Finally, in figure 13, you see the Create Files screen with a message that the Oracle DMO PROSPECT file was created. | ||||||||||||||||||||||||||
-- JoeOrtagus - 2010-07-09 | |||||||||||||||||||||||||||
Added: | |||||||||||||||||||||||||||
> > |
|
Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
Added: | ||||||||
> > | -- JoeOrtagus - 2010-07-09 |