hi guys,
I am trying to configure 2 entries in my listener.ora. Both databases are running on the same oracle home. (at the same time trying to configuration dataguard too)
LISTENER_ORCL
LISTENER_ORAW
tried the below configuration but i cannot seem to issue the command like:
lsnrctl start listener_orcl
lsnrctl start listener_oraw
when I issue the 2nd command it says that it has already started. what is the proper way to configure both local listener on the listener.ora ?
# listener.ora Network Configuration File: C:\app\oracle\product\19.0.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
ADMIN_RESTRICTIONS_LISTENER_ORCL = on
LISTENER_ORCL =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1522)))
STARTUP_WAIT_TIME_LISTENER_ORCL = 0
CONNECT_TIMEOUT_LISTENER_ORCL = 10
TRACE_LEVEL_LISTENER_ORCL = OFF
SID_LIST_LISTENER_ORCL =
(SID_LIST =
(SID_DESC = (SID_NAME = ORCL)(GLOBAL_DBNAME=ORCL)(ORACLE_HOME = C:\app\oracle\product\19.0.0\dbhome_1))
(SID_DESC = (SID_NAME = ORCL)(GLOBAL_DBNAME=ORCL_DGMGRL)(ORACLE_HOME = C:\app\oracle\product\19.0.0\dbhome_1))
)
ADMIN_RESTRICTIONS_LISTENER_ORAW = on
LISTENER_ORAW =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = ORAW))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORAW))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1522)))
STARTUP_WAIT_TIME_LISTENER_ORAW = 0
CONNECT_TIMEOUT_LISTENER_ORAW = 10
TRACE_LEVEL_LISTENER_ORAW = OFF
SID_LIST_LISTENER_ORAW =
(SID_LIST =
(SID_DESC = (SID_NAME = ORAW)(GLOBAL_DBNAME=ORAW)(ORACLE_HOME = C:\app\oracle\product\19.0.0\dbhome_1))
(SID_DESC = (SID_NAME = ORAW)(GLOBAL_DBNAME=ORAW_DGMGRL)(ORACLE_HOME = C:\app\oracle\product\19.0.0\dbhome_1))
)