Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle configuration monitoring Times error TNS-01150: listener name is incorrect

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

When configuring Oracle snooping, it was encountered that cannot start snooping.

[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...

Edit 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))

)

)

Correction: [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))

)

)

Finally, the startup is successful!

Key: when configuring monitoring, you need to get the format right, otherwise you can't recognize the monitoring name.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report