I created Synchronous stream between to servers PAServer1 and PAServer2. However, whenever I reboot the PAServer1, the EM web page will show this error
ORA-04052: error occurred when looking up remote object STREAMADMIN.SYS@XE.DB2 ORA-00604: error occurred at recursive SQL level 4 ORA-12545: Connect failed because target host or object does not exist ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1129 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9287 ORA-06512: at "SYS.DBMS_AQADM", line 681 ORA-06512: at line 1
I don't know how to solve this error.
This happened when the PAServer2 EM became unaccessible and I have to recreate the em again.
Please guide me on how to solve this problem.