High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Use of DG service

Administering a Data Guard Configuration (oracle.com)

The following network service names are pre-defined:


SID_dg: This service is used to connect to the primary database. If the database uses Oracle Database 12c Release 1, or later, this service connects to the root container.

Question !! is it valid or recommended to use the SID_DG service in TNS ora for external client connections to handle a DG switch ?


SID_NAME=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=<name>)

(PORT=1527)

)

(CONNECT_DATA=

(SERVER=dedicated)

(SERVICE_NAME=SID_DG)

)

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