今天安装ORACLE11G数据库，装好数据库后发现无法登录，一直提示
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
经过检查发现，监听文件里只有以下内容
经过检查发现，监听文件里只有以下内容
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.150)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.150)(PORT = 1521))
)
ADR_BASE_LISTENER = E:\app\Administrator\product\11.2.0\dbhome_1\log
需要添加
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = xxxx)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = xxxx)
)
(SID_DESC =
(GLOBAL_DBNAME = xxxx)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = xxxx)
)
)
(SID_LIST =
(SID_DESC =
(SID_NAME = xxxx)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = xxxx)
)
(SID_DESC =
(GLOBAL_DBNAME = xxxx)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = xxxx)
)
)
以上内容注册监听，问题解决。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/518723/viewspace-677942/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
