ODBC installation skipped ...
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