一、问题描述
启动oracle监听程序时报如下错误,The listener supports no services
二、原因分析
数据库实例没注册到listener
三、处理过程
在listener.ora里面添加了红色标记的代码,具体如下:
[oracle@oracle11g admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ) ) ADR_BASE_LISTENER = /u01/app/oracle