Database Administration (MOSC)

MOSC Banner

ORA-04052: error occurred when looking up remote object SYS.X$JOXSCD@FG02.FGIC.COM

edited Sep 17, 2014 12:24AM in Database Administration (MOSC) 2 commentsAnswered ✓

After upgrading a database to 11g (11.2.0.4), I get the below error when accessing DBA_SOURCE in that database over a DB link.  And it only happens in PL/SQL and not direct SQL.  Also, it seems it is only an issue with DBA_SOURCE.  I have a package where this error occurs, and that package queries many of the DBA views through this DB link.  But I narrowed it down to DBA_SOURCE.  When the one query to DBA_SOURCE@FG02 is in the package, it won't compile.  When I take it out, the package compiles.  So all the other queries of other DBA views

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center