Oracle dataguard client connectivity Not work after manual switch over
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;