I have a database TSTAFF that has a schema EDIT_REPORTS which has a synonym to I_TBLMAINT.EDIT_ERR_LOC table on TODS database. I have a public database link for TSTAFF to TODS and I am getting this error when I try to connect:
ORA-04052: error occurred when looking up remote object I_TBLMAINT.EDIT_ERR_LOC@TODS.WORLD
ORA-00604: error occurred at recursive SQL level 1
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from TODS
What could be the problem. Thanks.