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: 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: Sun Dec 04 12:43:36 CST 2016

Total time taken to generate the page: 0.08681 seconds