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.