Home » RDBMS Server » Networking and Gateways » Two listeners up
Two listeners up [message #246431] Wed, 20 June 2007 22:27 Go to next message
akshatmadan_101
Messages: 3
Registered: June 2007
Junior Member
Hi,

I have Oracle 10g installed with one instance and one database. Two days back I had problems connecting to the database through PL-Sql developer (though I was able to connect to it before easily )but I could easily connect to it logging into the server through putty. So I checked out the status of the listener and found error :Address already in use . I found out two listeners were up at the same time one on Feb 06 and another on 18 June . Though I didn't started a new listener on 18 June . What can be the problem ? How did the second listener started automatically?
Re: Two listeners up [message #246461 is a reply to message #246431] Thu, 21 June 2007 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Server OS?

Regards
Michel

[Updated on: Thu, 21 June 2007 01:07]

Report message to a moderator

Re: Two listeners up [message #246706 is a reply to message #246461] Thu, 21 June 2007 11:49 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
whats the listening ports for both listener??
Re: Two listeners up [message #246733 is a reply to message #246431] Thu, 21 June 2007 13:11 Go to previous messageGo to next message
akshatmadan_101
Messages: 3
Registered: June 2007
Junior Member
Hi
The OS is Linux x86 and both port numbers were 1521

Re: Two listeners up [message #246735 is a reply to message #246431] Thu, 21 June 2007 13:15 Go to previous messageGo to next message
akshatmadan_101
Messages: 3
Registered: June 2007
Junior Member
Hi the OS is Linux x86 (10.2.0.1.0 )and the port numbers were 1521 .

I tried to check the status of listener and i got the error :

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer


Then I tried to stop the listener I got same error :

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer


I found listener.log file was more than 2 GB . So I deleted the file .

Then i got following error using cat
# cat listener.log
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

See the below :
$ ps aux | grep oracle
oracle 17287 0.0 0.0 42116 6036 ? Ssl Feb06 9:01 /opt/oracle/product/10.2.0/bin/tnslsnr LISTENER -inherit
oracle 17751 0.0 0.0 42116 6040 ? S Jun18 0:00 /opt/oracle/product/10.2.0/bin/tnslsnr LISTENER -inherit

The above shows that two listenes were up . So we killed both the listeners and resolved the issue .

Can anyone please tell how did the second listener started by itself ?

Re: Two listeners up [message #246736 is a reply to message #246431] Thu, 21 June 2007 13:17 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
AFAIK, you can NOT have two listeners listening on the same port.
If you try to start the 2nd listener on the same port, you'll get the following error.
TNS-01106: Listener using listener name LISTENER has already been started
Previous Topic: Transparent Gateway for DB2 - older version
Next Topic: tnsnames and a domain name
Goto Forum:
  


Current Time: Thu Mar 28 05:47:04 CDT 2024