环境如下:
WINDOWS2008 + ORACLE 10g (服务器端)
WINDOWSXP + PB11.5 + ORACLE10g客户端(客户端)
在PB11.5中利用ODBC连接数据库正常,但是用ORACLE10G的专用接口总提示
ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务。安装网上的说明,修改了服务器端的LISTENER.ORA 如下:
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.71)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)仍然没有解决问题。求助,求助
WINDOWS2008 + ORACLE 10g (服务器端)
WINDOWSXP + PB11.5 + ORACLE10g客户端(客户端)
在PB11.5中利用ODBC连接数据库正常,但是用ORACLE10G的专用接口总提示
ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务。安装网上的说明,修改了服务器端的LISTENER.ORA 如下:
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.71)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)仍然没有解决问题。求助,求助
解决方案 »
- 大家帮忙看这条SQL怎么 处理
- 求助,在VB6里如何向ORACLE里的XMLTYPE字段写超过4000字节的画面输入的内容
- identifier too long和取存储过程返回值问题
- 请教一个查询语句
- 如何检索存储过程或包中的匹配字段?
- pl/sql中的 function 能否嵌套使用?
- linux下执行oracle的dbstart,提示Can't find init file for Database "guandadb".
- 数据库将查询出来的数据作为字段名
- 数据表的拆分???? 麻烦大家帮我看看哪种设计更合理
- ****关于分区表建立的问题!**** “未启用功能:Partitioning“?:(
- 哎。sql*load
- Oracle SQL Developer问题
服务器端host不要用IP,一旦IP改变,客户端配置还得改,用主机名。
这边测试成功了,说明服务已经正确运行了,PB不行,应该从PB那边找问题,你别纠缠在服务这边!
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hpserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)