日期:2014-05-17  浏览次数:21042 次

unidac连接到oracle问题
oracle安装在:192.168.1.100,listener.ora如下:

# listener.ora Network Configuration File: E:\app\wang\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = E:\app\wang\product\11.2.0\dbhome_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:E:\app\wang\product\11.2.0\dbhome_1\bin\oraclr11.dll")
  )
  )

LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  )

ADR_BASE_LISTENER = E:\app\wang

在本机(192.168.1.100)上设置 unidac为:

Provider:oracle

username:scott

password:*****

server:192.168.1.100:1521:MyOral

连接方式是:direct

就是连接不上

请问何故

谢谢





------解决方案--------------------
参考一下这篇文章:
http://hi.baidu.com/zhxp/blog/item/df5dfafa01b650d4b58f3159.html