The listener supports no services appears in the Oracle startup listener

There are several solutions: the first one. restart the server to fix the listener. log on to the database, sqlplus/As sysdba; SQL> shudownsql> startup # startup start # shutdown to close # LSNRCTL stop to close the service, execute close listener # LSNRCTL start and then start the listener. exit the command line and check the listener status LSNRCTL statlsnrctl for Linux: Version 10.2.0.1.0-production on 17-7 month-2010 18: 51: 36 copyright (c) 1991,200 5, Oracle. all rights reserved. connecting to (address = (Protocol = TCP) (host =) (Port = 1521) Status of the listener -------- alias liste Nerversion tnslsnr for Linux: Version 10.2.0.1.0-productionstart date 17-7 month-2010 10: 51: 00 uptime 0 days 8 hr. 0 min. 36 sectrace level offsecurity on: Local OS authenticationsnmp offlistener log file/Oracle/product/10.2.0/Network/log/listener. loglistening endpoints Summary... (Description = (address = (Protocol = TCP) (host = localhost. localdomain) (Port = 1521) Services Summary... Service "Oracle" has 1 instance (s). instance "Oracle", status ready, has 1 handler (s) for this service... Service "oraclexdb" has 1 instance (s). instance "Oracle", status ready, has 1 handler (s) for this service... Service "oracle_xpt" has 1 instance (s). instance "Oracle", status ready, has 1 handler (s) for this service... The command completed successfully type 2. modify listener. ora and tnsname. ora file. # listener. ora network configuration file: Oracle/Network/admin/listener. ora # tnsnames. ora network configuration file:/Oracle/oraclenetwork/admin/tnsnames. oralistener. ora: sid_list_listener = (sid_list = (sid_desc = (sid_name = Oracle) (ORACLE_HOME = Oracle/Oracle) (program = EXTPROC) tnsname. ora: Listener = (description_list = (description = (address = (Protocol = IPC) (Key = extproc1) (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521) bobjecms = (description = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = Oracle) Oracle = (description = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = Oracle) extproc_connection_data = (description = (address_list = (address = (Protocol = IPC) (Key = extproc1) (CONNECT_DATA = (SID = Oracle) (Presentation = Ro )))

There are several solutions:

First, restart the server to fix the listener.

Log on to the database, sqlplus/As sysdba; SQL> shudownsql> startup

# Startup start # shutdown close # After LSNRCTL stop closes the service, execute the close listener # LSNRCTL start and then start the listener.

Exit the command line and check the listener status LSNRCTL stat

LSNRCTL for Linux: Version 10.2.0.1.0-production on 17-7 month-2010 18:51:36

Copyright (c) 1991,200 5, Oracle. All rights reserved.

Connecting to (address = (Protocol = TCP) (host =) (Port = 1521) Status of the listener -------- alias listenerversion tnslsnr for Linux: version 10.2.0.1.0-productionstart date 17-7 month-2010 10: 51: 00 uptime
0 days 8 hr. 0 min. 36 sectrace level offsecurity on: Local OS authenticationsnmp offlistener log file/Oracle/product/10.2.0/Network/log/listener. loglistening endpoints Summary... (Description = (address = (Protocol = TCP) (host = localhost. localdomain) (Port = 1521) Services
Summary... Service "Oracle" has 1 instance (s). instance "Oracle", status ready, has 1 handler (s) for this service... Service "oraclexdb" has 1 instance (s). instance "Oracle", status ready, has 1 handler (s) for this service... Service "oracle_xpt" has 1 instance (s). Instance
"Oracle", status ready, has 1 handler (s) for this service... The command completed successfully

Second, modify the listener. ora and tnsname. ora files.

# Listener. ora network configuration file: Oracle/Network/admin/listener. ora # tnsnames. ora network configuration file:/Oracle/oraclenetwork/admin/tnsnames. ora

Listener. ora:

Sid_list_listener = (sid_list = (sid_desc = (sid_name = Oracle) (ORACLE_HOME = Oracle/Oracle) (program = EXTPROC )))

Tnsname. ora:

Listener = (description_list = (description = (address = (Protocol = IPC) (Key = extproc1) (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521 ))))

Bobjecms = (description = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = Oracle )))

Oracle = (description = (address = (Protocol = TCP) (host = 127.0.0.1) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = Oracle )))

Extproc_connection_data = (description = (address_list = (address = (Protocol = IPC) (Key = extproc1) (CONNECT_DATA = (SID = Oracle) (Presentation = Ro )))