Install the Oracle10g ODBC driver in Linux

Install Oracle10g ODBC driver under fedora8

1. Install unixodbc as follows:

(1). Copy the unixodbc * .tar.gz file somewhere you can create files and directories
(2). gunzip unixodbc * .tar.gz
(3). Tar xvf unixodbc *. Tar

Make the libraries and programs

The Install now uses the standard GNU Autoconf process. So its simply a matter of Running

./Configure
Make
Make install

By default the files are installed into/usr/local. As is usual with configure, this location can be changed by altering the prefix option to configure. I. e.

./Configure -- prefix =/usr/local/unixodbc

This will install the Lib, bin, include and etc directories in/usr/local/unixodbc/lib etc.

To conform with the GNU guidelines the odbcinst file is now installed by default in {prefix}/etc, this can be altered using the -- sysconfdir option to configure. to install the files in the old default/etc you wocould run configure like this

./Configure -- sysconfdir =/etc

The script will attempt to find the directories that are needed for the GUI components, and if they are not found (I. e. you haven't installed QT) the build will continue without the GUI parts.

Dependencies

The GUI components (odbcconfig and datamanager) require QT 2.2. (install qt-3.3.8-9.fc8.i386, qt-devel-3.3.8-9.fc8.i386, qt-designer-3.3.8-9.fc8.i386 package)

The sqi Library requires flex and YACC to parse the SQL statement.

The entire distribution depends upon having ratio of the standard development tools installed such as a C/C ++ Compiler (currently testing is with egcs ). also; the development platform is mostly RedHat Linux 5.1 with compiler upgrades (to be compatible with RedHat 5.2 ).

2 ODBC Instant Client

Oracle ODBC Instant Client for Linux complies with ODBC 3.52 specifications. It is based on Features of Oracle 10.2.0.3.0 ODBC driver for Windows, without the need for a traditional ORACLE_HOME installation.

Note: SeeOracle call interface programmer's GuideFor information on OCI Instant Client.

2.1 pre installation task-install odbc dm from unixodbc.org

Please install ODBC driver manager after downloading. tar file from http://www.unixodbc.org/

2.2 installing ODBC Instant Client

• Download the basic Instant Client and ODBC Instant Client packages from the Oracle technology network Instant Client page. The two packages must be unzipped into same directory. For example,C:/Oracle/instantclient_10_2.
  • Basic Instant Client is a prerequisite for installing the ODBC Instant Client.

•  
  • ODBC Instant Client package has the following file/Shared libraries

<! -- [If! Supportemptyparas] --> <! -- [Endif] -->
File Name	Description
Libsqora. so.10.1	ODBC driver shared library
Odbcrelnotesus.htm	Release Notes
Odbcrelnotesja.htm	Japan Release Notes
Odbc_ic_readme_linux.html	ODBC Instant Client for Linux Release Notes (this one)
Odbc_update_ini.sh	ODBC Instant Client install script to update. ini files

• Make sure basic Instant Client is deployed before running the ODBC install script.

• Unzip the ODBC Instant Client package, then execute the odbc_update_ini.sh script with driver Manager installed directory as a command line argument as follows (where driver manager is installed in/home/drivermanager directory ):
  $ Odbc_update_ini.sh/home/drivermanger

The utility "odbc_update_ini.sh" takes four command-line arguments

•  
  • Arg-1: complete path where unixodbc DM has been installed.
  • Arg-2: complete path of driver install location (optional); if this argument is not passed, the driver path is set to the directory from where the utility is run.
  • Arg-3: Driver name (optional); if this argument is not passed, driver name is set to "Oracle 10g ODBC driver ".
  • Arg-4: Data Source Name (optional); if no value is passed, DSN is set to OracleODBC-10g ".

•  
  • It will add the DSN entry in $ home/. ODBC. ini and <drivermanager_home>/etc/odbcinst. ini with DSN name as OracleODBC-10g

• After the installation the environment needs to be configured in the following way:
  • Add the directory (the Lib path under unixodbc) to the LD_LIBRARY_PATH system environment variable; otherwise, ODBC manager will be not able to load/find the driver.

•  
  • Define the tns_admin to point the. ora Files directory for OCI

•  
  •  
    • This needs to be set for OCI to resolve the TNS name.
    • If tns_admin is not set, OCI will examine an operating system dependent set of directories to findTnsnames. ora. This search path already des looking in the directory $ ORACLE_HOME/Network/admin/tnsnames. ora. This is the only reason to set the ORACLE_HOME environment variable for Oracle Instant Client. If ORACLE_HOME is set when running Instant Client applications, it must be set to a directory where Instant Client exists.
  • Set any Oracle globalization variables required for your locale. SeeOracle Database 10g globalization support guideFor more information.
    • For example on Linux to set nls_lang:
      • Setenv nls_lang Japan ese_japan .ja16euc

2.3 uninstalling ODBC Instant Client

• Update ~ /. ODBC. ini file:
  • Remove DSN entry (e.g., "OracleODBC-10g") from [ODBC data sources]
  • Remove complete DSN information for corresponding DSN
• Update $ dm_home/etc/odbcinst. ini file:
  • Remove driver information for "Oracle 10g ODBC driver"
• Remove Oracle ODBC driver for Linux
  • Delete libsqora. so.10.1
• Reset any environment variables such as path and tns_admin.

2.4 bugs fixed

• Please refer ODBC readme.txt.