oracle 10g配置客户端时,测试连接出现错误(Net Configuration Assistant -- 本地Net服务名配置):
ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务
随后打开:
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\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)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC20120520)(PORT = 1522))
)
)
其中PORT = 1522,不是常见的1521,因为,该PC上安装了oracle9i和oracle10g,oracle10的端口自动设置为1522了。
在填写端口的时候写1522,测试成功。