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
Messages: 295
Registered: May 2007
Senior Member

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 .

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

for 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

Previous Topic: want to display fields using dbms_output.put_line
Next Topic: i want to display the alphabetic letters for the range of salaries by using decode
Goto Forum:

Current Time: Thu Apr 27 21:32:53 CDT 2017

Total time taken to generate the page: 0.30393 seconds