不知怎么搞的,Oracle数据库启动不起来了,我用Navicat Lite连接数据库出现错误:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
。 我用SQL Plus输入用户名密码后也连不上出现错误:
ORA-12560: TNS: 协议适配器错误。
修改办法:找到 lister.ora 所在文件夹D:\ORACLE\server\product\11.2.0\dbhome_2\NETWORK\ADMIN,在此文件中加入:
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\ORACLE\server\product\11.2.0\dbhome_2)
(SID_NAME = ORCL)
)
加入后的文件内容如下:
# listener.ora Network Configuration File: D:\ORACLE\server\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\ORACLE\server\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\ORACLE\server\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\ORACLE\server\product\11.2.0\dbhome_2)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\ORACLE\server
俩小时啊,就这么没了。