HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

TNS-12541 Error

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
12541errortns

Problem

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check the status first then here is what is shows if you try LSNRCTL STATUS. I followed following url but it did not work for me :
Linux Error: 111: Connection refused LSNRCTL

My question is how should I make the listener run automatically?

Please check the necessary required information below : -

[grid@netsystemsolution ~]$ lsnrctl status    
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-JAN-2015 12:01:56
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=netsystemsolution[dot]com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused


If you check the status of the listener from crvctl then this is what it shows:

[grid@netsystemsolution ~]$ srvctl status listener 
PRCN-2044 : No listener exists
[grid@netsystemsolution ~]$ srvctl config listener
PRCN-2044 : No listener exists
[grid@netsystemsolution ~]$


Host information:

```
[root@netsystemsolution ~]# vi /etc/hosts
192.168.0.1 netsystemsolution[dot]com localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
[root@netsystemsolution ~]# hostname
netsystemsolution [dot]com
[root@netsystemsolution ~]# ping netsystemsolution[dot]com
PING netsystemsolution[dot]com (192.168.0.1) 56(84) bytes of data.
64 bytes from netsystemsolution[dot]com (192.168.0.1): icmp_seq=1 ttl=64 time=0.033 ms
64 bytes from netsystemsolution[dot]com (192.168.0.1): icmp_seq=2 ttl=64 time=0.034 ms
64 bytes from netsystemsolution[dot]com (192.168.0.1): icmp_seq=3 ttl=64 time=0.042 ms
--- netsystemsolution[dot]com ping statistics ---
6 packets transmitted, 6 received, 0% packet loss, time 552

Solution

The easiest way to register your listener at Oracle Grid Infrastructure is to run netca. If you want to configure the listener "LISTENER" you have to make sure that it does not exist in the listener.ora yet.

One more thing: You should always configure your own host in the /etc/hosts file.

Context

StackExchange Database Administrators Q#87397, answer score: 2

Revisions (0)

No revisions yet.