Monitoring startup reports TNS-12537, TNS-12560 Error

Monitoring startup reports TNS-12537, TNS-12560 Error

Environment Description:

OS: CentOS 6.5

DB: Oracle 11.2.0.3

Problem: the following error is reported when the database starts the listener:

[Oracle @ localhost admin] $ lsnrctl start

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 27-NOV-2015 08:44:40

Uptime 0 days 0 hr. 0 min. 18 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File/ora01/app/oracle/product/11.2.0/db_01/network/admin/listener. ora

Listener Log File/ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log. xml

Listening Endpoints Summary...

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

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

TNS-12537: TNS: connection closed

TNS-12560: TNS: protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

Solution:

1. Modify the host name. The default host name is localhost when installing the system. Many strange problems may occur when parsing the host name. We strongly recommend that you remember to modify the host name;

2. Modify the/etc/hosts file

[Root @ localhost tmp] # cat/etc/hosts

127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4

: 1 localhost. localdomain localhost6 localhost6.localdomain6

192.168.1.100 dbtest001

After the above operations, start the listener again

[Oracle @ dbtest001 ~] $ Lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 27-NOV-2015 09:21:55

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

Starting/ora01/app/oracle/product/11.2.0/db_01/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0-Production

System parameter file is/ora01/app/oracle/product/11.2.0/db_01/network/admin/listener. ora

Log messages written to/ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log. xml

Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))

Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.26) (PORT = 1521 )))

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 27-NOV-2015 09:21:55

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File/ora01/app/oracle/product/11.2.0/db_01/network/admin/listener. ora

Listener Log File/ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log. xml

Listening Endpoints Summary...

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

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

The listener supports no services

The command completed successfully

The listener has been started.