Linux Oracle ODBC driver installation configuration

1. ODBC installation skipped ...
   

2. Oracle official website http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html Download:

   oracle_instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm

   oracle_instantclient11.2-odbc-11.2.0.3.0-1.x86_64.rpm

   oracle_instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm
   

Direct RPM-IVH Installation

3. The ODBC configuration file is in the/usr/local/etc path,

Odbc.ini file

[ODBC Data Sources]
Lim = Lim ORACLE
[Lim]
Description = Lim
Driver = Oracle
UserID = Lim
Password = Lim
Database = Ora11
ServerName = testotporacle
DSN = Oracle

Odbcinst.ini file

[Oracle]
Description = Oracle
Driver =/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

4. Create the Etc/oracle directory, add the Tnsnames.ora file, and configure the following:

Testotporacle =
(DESCRIPTION =
(Address_list =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 10.99.76.210)
(Port = 1521)
)
)

(Connect_data =
(SID = ora11)
)
)

5. Environment variable Modification

Export Tns_admin=/etc/oracle
Export oracle_home=/usr/lib/oracle/11.2/client64/
Export ld_library_path=ld_library_path:/usr/lib/oracle/11.2/client64/lib/

6. Isql-v Lim

+---------------------------------------+
|                            connected! |
| |
| sql-statement |
| Help [TableName] |
| Quit |
| |
+---------------------------------------+
Sql> quit;

Error encountered:

[28000] [UnixODBC] [Oracle] [ODBC] [Ora] Ora-01017:invalid Username/password; Logon denied

Solve:

View Cat/etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

Cat/etc/sysconfig/network

Networking=yes
Hostname=lim_dev52. Ess. CN01

Add in the/etc/hosts file

10.99.76.44 lim_dev52. Ess. CN01

Cat/etc/hosts after modification

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.99.76.44 lim_dev52. Ess. CN01

10.99.76.44 is the native IP.

Linux Oracle ODBC driver installation configuration