Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle dataguard client connectivity Not work after manual switch over

edited Nov 28, 2024 5:33AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hello Team,

I have configured the physical standby database that is working fine. After that we configured clinet connectivity with datagurad database and able to connent the primary physical database. but after manul swich over the client not able connect the new primary database.

Here are the steps to configure the client connectivity:

-- At the Primary
exec dbms_service.create_service('ORA_PRIMARY','ORA_PRIMARY');
exec dbms_service.start_service ('ORA_PRIMARY');

---->

CREATE OR REPLACE TRIGGER start_primary
AFTER STARTUP ON DATABASE
DECLARE
database_role VARCHAR2(16);
BEGIN
-- Fetch the database role from v$database
SELECT database_role INTO database_role FROM v$database;

Tagged:

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