My DB Version=10.2.0.4
I had a stream relation that working correctly after switchover to standby in destination now in source database i got the following error in propagation:
select status,error_message from dba_propagation
ORA-02068: following severe error from AQHOS
ORA-01033: ORACLE initialization or shutdown in progress
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1087
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7616
ORA-06512: at "SYS.DBMS_AQADM", line 631
ORA-06512: at line 1
i corrected all tnsnames and dblink is working correctly but still i have this error.
WHAT I MUST TO DO?
Refer to metalink document _STREAMS propagation to Primary of physical Standby configuation errors with Ora-01033, Ora-02068 *[ID 359971.1]*_
You need to set SERVICE_NAMES. Hope this helps resolve your issue.