| one ip address..two listeners and two db instances [message #540722] |
Wed, 25 January 2012 08:01  |
 |
al_from_indiana
Messages: 6
Registered: January 2012
|
Junior Member |
|
|
Is it possible to setup two listeners for two db instances on one server with a single IP address? I search everywhere and could not find any information about this type of configuration.
The error I'm getting when attempting to start the second listener after the first listener is up:
TNS-01150: The address of the specified listener name is incorrect
|
|
|
|
|
|
| Re: one ip address..two listeners and two db instances [message #540729 is a reply to message #540724] |
Wed, 25 January 2012 08:15  |
|
al_from_indiana
Messages: 6
Registered: January 2012
|
Junior Member |
|
|
Hi John,
Thanks for your reply. Here's a copy of my listener.ora file:
DB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.34)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_DB1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = BOOTDB1)
(ORACLE_HOME = /oracle/app/oracle/product/10.2.0.1)
)
)
DB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.34)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2)
)
)
)
SID_LIST_DB12 =
(SID_LIST =
(SID_DESC =
(SID_NAME = DB2)
(ORACLE_HOME = /oracle/app/oracle/product/10.2.0.1)
)
)
[Updated on: Wed, 25 January 2012 08:18] Report message to a moderator |
|
|
|
| Re: one ip address..two listeners and two db instances [message #540731 is a reply to message #540729] |
Wed, 25 January 2012 08:22 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Next time, please enclose file listings in code tags, like this:
DB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.34)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_DB1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = BOOTDB1)
(ORACLE_HOME = /oracle/app/oracle/product/10.2.0.1)
)
)
DB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.34)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2)
)
)
)
SID_LIST_DB12 =
(SID_LIST =
(SID_DESC =
(SID_NAME = DB2)
(ORACLE_HOME = /oracle/app/oracle/product/10.2.0.1)
)
)
Your syntax is wrong, you should have one ADDRESS_LIST within the DESCRIPTION that contains both your TCP listening address and your IPC listening address.
Two processes listening on the same IP adderss must each use a different port, you are trying to run both listeners on port 1521.
[update: I see you've added the code tags! Everyone will love you now.]
[Updated on: Wed, 25 January 2012 08:23] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: one ip address..two listeners and two db instances [message #540751 is a reply to message #540750] |
Wed, 25 January 2012 09:24 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
come on, BS! You are right of course, but listeners aren't really doing anything most of the time.
And Al, you still haven't placed both the addresses within the address_list. And you have written SID_LIST_DB12 where I assume you mean SID)LIST_DB2. You might want to get rid of that file entirely, and use the netmgr tool to create a new one. It will save you a lot of stupid mistakes.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
