ODBC - Oracle Installation Instructions

• After installation, check out ODBC and Oracle FAQ.

ODBC/32 driver version 2.2.5.3 and later is compatible with Oracle Heterogeneous Services, Generic Connectivity for ODBC.

Oracle's Generic connectivity is intended for data integration solutions requiring the capability to connect from Oracle to non-Oracle database systems. Generic Connectivity is part of Oracle Heterogeneous Services.

Oracle versions

• 8i and later releases

Operating Systems

• HPUX (HPPA)
• Solaris (Sparc)
• Windows (i386)
• Linux (i386) (While the Minisoft driver is available, Generic Connectivity is not supported in all releases of Oracle for Linux.)

With the appropriate MPE and Image security, you can select, update, insert and delete records from your Oracle applications.

Read and write Image, KSAM and MPE files.

Using Oracle Generic Connectivity

This is a step-by-step guide for setting up and troubleshooting Generic Connectivity using ODBC, of Oracle 8i.

1. With the OUI (Oracle Universal Installer) install Generic Connectivity using ODBC. This product is part of the server installation, because a listener is needed. A directory called ORACLE_HOME/hs is created.
     
2. The Generic Connectivity utility needs data dictionary tables in the Oracle database. To check their existence, run a query on i.e. SYS.HS_FDS_CLASS. If it fails, run the caths.sql script located in ORACLE_HOME/RDBMS/ADMIN as user sys or internal.
     
3. Install and test the MiniSoft ODBC/32 Driver.
     
4. Configure tnsnames.ora. This file is in ORACLE_HOME/network/admin. Add the following lines to the file:
     
   hsodbc =
   (DESCRIPTION=
   (ADDRESS=(PROTOCOL=tcp)
   (HOST=<HOSTNAME>)
   (PORT=1521))
   (CONNECT_DATA=(SID=hsodbc))
   (HS=)
   )
     
   Note, a sample file is located in ORACLE_HOME/hs/admin.
     
5. Configuring listener.ora this file is in ORACLE_HOME/network/admin. Add the following line to the SID_List of the listener.ora and restart the listener afterwards. ( After the restart a service handler for hsodbc should exist).
     
   (SID_DESC=
   (SID_NAME=hsodbc)
   (ORACLE_HOME=/u01/product) |<- adjust Oracle_Home directory
   (PROGRAM=hsodbc)
   )
     
   Note, a sample file is located in ORACLE_HOME/hs/admin.
     
6. Adjust the configuration file of the gateway. It is located in ORCALE_HOME\HS\ADMIN. The name depends on the SID you use for the Heterogeneous Service. In our sample the listener SID is hsodbc and so the configuration file is inithsodbc.ora.
   HS init parameters:
     
   HS_FDS_CONNECT_INFO = mstest |<- ODBC Data Source Name
   HS_FDS_TRACE_LEVEL = 0 |<- trace levels from 0 to 4 (4 is maximum)
   HS_FDS_TRACE_FILE_NAME = |<- Name of the trace file.
   HS_FDS_SHAREABLE_NAME = |<- /opt/minisoft/lib3kodbc.so
   set ODBCINI= |<- /usr/local/etc/odbc.ini
     
7. Testing the connectivity:
     
   - create a database link:
     
   create database link hsodbc using 'hsodbc';
     
   - select * from emp@hsodbc;