Install the Oracle10g ODBC driver in Linux

Source: Internet
Author: User
Tags driver manager dsn gz file
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.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.