Skip to Main Content

ORA-04052: error occurred when looking up remote object STREAMADMIN.SYS@XE.DB2

User_ZLSM0Jan 17 2022

Hi
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
Screen Shot 2022-01-17 at 5.02.15 PM.pngI 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.
thanks
chris

Comments
Post Details
Added on Jan 17 2022
2 comments
52 views