ORA-12012: error on auto execute of job 425 [message #310453] |
Tue, 01 April 2008 05:51 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi,
In Alert.ora file i seen that job 425 is having the problem.
ORA-12012: error on auto execute of job 425
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 399
ORA-06512: at "TETS.HANDLER", line 208
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 399
ORA-06512: at "TEST.EMAIL", line 1287
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at line 1
I want to confirm is that the job number specified is the same as the job in the dba_jobs?
SELECT a.job,a.what
FROM dba_jobs a
Output is
------------
JOB WHAT
425 handler.StatusMail();
Please confirm that the handler.StatusMail() prodecure is having problem?
Means i need to check in handler.StatusMail(); procedure..... right?
Thanks in advance.
|
|
|
|
|
|