linux - 如何在 RHEL 6/Linux 上设置 Oracle ODBC 驱动程序

Question

我需要在 RHEL 6 上设置 Oracle ODBC 驱动程序以连接到驻留在远程 Windows 机器上的 Oracle 数据源。

我采取了以下步骤:
[1] 安装oracle-instanceclient-basic
[2] 设置环境变量:ORACLE_HOME和LD路径
[3] 创建/etc/oracle/TNSnames.ora 并配置但没有正确设置

最初，我收到错误，“连接失败，因为目标或对象不存在”

然后，我在 TNSnames.ora 文件中设置:ORACLE_SID = DB_NAME。

但是，这并没有解决问题，我现在收到一条新的错误消息:"TNS: net service name is incorrectly specified"

Answer 1

yum install unixODBC
rpm -ivh oracle-instantclient-basic-10.2.0.3-1.i386.rpm #downloaded on http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
unzip instantclient-odbc-linux32-10.2.0.3-20061115.zip #downloaded on http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
cp ./instantclient_10_2/libsqora.so.10.1 /usr/lib/oracle/10.2.0.3/client/lib/
export ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

您还需要设置 $TWO_TASK(Oracle 寻找服务器的默认位置)以指向 Oracle 服务器在 Windows 上运行的位置 - 不要忘记添加监听器在端口号之后的末尾:

export TWO_TASK=//213.123.23.19:1521/listener

要检查监听器的名称，请在运行 Oracle 服务器的 Windows 提示符下键入以下命令:

lsnrctl
status

它将招募听众及其状态(READY 或 UNKNOWN)。连接到处于就绪状态的监听器:Instance "zelistener", status READY

mkdir/etc/甲骨文

vi/etc/oracle/tnsnames.ora

MY_SID =
 ( DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS =
  (PROTOCOL = TCP)
  (Host = 127.0.0.1)
  (Port = 1521)
  )
 )
 (CONNECT_DATA = (SID = MY_SID)
 )
)

导出 TNS_ADMIN=/etc/oracle

vi/etc/odbcinst.ini

[OracleODBC-10g]
Description = Oracle ODBC driver for Oracle 10g
Driver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1
FileUsage = 1
Driver Logging = 7

vi/etc/odbc.ini

[simple]
Driver = OracleODBC-10g
DSN = OracleODBC-10g
ServerName = MY_SID
UserID = USER
Password = PASSWORD

isql -v 简单

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+