XP系统 ,安装ORACLE 9i
安装DELPHI使用ADO链接数据库正常,可以使用
后安装OOP for .NET ORACLE客户端
WEB服务链接数据库正常,SQL PLUS 链接正常。可以使用
但是此时ADO的链接提示:ORACLE ORA-12154:TNS无法解析指定的连接标识符
非常郁闷
检查注册表,发现路径没有问题
检查F:\oracle\ora92\network\admin\tnsnames.ora
没有问题,内容如下:
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nono2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nono2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
)
)机器名:nono2,改127.0.0.1或者IP地址还是一样。
非常郁闷,急呀
安装DELPHI使用ADO链接数据库正常,可以使用
后安装OOP for .NET ORACLE客户端
WEB服务链接数据库正常,SQL PLUS 链接正常。可以使用
但是此时ADO的链接提示:ORACLE ORA-12154:TNS无法解析指定的连接标识符
非常郁闷
检查注册表,发现路径没有问题
检查F:\oracle\ora92\network\admin\tnsnames.ora
没有问题,内容如下:
# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nono2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nono2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB)
)
)机器名:nono2,改127.0.0.1或者IP地址还是一样。
非常郁闷,急呀
解决方案 »
- delphi被卖了!
- 怎样用程序禁用、启用网络连接(在线等)
- 初学者请教高手。。。。。。。。。谢谢谢
- 怎样解决在RichEdit中实现文本全选功能??在线等!
- Windows XP中如何安装MS SQL SERVER2000?
- 我想在主窗体显示后,不点击其他按钮或其他操作就显示另外一个窗体,不知如何做到?
- 怎样实现多栏打印
- 请问:在INSTALLSHIELD8中如何给安装程序加上序列号并校验
- Windows在打开文件夹的时候 难道不调用FindFirstFile或者FindFirstFileEx之类的api吗?
- 大家推荐一下几个好一点有关delphi的英文网站和BBS
- 如何隐藏FastReport中的某些Page
- 怎样清空adotable表
# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nono2)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DB)
(ORACLE_HOME = F:\oracle\ora92)
(SID_NAME = DB)
)
)
看看HKey_Local_Machine\Software\Oracle 的Oracle_Home值对不对