Home » SQL & PL/SQL » SQL & PL/SQL » Job alert (Oracle 10g Rel2 ,Linux AS4)
Job alert [message #379532] Tue, 06 January 2009 23:30 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

We are getting this frequent error in our alert log .

ORA-12012: error on auto execute of job 21
ORA-04052: error occurred when looking up remote object TRIDW.SYS@TRIODSP.TRICORP
ORA-00604: error occurred at recursive SQL level 3
ORA-12545: Connect failed because target host or object does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1


Can somebody help out .

Regards,
Raj
Re: Job alert [message #379539 is a reply to message #379532] Wed, 07 January 2009 00:03 Go to previous message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

Hi,
for ORA-12545
-http://www.orafaq.com/wiki/ORA-12545

ORA-04052: error occurred when looking up remote object stringstringstringstringstring
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

Regards,
Ram.
Previous Topic: Insert data over network.
Next Topic: Procedures and Functions (merged 6 BB and MC)
Goto Forum:
  


Current Time: Sat Aug 19 08:18:41 CDT 2017

Total time taken to generate the page: 0.04643 seconds