Hi,
I'm having some trouble configuring multiple listeners for an Oracle 11g database.
I've tried setting it up in multiple ways, but i can't get the instance to listen on the other hostname.
Local_listener is set to orcl, which is reflected in tnsnames.
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname1>)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname2>)(PORT = 1522))
(CONNECT_DATA =
(SERVICE_NAME = orcl.<hostname>)
(INSTANCE_NAME = orcl)
)
)
what am i missing?