Oracle配置监听时报错TNS-01150: listener name is incorrect

发布时间:2020-08-11 02:41:51 作者:yhluffy
来源:ITPUB博客 阅读:494
在配置Oracle监听时遇到不能启动监听
[oracle@enmoedu1 admin]$ lsnrctl start lsnr1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JUN-2018 20:11:52
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/enmoedu1/lsnr1/alert/log.xml
TNS-01150: The address of the specified listener name is incorrect
Listener failed to start. See the error message(s) above...


编辑listener.ora
[oracle@enmoedu1 admin]$ vi listener.ora
LSNR1=
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome
_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = enmoedu1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
ADR_BASE_LISTENER = /u01/app/oracle
LSNR1=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=enmoedu1)(PORT=1522))
)
)

改正:
[oracle@enmoedu1 admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome
_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = enmoedu1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
ADR_BASE_LISTENER = /u01/app/oracle
LSNR1=
  (DESCRIPTION=
     (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=enmoedu1)(PORT=1522))
     )
   )

最后启动成功!

关键:在配置监听时,需要把格式对好,否则不能识别监听名字
推荐阅读:
  1. 使用Myeclipse怎么链接Oracle数据库
  2. 怎么在oracle存储过程返回结果集

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

oracle 监听 tns-01150

上一篇:小程序Cannot set property 'userInfo' of undefined

下一篇:Win10系统如何开启护眼模式

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》