dbms_job failed to execute 2005-10-28 - By Birkir Björnsson
Are you running oracle 9.2.0.4 or 9.2.0.5 on solaris? If so after 497
days of uptime Job Queue processes stop working and you will have to
reboot the server. Following is an link to a bug on metalink
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_
database_id=NOT&p_id=3427424.8
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Igor Neyman
Sent: 27. október 2005 13:54
To: mag.andersen@(protected); oracle-l@(protected)
Subject: RE: dbms_job failed to execute
Try to find additional info in the files: <instance_name>_j0000_,,,trc
in bdump directory.
Look for the files with the timestamp close to the time when your jobs
stopped working.
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Magnus Andersen
Sent: Thursday, October 27, 2005 9:32 AM
To: oracle-l@(protected)
Subject: dbms_job failed to execute
Hi All,
I have several dbms_jobs scheduled and have had them there for a long
time. Tuesday they stopped being executed on appointed times. I've
looked in Metalink, but have not found anything. I have no errors in my
alert log, nor do I have any failures. Being a "newbie" I'm not sure
where to go from here. Below is some system information. Please let me
know if there is anything else I need to provide for this to be
meaningful to you.
Any help/advice is greatly appreciated.
Thanks,
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.
System Information:
Server = HP DL 580
OS = RHEL 3 AS Update 4
DB = 9.2.0.6
Output from dba_jobs =
JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE
LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME
BROKEN INTERVAL FAILURES WHAT NLS_ENV MISC_ENV
INSTANCE
1 143 SYSADM SYSADM SYSADM 27-Oct-05 7:07:51 AM
07:07:51 28-Oct-05 10:03:00 PM 22:03:00 54 N
"trunc(sysdate+1) + 22.05/24
" 0 wa_service_level; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' 0102000000000000 0
2 142 SYSADM SYSADM SYSADM 27-Oct-05 7:07:46 AM
07:07:46 28-Oct-05 10:00:00 PM 22:00:00 86 N
"trunc(sysdate+1) + 22.00/24
" 0 wa_ship_label_table_cleanup; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' 0102000000000000 0
3 201 SYSADM SYSADM SYSADM 27-Oct-05 7:14:59 AM
07:14:59 28-Oct-05 5:24:00 AM 05:24:00 91216 N
trunc(sysdate+1) + 05.40/24 0
wa_forecast_driver('Y',12,wa_get_period(trunc(sysdate)));
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY' 0102000200000000 0
4 145 SYSADM SYSADM SYSADM 27-Oct-05 7:07:56 AM
07:07:56 28-Oct-05 10:30:00 PM 22:30:00 21115 N
trunc(sysdate+1) + 22.50/24 0 wa_run_product_update;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY' 0102000200000000 0
5 146 SYSADM SYSADM SYSADM 27-Oct-05 7:11:21 AM
07:11:21 28-Oct-05 11:27:00 PM 23:27:00 396 N
trunc(sysdate+1) + 23.45/24 0 wa_wynncomm_updates;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY' 0102000000000000 0
6 161 SYSADM SYSADM SYSADM 27-Oct-05 7:11:36 AM
07:11:36 28-Oct-05 5:24:00 AM 05:24:00 11219 N
trunc(least(next_day(sysdate, 'MONDAY'), next_day(sysdate, 'TUESDAY'),
next_day(sysdate, 'WEDNESDAY'), next_day(sysdate, 'THURSDAY'),
next_day(sysdate, 'FRIDAY'))) + 05.40/24 0
wa_customer_profile_generator; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' 0102000200000000 0
7 805 SYSADM SYSADM SYSADM 27-Oct-05 7:15:15 AM
07:15:15 28-Oct-05 6:30:00 PM 18:30:00 46549 N
trunc(least(next_day(sysdate, 'MONDAY'), next_day(sysdate, 'TUESDAY'),
next_day(sysdate, 'WEDNESDAY'), next_day(sysdate, 'THURSDAY'),
next_day(sysdate, 'FRIDAY'))) + 18.5/24 0 wa_acct_control_updates;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY' 0102000200000000 0
8 17535 SYSADM SYSADM SYSADM 27-Oct-05 7:17:11 AM
07:17:11 27-Oct-05 7:32:00 AM 07:32:00 86 N
trunc(SYSDATE+1/96,'MI') 0 po_notify; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' 0102000000000000 0
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region
"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@(protected) Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Are you running oracle 9.2.0.4 or 9.2.0.5
on solaris? If so after 497 days of uptime Job Queue processes stop working and
you will have to reboot the server. Following is an link to a bug on metalink<o
:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a
href="https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p
_database_id=NOT&p_id=3427424.8">https://metalink.oracle.com/metalink/plsql
/ml2_documents.showDocument?p_database_id=NOT&p_id=3427424.8</a><o:p></o:p><
/span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> oracle-l-bounce
@(protected)
[mailto:oracle-l-bounce@(protected)] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Igor Neyman<br>
<b><span style='font-weight:bold'>Sent:</span></b> 27. október 2005 13:54<br>
<b><span style='font-weight:bold'>To:</span></b> mag.andersen@(protected);
oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: dbms_job failed to
execute</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Try to find additional info in the files:
<instance_name>_j0000_,,,trc in bdump directory.</span></font><o:p></o:p>
</p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Look for the files with the timestamp
close to the time when your jobs stopped working.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma>
<span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font
></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Magnus Andersen<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, October 27, 2005
9:32 AM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> dbms_job failed to
execute</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi All,<br>
<br>
I have several dbms_jobs scheduled and have had them there for a long
time. Tuesday they stopped being executed on appointed times. I've
looked in Metalink, but have not found anything. I have no errors in my
alert log, nor do I have any failures. Being a "newbie" I'm not
sure where to go from here. Below is some system information.
Please let me know if there is anything else I need to provide for this to be
meaningful to you.<br>
<br>
Any help/advice is greatly appreciated.<br>
<br>
Thanks,<br>
-- <br>
Magnus Andersen<br>
Systems Administrator / Oracle DBA<br>
Walker & Associates, Inc.<br>
<br>
<br>
System Information:<br>
Server = HP DL 580<br>
OS = RHEL 3 AS Update 4<br>
DB = <a href="http://9.2.0.6">9.2.0.6</a><br>
Output from dba_jobs =<br>
JOB
LOG_USER PRIV_USER
SCHEMA_USER LAST_DATE LAST_SEC
THIS_DATE THIS_SEC
NEXT_DATE NEXT_SEC
TOTAL_TIME BROKEN
INTERVAL FAILURES WHAT
NLS_ENV MISC_ENV INSTANCE<br>
1 143 SYSADM
SYSADM SYSADM 27-Oct-05 7:07:51
AM 07:07:51
28-Oct-05 10:03:00 PM
22:03:00 54 N
"trunc(sysdate+1) + 22.05/24<br>
" 0
wa_service_level; NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='<st1
:country-region
w:st="on">AMERICA</st1:country-region>' NLS_CURRENCY='$' NLS_ISO_CURRENCY='<st1
:country-region
w:st="on"><st1:place w:st="on">AMERICA</st1:place></st1:country-region>'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE=
'AMERICAN'
NLS_SORT='BINARY' 0102000000000000 0<br>
2 142 SYSADM
SYSADM SYSADM 27-Oct-05 7:07:46
AM 07:07:46
28-Oct-05 10:00:00 PM
22:00:00 86 N
"trunc(sysdate+1) + 22.00/24<br>
" 0
wa_ship_label_table_cleanup; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='<st1:country-region w:st="on">AMERICA</st1:country-region>'
NLS_CURRENCY='$' NLS_ISO_CURRENCY='<st1:country-region w:st="on"><st1:place
w:st="on">AMERICA</st1:place></st1:country-region>'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
0102000000000000 0<br>
3 201 SYSADM
SYSADM SYSADM 27-Oct-05 7:14:59
AM 07:14:59
28-Oct-05 5:24:00 AM
05:24:00 91216 N
trunc(sysdate+1) + 05.40/24 0
wa_forecast_driver('Y',12,wa_get_period(trunc(sysdate)));
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY' 0102000200000000 0<br>
4 145 SYSADM
SYSADM SYSADM 27-Oct-05 7:07:56
AM 07:07:56
28-Oct-05 10:30:00 PM
22:30:00 21115 N
trunc(sysdate+1) + 22.50/24 0
wa_run_product_update; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE=
'AMERICAN'
NLS_SORT='BINARY' 0102000200000000 0<br>
5 146 SYSADM
SYSADM SYSADM 27-Oct-05 7:11:21
AM 07:11:21
28-Oct-05 11:27:00 PM
23:27:00 396 N
trunc(sysdate+1) + 23.45/24 0
wa_wynncomm_updates; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
0102000000000000 0<br>
6 161 SYSADM SYSADM
SYSADM 27-Oct-05 7:11:36 AM
07:11:36 28-Oct-05
5:24:00 AM 05:24:00 11219
N trunc(least(next_day(sysdate, 'MONDAY'), next_day(sysdate,
'TUESDAY'), next_day(sysdate, 'WEDNESDAY'), next_day(sysdate, 'THURSDAY'),
next_day(sysdate, 'FRIDAY'))) + 05.40/24 0
wa_customer_profile_generator; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
0102000200000000 0<br>
7 805 SYSADM
SYSADM SYSADM 27-Oct-05 7:15:15
AM 07:15:15
28-Oct-05 6:30:00 PM
18:30:00 46549 N
trunc(least(next_day(sysdate, 'MONDAY'), next_day(sysdate, 'TUESDAY'),
next_day(sysdate, 'WEDNESDAY'), next_day(sysdate, 'THURSDAY'),
next_day(sysdate, 'FRIDAY'))) + 18.5/24 0
wa_acct_control_updates; NLS_LANGUAGE='AMERICAN'
NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
0102000200000000 0<br>
8 17535 SYSADM
SYSADM SYSADM 27-Oct-05 7:17:11
AM 07:17:11
27-Oct-05 7:32:00 AM
07:32:00 86 N
trunc(SYSDATE+1/96,'MI') 0 po_notify;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$'
NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN'
NLS_SORT='BINARY' 0102000000000000 0<o:p><
/o:p></span></font></p>
</div>
</body>
<!--[object_id=#miracle.is#]--><P> </P></html>
|
|
