TNS-12541,TNS-12560,TNS-00511,TNS-12542,TNS-12560,TNS-00512 Database Start monitoring error

1th. Database Server Monitoring Error

1.1.1 Database Listener Error

1.1.1.1 Problems and phenomena

The server environment is ORACLE11G RAC Environment, after the system starts, the listener is not up.

[Email protected] ~]$ lsnrctl status
Lsnrctl for linux:version 11.2.0.3.0-production on 29-jun-2015 10:44:45
Copyright (c) 1991, 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 Inspection Ideas

at that time, colleagues have checked the CRS, also tried to use the command to start monitoring and other steps. But when you start monitoring, there will be the following error .

[[email protected] ~]$ lsnrctl start
Lsnrctl for linux:version 11.2.0.3.0-production on 29-jun-2015 10:51:46
Copyright (c) 1991, 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) above ...

Actually say the system has been used, then take it for granted to see the 1521 port and LSN processes

[Email protected] ~]# Ps-ef | grep LSN

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

Root 101600 100759 0 22:30 pts/0 00:00:00 grep LSN

[[Email protected] ~] #netstat-ANP | grep 1521

TCP 0 0xxx.xxx.xxx.xxx:1521 0.0.0.0:* LISTEN 52181/tnslsnr (some inconvenience listed)

found that 1521 ports and/u01/11.2.0/grid/bin/tnslsnrlistener_scan1-inherit processes exist, so try to kill this process

[[Email protected] ~] #kill-9 52181

-bash:kill: (52181)-No suchprocess

After killing found that the system prompts for no such process, query again

[Email protected] ~]# Ps-ef |grep LSN

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

Root 104379 104353 0 23:28 pts/0 00:00:00 grep LSN

Again, it should be that the parent process is automatically started again, to see that its parent process is the INIT process.

[[Email protected] ~] $pstree 1

Init─┬─mbadatamover───mbadatamover───mbadatamover

├─2*[tnslsnr───2*[{tnslsnr}]]

1.1.1.3 the cause of the problem

Because I remember seeing in the book that Srvctl in a 11G RAC can manage listening, so try using this command to start listening.

1.1.1.4 Workaround

[[Email protected] ~] $srvctl start Listener-n RAC4

[Email protected]~]$ exit

Logout

[[Email protected]~]# su-oracle

[[Email protected]~] $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. Min. 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 the This service ...

Service "RAC3" has 1 instance (s).

Instance "RAC32", status Ready, HAS1 handler (s) for the This service ...

Service "Rac3xdb" has 1 instance (s).

Instance "RAC32", status Ready, HAS1 handler (s) for the This service ...

Service "RACDB007" has 1 instance (s).

Instance "RACDB0072", status Ready, HAS1 handler (s) for the This service ...

Service "RACDB007JL_BJ" has 1 instance (s).

Instance "Racdb007jl2", Status Ready,has 1 handler (s) for the This service ...

Service "Racdb007jl_bjxdb" has 1 instance (s).

Instance "Racdb007jl2", Status Ready,has 1 handler (s) for the This service ...

Service "Racdb007xdb" has 1 instance (s).

Instance "RACDB0072", status Ready, HAS1 handler (s) for the This service ...

The commandcompleted successfully

1.1.1.5 Knowledge points

After solving this problem, it is found that many functions of the Oracle 11G RAC are controlled by the cluster command, but not single-machine management to control some functions of the cluster.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

TNS-12541,TNS-12560,TNS-00511,TNS-12542,TNS-12560,TNS-00512 Database Start monitoring error