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

The following error message occurred when starting monitoring and the service could not be found. The error message is as follows:

[oracle@dg1 admin] $lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 18-NOV-2016 11:17:54

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROC1521)

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0-Production

Start Date 18-NOV-2016 11:15:22

Uptime 0 days 0 hr. 2 min. 31 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File / u01/product/11.2.0.1/db_1/network/admin/listener.ora

Listener Log File / u01/diag/tnslsnr/dg1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=dg1) (PORT=1521))

The listener supports no services

The command completed successfully

[oracle@dg1 admin] $

Solution 1:

[oracle@dg1 admin] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 18 11:19:06 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL > startup

Total System Global Area 830930944 bytes

Fixed Size 2217912 bytes

Variable Size 545261640 bytes

Database Buffers 281018368 bytes

Redo Buffers 2433024 bytes

Database mounted.

Database opened.

SQL > show parameter service_names

NAME TYPE VALUE

-

Service_names string tong

SQL > alter system register;-- forcibly register listening

System altered.

SQL >

[oracle@dg1 admin] $lsnrctl start-start snooping

Solution 2:

[oracle@dg2 ~] $vim / u01/product/11.2.0.1/db_1/network/admin/listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = dg2) (PORT = 1521))

)

)

SID_LIST_LISTENER =-- add the following line

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(SID_NAME = orcl)

)

)

ADR_BASE_LISTENER = / U01

[oracle@dg2 ~] $lsnrctl start

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.