Database - RAC/Scalability (MOSC)

MOSC Banner

Remote listener RAC

edited Mar 17, 2023 3:41AM in Database - RAC/Scalability (MOSC) 12 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center