Accessing listener from second instance
Hello,
Oracle Version:
Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production
Version 18.7.0.0.0
29757256 APPLY SUCCESS Database Release Update : 18.7.0.0.190716 (29757256)
29774410 APPLY SUCCESS OJVM RELEASE UPDATE: 18.7.0.0.190716 (29774410)
Two instances on one host:
orcl:/opt/app/oracle/product/18.0.0/dbhome_1:Y
oratest:/u01/app/oracle/product/18.0.0/dbhome_2:Y
lsnrctl status showed services only for production instance. There was no services for test thought it was running.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_ORCL <= production settings
local_listener string LISTENER_ORATEST <= test settings
when I changed local_listener on test instance to following it started to show services correctly.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------