Error connecting to new listener
Hi
We added a new listener to our ODA X7-2M single node bare metal deployment
Here is the entry of that under $GRID_HOME/network/admin/listener.ora
SID_LIST_LISTENER_BG =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME=/u01/app/12.2.0.1/grid)
(SID_NAME = odaprod)
)
)
LISTENER_BG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ODA-SERVER)(PORT = 1523))
)
)
Here is the entry under $ORACLE_HOME/network/admin/tnsnames.ora
oda_bg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ODA-SERVER)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = odaprod)
)
)
Here is the output of listener status and tnsping commands
[grid@ODA-SERVER ~]$ lsnrctl status listener_bg