What are the advantages of using an alias for local_listener
From: <trevor.williams_at_rac.com.au>
Date: Tue, 26 Aug 2008 16:42:52 -0700 (PDT)
Message-ID: <b2c0ccec-8646-4108-aa19-0c3edbd359a3@1g2000pre.googlegroups.com>
Date: Tue, 26 Aug 2008 16:42:52 -0700 (PDT)
Message-ID: <b2c0ccec-8646-4108-aa19-0c3edbd359a3@1g2000pre.googlegroups.com>
I have used (for example)
local_listener = '(ADDRESS = (PROTOCOL =TCP)(HOST=themis.sbd.com.au)
(PORT=1537))'
which seems to work fine. When I used dbua to upgrade to 10.2.0.4 it
converted this to
local_listener = LISTENER_CYCLTEST
and added to tnsnames.ora:
LISTENER_CYCLTEST.SBD.COM.AU =
(ADDRESS = (PROTOCOL = TCP)(HOST = themis.sbd.com.au)(PORT = 1537))
What are the advantages of local_listener=lsnr_alias? Isn't the fact that there are two places requiring configuration rather than just one a probable disadvantage? Is it worth changing the config of other instances to use local_listener = lsnr_alias?
~trevor Received on Tue Aug 26 2008 - 18:42:52 CDT