Home » RDBMS Server » Networking and Gateways » Bind 1 Listener on 2 Interfaces (Oracle 10g)
Bind 1 Listener on 2 Interfaces [message #481679] Fri, 05 November 2010 04:47 Go to next message
ManinBlack
Messages: 6
Registered: November 2010
Junior Member
Hello all together,

I have a question:
Is it possible to bind an Oracle Listener on 2 different interfaces on the same host?

My initial situation:
I've set up a new VLAN in eth1.8 on our database server.
There are 2 Oracle instances on this host.
One instance was set up for the new VLAN, this works fine.
The other listener stayed in the old network, because an other customer also needs to access this instance.

Now the customer wo was set up for 2 new VLAN can't access the other instance listenig on the interface eth0.

In short I have the following setup:
customer1: eth0
customer2: eth1.8 (VLAN)

listener1: LST1
listener2: LST2

SSID1: SID1
SSID2: SID2

listener1 is listening on eth0 for SID1
listener2 is listening on eth1.8 for SID2
This works fine.

Now customer2 needs to access SID1, which is configured on eth0, but customer2 is configured for eth1.8

So I need a listener for SID2, that is configured for both interfaces eth0 AND eth1.8.

I hope you all know what I meen.

Kind regards
Sascha
Re: Bind 1 Listener on 2 Interfaces [message #481694 is a reply to message #481679] Fri, 05 November 2010 05:50 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
No problem. listener.ora:
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )
Re: Bind 1 Listener on 2 Interfaces [message #481695 is a reply to message #481694] Fri, 05 November 2010 05:52 Go to previous messageGo to next message
ManinBlack
Messages: 6
Registered: November 2010
Junior Member
I tested this already, but den the following error appears:

Quote:

oracle@laren:~> lsnrctl start LISTENER1

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 05-NOV-2010 11:11:26

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /opt/oracle/product/10.2/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /opt/oracle/product/10.2/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1524)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1524)))
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...
Re: Bind 1 Listener on 2 Interfaces [message #481697 is a reply to message #481695] Fri, 05 November 2010 05:57 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
That's because you haven't shut down the listener that is already listening on that addreess:port. You'll have to decide whether you want one listener, or two. Oracle Corp wants you to have one only, running off your ASM home. This becomes more important when you upgrade to 11.2.
Re: Bind 1 Listener on 2 Interfaces [message #481698 is a reply to message #481697] Fri, 05 November 2010 06:02 Go to previous messageGo to next message
ManinBlack
Messages: 6
Registered: November 2010
Junior Member
Thank you, I thought I've shut down it already, but I will try it again later.
Actually other users are using the Connection.
Re: Bind 1 Listener on 2 Interfaces [message #481906 is a reply to message #481698] Mon, 08 November 2010 04:29 Go to previous messageGo to next message
ManinBlack
Messages: 6
Registered: November 2010
Junior Member
So I'm back again.

I've tested the suggested idea, but it doesn't work for our configuration.
The error was the following:
Quote:

oracle@laren:~> lsnrctl start LISTENER

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 08-NOV-2010 11:23:30

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /opt/oracle/product/10.2/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /opt/oracle/product/10.2/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2/db_1/network/log/listener2.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=[server])(PORT=1524)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[server2])(PORT=1524)))
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...


With this listener.ora, none of the two listeners will start.
I've changed it back now, but I want to get it worked.

I hope you can help me again.

Kind regards
Sascha

[Updated on: Mon, 08 November 2010 04:30]

Report message to a moderator

Re: Bind 1 Listener on 2 Interfaces [message #481938 is a reply to message #481906] Mon, 08 November 2010 08:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I've changed it back now, but I want to get it worked.
So exactly what do you have now & what down "I want to get it worked" mean?
Re: Bind 1 Listener on 2 Interfaces [message #481953 is a reply to message #481938] Mon, 08 November 2010 10:00 Go to previous messageGo to next message
ManinBlack
Messages: 6
Registered: November 2010
Junior Member
actually I have a one listener running, because the customer needs to work on the system.

What I want is that the listener listens on 2 interfaces as described above.
This is what I mean with "I want to get it worked".
Re: Bind 1 Listener on 2 Interfaces [message #481958 is a reply to message #481697] Mon, 08 November 2010 10:54 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
John Watson wrote on Fri, 05 November 2010 05:57
That's because you haven't shut down the listener that is already listening on that addreess:port. You'll have to decide whether you want one listener, or two. Oracle Corp wants you to have one only, running off your ASM home. This becomes more important when you upgrade to 11.2.

Re: Bind 1 Listener on 2 Interfaces [message #482018 is a reply to message #481958] Tue, 09 November 2010 02:27 Go to previous messageGo to next message
ManinBlack
Messages: 6
Registered: November 2010
Junior Member
The listener was shut down.

But my guess is, that all listeners has to be shut down. Is that true?
For your information: There are about 9 listeners on this Oracle-Sever.
Re: Bind 1 Listener on 2 Interfaces [message #482073 is a reply to message #482018] Tue, 09 November 2010 06:23 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
This is getting repetitive! The error message is clear: there is already a process listening on that port. It is almost certainly one of your database listeners. If you don't know what it is, run
netstat -p
to identify the process, and kill it.
I can't suggest anything else.
Re: Bind 1 Listener on 2 Interfaces [message #483652 is a reply to message #482073] Tue, 23 November 2010 22:15 Go to previous messageGo to next message
Linajane
Messages: 2
Registered: November 2010
Junior Member

many thanks for the help guys!!
Have a nice day,..God bless!!

Cheerz'z'z'
Re: Bind 1 Listener on 2 Interfaces [message #483659 is a reply to message #483652] Wed, 24 November 2010 00:34 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.
Please, read OraFAQ Forum Guide and post in as correct english as you can.

Regards
Michel
Previous Topic: controlling database access
Next Topic: Listener die intermittantly after TNS error and Cause segmentation fault
Goto Forum:
  


Current Time: Fri Mar 29 08:53:56 CDT 2024