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

MOSC Banner

Auto redirect primary connection to active standby database

19c database/data guard

Goal: Forcing inqiry users to connect to active standby database

Reason: user accounts exist in both primary and standby, and we would like to prevent them from connecting to primary.

We would like to automatically redirect certain user accounts to connect to standby database after they try to connect to primary. We do have a separate service on standby and provided to users, but users may still access to primary.

I am looking for a solution if oracle has a feature to do that or we could even use a trigger to redirect a connection to the standby database service.

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