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>

I have used (for example)
local_listener = '(ADDRESS = (PROTOCOL =TCP)(HOST=themis.sbd.com.au)

which seems to work fine. When I used dbua to upgrade to it converted this to
local_listener = LISTENER_CYCLTEST
and added to tnsnames.ora:
(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

Original text of this message