OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Two listeners up

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Two listeners up [message #246431]

Wed, 20 June 2007 22:27

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?

Report message to a moderator

Re: Two listeners up [message #246461 is a reply to message #246431]

Thu, 21 June 2007 01:07

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

whats the listening ports for both listener??

Report message to a moderator

Re: Two listeners up [message #246733 is a reply to message #246431]

Thu, 21 June 2007 13:11

akshatmadan_101
Messages: 3
Registered: June 2007

Junior Member

Hi
The OS is Linux x86 and both port numbers were 1521

Report message to a moderator

Re: Two listeners up [message #246735 is a reply to message #246431]

Thu, 21 June 2007 13:15

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 ?

Report message to a moderator

Re: Two listeners up [message #246736 is a reply to message #246431]

Thu, 21 June 2007 13:17

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

Report message to a moderator

Previous Topic:	Transparent Gateway for DB2 - older version
Next Topic:	tnsnames and a domain name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 09:02:29 CST 2025