How to configure unixODBC to access Oracle in Linux

1. Install unixODBC

UnixODBC Official Website: http://www.unixodbc.org/

Here YUM is used for installation, not to mention:

Linux uses a CD to build a local YUM Server

[Root @ rac1 mnt] # yum installunixODBC

[Root @ rac1 mnt] # yum installunixODBC-devel

Run the isql command to install unixODBC. You can use this command to verify the configuration of unixODBC.

[Root @ rac1/] # isql -- version

UnixODBC 2.2.14

[Root @ rac1/] # which isql

/Usr/bin/isql

[Root @ rac1/] # isql

 

**************************************** ******

* UnixODBC-isql *

**************************************** ******

* Syntax *

**

* Isql DSN [UID [PWD] [options] *

**

* Options *

**

*-B batch. (no prompting etc )*

*-Dx delimit columns with x *

*-X0xXX delimit columns with XX, where *

* X is in hex, ie 0x09 is tab *

*-W wrap results in an HTML table *

*-C column names on first row .*

* (Only used when-d )*

*-Mn limit column display width to n *

*-V verbose .*

*-Lx set locale to x *

*-Q wrap char fields in dquotes *

*-3 Use ODBC 3 CILS *

*-N Use new line processing *

* -- Version *

**

* Commands *

**

* Help-list tables *

* Help table-list columns in table *

* Help-list all help options *

**

* Examples *

**

* Isql WebDB MyID MyPWD-w <My. SQL *

**

* Each line in My. SQL must contain *

* Exactly 1 SQL command failed t for *

* Last line which must be blank (unless *

*-N option specified ).*

**

* Please visit ;*

**

* Http://www.unixodbc.org *

* Pharvey@codebydesign.com *

* Nick@easysoft.com *

**************************************** ******

[Root @ rac1/] #

1 2 3 Next Page