| Bind 1 Listener on 2 Interfaces [message #481679] |
Fri, 05 November 2010 04:47  |
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  |
John Watson
Messages: 8962
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 |
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 |
John Watson
Messages: 8962
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 #481906 is a reply to message #481698] |
Mon, 08 November 2010 04:29 |
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 #481953 is a reply to message #481938] |
Mon, 08 November 2010 10:00 |
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 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
John Watson wrote on Fri, 05 November 2010 05:57That'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 #482073 is a reply to message #482018] |
Tue, 09 November 2010 06:23 |
John Watson
Messages: 8962
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
