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 startup monitoring error: The listener supports no services solution

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Oracle startup monitoring error: The listener supports no services solution

And ora-12514 is not registered with the service.

After the Oracle11g server restarts the system, there are several inexplicable errors. Here is one of them that has been resolved.

$lsnrctl start

Error prompt: The listener supports no servicesThe command completed successfully

In this way, the remote connection will report an error after startup: oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor problem: the database instance is not registered with listener

Solution 1: add a line to the listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(SID_NAME = orcl)

)

)

Note: the orcl in it is determined according to the database instance name you installed. I used this method to solve this error.

Solution 2: log in to the database:

$sqlplus / as sysdba

Display the service name:

SQL > show parameter service_names

Compulsory registration service:

SQL > alter system register

View the monitoring status:

$lsnrctl status

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: 281

*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