Oracle配置监听时报错TNS-01150: listener name is incorrect
在配置Oracle监听时遇到不能启动监听
编辑listener.ora
最后启动成功！
关键：在配置监听时，需要把格式对好，否则不能识别监听名字
[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
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.
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))
)
)
(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))
)
)
改正：
(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.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))
)
)
(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))
)
)
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=enmoedu1)(PORT=1522))
)
)
最后启动成功！
关键：在配置监听时，需要把格式对好，否则不能识别监听名字
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31536355/viewspace-2156402/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
虚拟机仅主机模式连接外网
请登录后发表评论
登录
全部评论
