qq_33906002 2016-11-23 05:34 采纳率: 30%
浏览 2362

oracle11g配置监听(centos7下)

按照一般流程配置完成了,我先在1号终端启动监听lsnrctl start,再打开另一个终端,sqlplus /nolog打开服务器,再输入 conn sys@orcl001 as sysdba,想连接,但是出现提示:
TNS:listener does not currently know of service requested in connect
descriptor(侦听器目前不知道连接中请求的服务描述符)!!
于是我又 alter system register;(实例注册),又提示 Not connected(没有连接)!!
我又到1号终端,查看监听状态,提示The listener supports no services(侦听器不支持服务)!!!,我又重启监听和服务器,还是不行,还是以上提示!!!!
求大神~!帮助~!!
一下是配置文件:
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(GLOBAL_DBNAME =ORCL)
(ORACLE_HOME =:/data/oracle/product/11.2.0/db_1)
(SID_NAME = ORCL)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)

tnsnames.ora
ORCL001 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl11g)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)

  • 写回答

1条回答

  • zqbnqsdsmd 2017-02-21 18:53
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料
  • ¥15 使用R语言marginaleffects包进行边际效应图绘制
  • ¥20 usb设备兼容性问题
  • ¥15 错误(10048): “调用exui内部功能”库命令的参数“参数4”不能接受空数据。怎么解决啊
  • ¥15 安装svn网络有问题怎么办
  • ¥15 vue2登录调用后端接口如何实现