Remote listener RAC
Dear support,
We are using 2 node RAC- DB version 19.17
CDB with single PDB
uatcdb is CDB
UATDB is PDB
Our remote listener parameter is set to a tns alias and we are able to see them in v$listener_network
We have 3 scan listeners running,one on node 1 and 2 on node2
Node1
[griduat@erpuatdb1 ~]$ srvctl config scan_listener
SCAN Listeners for network 1: Registration invited nodes: Registration invited subnets: Endpoints: TCP:1528 SCAN Listener LISTENER_SCAN1 exists SCAN Listener is enabled. SCAN Listener LISTENER_SCAN2 exists SCAN Listener is enabled. SCAN Listener LISTENER_SCAN3 exists SCAN Listener is enabled. In tnsnames.ora UATDB_REMOTE= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=*******.207)(PORT=1528)) (ADDRESS=(PROTOCOL=tcp)(HOST=*******.208)(PORT=1528)) (ADDRESS=(PROTOCOL=tcp)(HOST=*******.209)(PORT=1528)) ) ) [orauat@erpuatdb1 19chome]$ sqlplus "/as sysdba" SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 17 09:03:34 2023 Version 19.17.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition