Version : 11.2.0.2
OS : AIX
We have five 11.2 DBs running in a server. One 11.2 listener (on non-default port) serves all these five DBs. The name of the listener is
LSNRJK11G
But when I log in to any of these DBs and query the LOCAL_LISTENER parameter, the value appears as
listener_<dbname>
For example, if i login to a DB named facdb, I get the below
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string listener_facdb
Why is the listener name different here ?
When I asked my colleague who configure this , he said when he tried with the real listener name using
alter system set local_listener = 'lsnrjk11g' scope = both;
he got some error. He doesn't remember what error it was
Edited by: Kavanagh on Dec 15, 2011 12:16 AM