晚上回家,打开oracle服务一切正常,可程序访问数据库时总是报该数据不存在,我就想用PL/SQL Developer查看下是否数据被我不小心给删了,可用该用户登录时就报了:ORA-12514:TNS: 监听程序无法识别连接描述符中请求的服务;于是查看了下2个监听都正常启动了,于是用sqlplus命令来登录结果发现能正常登录,得出一个结论就是应该是listener.ora的问题。
修改如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle) --sid号
(ORACLE_HOME = D:\oracle\oracle) --oracle安装的路径
(SID_NAME = oracle) --sid号
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
问题解决
修改如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle) --sid号
(ORACLE_HOME = D:\oracle\oracle) --oracle安装的路径
(SID_NAME = oracle) --sid号
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
问题解决