TNS-12541, TNS-12560, TNS-00511, TNS-12542, TNS-12560, TNS-00512 database boot listener Error

TNS-12541, TNS-12560, TNS-00511, TNS-12542, TNS-12560, TNS-00512 database boot listener Error
 

Chapter 4 Database Server listener errors

1.1.1 database listening Error

1.1.1.1 problems and phenomena

The server environment is ORACLE11G RAC. After the system is started, the listener fails.

[Oracle @ RAC4 ~] $ Lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 29-JUN-2015 10:44:45
Copyright (c) 1991,201 1, Oracle. All rights reserved.

Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

1.1.1.2 check ideas

 

At that time, my colleague had checked the CRS and tried to use commands to start the listener. However, when the listener is started, the following error occurs:.

 

[Oracle @ RAC4 ~] $ Lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 29-JUN-2015 10:51:46
Copyright (c) 1991,201 1, Oracle. All rights reserved.
Starting/u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0-Production
Log messages written to/u01/app/oracle/diag/tnslsnr/RAC4/listener/alert/log. xml
Error listening on: (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
TNS-12542: TNS: address already in use
TNS-12560: TNS: protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use

Listener failed to start. See the error message (s) abve...

 

If the system is in use, you should check port 1521 and the lsn process.

 

[Root @ RAC4 ~] # Ps-ef | grep lsn

Grid 52181 1 0 :04? 00:00:11/u01/*/bin/tnslsnrLISTENER_SCAN1-inherit

Root 101600 100759 0 00:00:00 pts/0 grep lsn

[Root @ RAC4 ~] # Netstat-anp | grep 1521

Tcp 0 0xxx. xxx: 1521 0.0.0.0: * LISTEN 52181/tnslsnr (some content cannot be listed)

 

Port 1521 and the/u01/11.2.0/grid/bin/tnslsnrLISTENER_SCAN1-inherit process are found, so try to kill this process

 

[Root @ RAC4 ~] # Kill-9 52181

-Bash: kill :( 52181)-No suchprocess

 

After the process is killed, the system prompts that the process does not exist. query the process again.

 

 

[Root @ RAC4 ~] # Ps-ef | grep lsn

Grid 104147 1 0 23:23? 00:00:00/u01/*/bin/tnslsnrLISTENER_SCAN1-inherit

Root 104379 104353 0 00:00:00 pts/0 grep lsn

 

Again, the parent process is automatically started again, and the parent process is the init process.

 

[Grid @ RAC4 ~] $ Pstree 1

Init-upload-MBADataMover ── MBADataMover

Listen-2 * [tnslsnr ── 2 * [{tnslsnr}]

 

 

 

1.1.1.3 cause of the problem

 

As I remember seeing in the book that SRVCTL in the 11g RAC can manage the listener, I tried to use this command to start the listener.

 

1.1.1.4 Solution

[Grid @ RAC4 ~] $ Srvctl start listener-n RAC4

 

[Grid @ RAC4 ~] $ Exit

Logout

[Root @ RAC4 ~] # Su-oracle

[Oracle @ RAC4 ~] $ Lsnrctl status;

 

LSNRCTLfor Linux: Version 11.2.0.3.0-Production on 01-JUL-2015 11:32:45

 

Copyright (c) 1991,2011, Oracle. All rightsreserved.

 

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

STATUSof theLISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version11.2.0.3.0-Production

StartDate 01-JUL-2015 10:38:57

Uptime 0 days 0 hr. 53 min. 47 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameterFile/u01/11.2.0/grid/network/admin/listener. ora

ListenerLogFile/u01/app/oracle/diag/tnslsnr/RAC4/listener/alert/log. xml

ListeningEndpointsSummary...

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

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

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

ServicesSummary...

Service "+ ASM" has 1 instance (s ).

Instance "+ ASM2", status READY, has1 handler (s) for this service...

Service "RAC3" has 1 instance (s ).

Instance "RAC32", status READY, has1 handler (s) for this service...

Service "RAC3XDB" has 1 instance (s ).

Instance "RAC32", status READY, has1 handler (s) for this service...

Service "RACDB007" has 1 instance (s ).

Instance "RACDB0072", status READY, has1 handler (s) for this service...

Service "RACDB007JL_BJ" has 1 instance (s ).

Instance "RACDB007JL2", status READY, has 1 handler (s) for this service...

Service "RACDB007JL_BJXDB" has 1 instance (s ).

Instance "RACDB007JL2", status READY, has 1 handler (s) for this service...

Service "RACDB007XDB" has 1 instance (s ).

Instance "RACDB0072", status READY, has1 handler (s) for this service...

The commandcompleted successfully

1.1.1.5 knowledge point

After this problem is solved, it is found that many functions of oracle 11g RAC are controlled by cluster commands, but some cluster functions cannot be controlled by single-host management.