Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB link
buro9 wrote:
> we'e currently also getting an ORA-04052:
> ORA-04052: error occurred when looking up remote object
> <objectname removed>
>
>
> it seems a pretty major problem and the only thing i've found so far
> is a proposal to rerun some of Oracles internals... but this results
> in downtime.
>
> has anyone come across this issue and then resolved it without downtime?
>
> cheers
>
> david k
Did you run the sql script mentioned in the following?
oracle$ oerr ora 4052
04052, 00000, "error occurred when looking up remote object %s%s%s%s%s"
// *Cause: An error has occurred when trying to look up a remote object. // *Action: Fix the error. Make sure the remote database system has run // KGLR.SQL to create necessary views used for querying/looking up // objects stored in the database.Received on Wed Jan 15 2003 - 10:47:37 CST