Hi, I have a DBLink between DB1 and DB2, but for one reason it appears as not active (or invalid) in OMS, although if I test the DBLink performing any sql statement using SQLPlus (select * from table@dblink), it works fine.
Tnsnames.ora is ok also.
But the main problem is that when I want to compile procedures inside OMS that use the DBLink, it get an ORA-02019, cause OMS "see" it as invalid...
Does anybody face with this problem? Any solution? What if I restart the OMS?
Thanks in advance,