dbms_job failed to execute 2005-10-28 - By Magnus Andersen
I bounced the instance last night and everything works great now. I'm not
going to research what happened unless this becomes a frequent issue, as
Chris previously mentioned.
Thanks all for your help, understanding, and patience from a "newbie".
Sincerely,
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.
On 10/28/05, Birkir Björnsson <birkir@(protected)> wrote:
>
> Are you running oracle 9.2.0.4 <http://9.2.0.4> or 9.2.0.5<http://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 <http://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
>
>
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.
I bounced the instance last night and everything works great now. I'm
not going to research what happened unless this becomes a frequent
issue, as Chris previously mentioned.<br>
<br>
Thanks all for your help, understanding, and patience from a "newbie"
.<br>
<br>
Sincerely,<br>
-- <br>
Magnus Andersen<br>
Systems Administrator / Oracle DBA<br>
Walker & Associates, Inc.<br><br><div><span class="gmail_quote">On 10/28/05
, <b class="gmail_sendername">Birkir Björnsson</b> <<a href="mailto:birkir
@(protected)">birkir@(protected)</a>> wrote:</span><blockquote class="gmail
_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0
.8ex; padding-left: 1ex;">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;">Are you running oracle <a href="http://9.2.0.4"
target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
9.2.0.4</a> or <a href="http://9.2.0.5" target="_blank" onclick="return top.js
.OpenExtLink(window,event,this)">9.2.0.5</a>
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<
/span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;"><a href="https://metalink.oracle.com/metalink
/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=3427424.8" target="
_blank" onclick="return top.js.OpenExtLink(window,event,this)">
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p
_database_id=NOT&p_id=3427424.8</a></span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: navy;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman"
size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family:
Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"
><span style="font-size: 10pt; font-family: Tahoma;"> <a href="mailto:oracle-l
-bounce@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window
,event,this)">
oracle-l-bounce@(protected)</a>
[mailto:<a href="mailto:oracle-l-bounce@(protected)" target="_blank" onclick=
"return top.js.OpenExtLink(window,event,this)">oracle-l-bounce@(protected)</a>
] <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> <a href="mailto:mag.andersen
@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window,event,this
)">mag.andersen@(protected)</a>;
<a href="mailto:oracle-l@(protected)" target="_blank" onclick="return top.js
.OpenExtLink(window,event,this)">oracle-l@(protected)</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> RE: dbms_job failed to
execute</span></font></p>
</div><span class="q">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> <
/span></font></p>
<p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: blue;">Try to find additional info in the files:
<instance_name>_j0000_,,,trc in bdump directory.</span></font></p>
<p><font color="blue" face="Arial" size="2"><span style="font-size: 10pt; font
-family: Arial; color: blue;">Look for the files with the timestamp
close to the time when your jobs stopped working.</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> <
/span></font></p>
<div style="text-align: center;" align="center"><font face="Times New Roman"
size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div></span>
<p style="margin-bottom: 12pt;"><b><font face="Tahoma" size="2"><span style=
"font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font><
/b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family:
Tahoma;">
<a href="mailto:oracle-l-bounce@(protected)" target="_blank" onclick="return
top.js.OpenExtLink(window,event,this)">oracle-l-bounce@(protected)</a>
[mailto:<a href="mailto:oracle-l-bounce@(protected)" target="_blank" onclick=
"return top.js.OpenExtLink(window,event,this)">
oracle-l-bounce@(protected)</a>] <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> <a href="mailto:oracle-l
@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window,event
,this)">oracle-l@(protected)</a><span class="q"><br>
<b><span style="font-weight: bold;">Subject:</span></b> dbms_job failed to
execute</span></span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><span
class="q">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></span><span class="q">
Magnus Andersen<br>
Systems Administrator / Oracle DBA<br>
Walker & Associates, Inc.<br>
<br>
<br></span><span class="q">
System Information:<br>
Server = HP DL 580<br>
OS = RHEL 3 AS Update 4<br>
DB = <a href="http://9.2.0.6" target="_blank" onclick="return top.js
.OpenExtLink(window,event,this)">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=
'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>
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='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>
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</span>
</span></font></p>
</div>
<p> </p>
</blockquote></div><br><br clear="all"><br>-- <br>Magnus Andersen<br>Systems
Administrator / Oracle DBA<br>Walker & Associates, Inc.
|
|
