Home » RDBMS Server » Server Administration » ORA-12012: error on auto execute of job 425
ORA-12012: error on auto execute of job 425 [message #310453] Tue, 01 April 2008 05:51 Go to next message
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.
Re: ORA-12012: error on auto execute of job 425 [message #310475 is a reply to message #310453] Tue, 01 April 2008 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-29278: SMTP transient error: %s
 *Cause:  A SMTP transient error occurred.
 *Action: Correct the error and retry the SMTP operation.

Regards
Michel
Re: ORA-12012: error on auto execute of job 425 [message #310482 is a reply to message #310453] Tue, 01 April 2008 07:09 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Michel,
But, for now i want just to point out the problem.
So am i right that the problem is with the job 425?
Quote:

ORA-12012: error on auto execute of job 425


Or it is the SMTP connection general problem?

Thanks,
Re: ORA-12012: error on auto execute of job 425 [message #310501 is a reply to message #310482] Tue, 01 April 2008 07:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what the message said.
You can also see it in your alert.log file.

Regards
Michel
Previous Topic: split from hijacked thread Re: ORA-27101 SHARED MEMORY REALM DOES'NT EXIST
Next Topic: Why I cannot set the Charactor Set while installing.
Goto Forum:
  


Current Time: Sun Dec 04 16:42:57 CST 2016

Total time taken to generate the page: 0.13762 seconds