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 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)
  • ¥20 matlab yalmip kkt 双层优化问题
  • ¥15 如何在3D高斯飞溅的渲染的场景中获得一个可控的旋转物体
  • ¥88 实在没有想法,需要个思路
  • ¥15 MATLAB报错输入参数太多