From oracle-l-bounce@freelists.org Fri Oct 28 10:07:42 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9SF7VVW020875 for ; Fri, 28 Oct 2005 10:07:31 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9SF6wvX020760 for ; Fri, 28 Oct 2005 10:07:09 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0951C211EA0; Fri, 28 Oct 2005 10:06:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10432-09; Fri, 28 Oct 2005 10:06:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8565F211FAE; Fri, 28 Oct 2005 10:06:01 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 Oct 2005 10:04:05 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 00352211E5A for ; Fri, 28 Oct 2005 10:04:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09996-02 for ; Fri, 28 Oct 2005 10:04:04 -0500 (EST) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.206]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 41017211E6A for ; Fri, 28 Oct 2005 10:04:04 -0500 (EST) Received: by xproxy.gmail.com with SMTP id s8so327000wxc for ; Fri, 28 Oct 2005 08:04:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=KMNef8Yer7GMA1wfV13eDLq2lhcivAbRmUqVNb6oBBuZGLYvtSW0UTMcAqNO9rJNSvI4LgLS73WEuYxBPhRlbSG318O9OFbcV7GUzTp8dHNtgGdzsbiLZ64QyM+ceFSXDRrwaPFwkmeZ4wagdR8AAQE13Heyb/0zkc5JeDRjirM= Received: by 10.70.82.3 with SMTP id f3mr234116wxb; Fri, 28 Oct 2005 08:04:03 -0700 (PDT) Received: by 10.70.11.13 with HTTP; Fri, 28 Oct 2005 08:04:03 -0700 (PDT) Message-ID: <5ea165840510280804l6935f04bkaac6fbbb721df68d@mail.gmail.com> Date: Fri, 28 Oct 2005 11:04:03 -0400 From: Magnus Andersen To: =?ISO-8859-1?Q?Birkir_Bj=F6rnsson?= Subject: Re: dbms_job failed to execute Cc: ineyman@perceptron.com, oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4271_27412727.1130511843978" References: X-archive-position: 27743 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mag.andersen@gmail.com Precedence: normal Reply-To: mag.andersen@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,NORMAL_HTTP_TO_IP,UPPERCASE_25_50 autolearn=no version=2.63 ------=_Part_4271_27412727.1130511843978 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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=F6rnsson wrote: > > Are you running oracle 9.2.0.4 or 9.2.0.5on solaris? If so after 497 days of uptime Job Queue processes stop worki= ng > 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_d= atabase_id=3DNOT&p_id=3D3427424.8 > > ------------------------------ > > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Igor Neyman > *Sent:* 27. okt=F3ber 2005 13:54 > *To:* mag.andersen@gmail.com; oracle-l@freelists.org > *Subject:* RE: dbms_job failed to execute > > Try to find additional info in the files: _j0000_,,,trc i= n > bdump directory. > > Look for the files with the timestamp close to the time when your jobs > stopped working. > > ------------------------------ > > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Magnus Andersen > *Sent:* Thursday, October 27, 2005 9:32 AM > *To:* oracle-l@freelists.org > *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 he= re. > 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 =3D HP DL 580 > OS =3D RHEL 3 AS Update 4 > DB =3D 9.2.0.6 > Output from dba_jobs =3D > 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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' > NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D= '.,' > NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'= 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=3D'AMERICAN' > NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' > NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' > NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'BINARY' 0102000000000000 0 > 3 201 SYSADM SYSADM SYSADM 27-Oct-05 7:14:59 AM 07:14:59 28-Oct-05 5:24:0= 0 > 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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' > NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' > NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'= 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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA= ' > NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D= '.,' > NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'= 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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' > NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D= '.,' > NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'= BINARY' > 0102000000000000 0 > 6 161 SYSADM SYSADM SYSADM 27-Oct-05 7:11:36 AM 07:11:36 28-Oct-05 5:24:0= 0 > 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=3D'AMERICAN' > NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' > NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' > NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'BINARY' 0102000200000000 0 > 7 805 SYSADM SYSADM SYSADM 27-Oct-05 7:15:15 AM 07:15:15 28-Oct-05 6:30:0= 0 > 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=3D'AMERICAN' NLS_TERRITORY=3D'AMERI= CA' > NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D= '.,' > NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'= 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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' > NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' > NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'= BINARY' > 0102000000000000 0 > > -- Magnus Andersen Systems Administrator / Oracle DBA Walker & Associates, Inc. ------=_Part_4271_27412727.1130511843978 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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&q= uot;.

Sincerely,
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.

On 10= /28/05, Birkir Bj=F6rnsson <birkir@miracle.is> wrote:

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 metali= nk

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat= abase_id=3DNOT&p_id=3D3427424.8

 

 

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@fr= eelists.org] On Behalf Of Igor Neyman
Sent: 27. okt=F3ber 2005 1= 3:54
To: mag.andersen@gmail.com; oracle-l@freelists.org
Subject: RE: dbms_job fail= ed to execute

 

Try to find additional info in the= files: <instance_name>_j0000_,,,trc in bdump directory.

Look for the files with the timest= amp close to the time when your jobs stopped working.

 

From: oracle-l-bounce@freelists= .org [mailto: oracle-l-bounce@freelists.org] On= Behalf Of Magnus Andersen
Sent: Thursday, October 27= , 2005 9:32 AM
To: oracle-l@freelists.org
Subject: dbms_job failed t= o 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 =3D HP DL 580
OS =3D RHEL 3 AS Update 4
DB =3D 9.2.0.6
Output from dba_jobs =3D
       JOB    LOG_USER    PRIV_USER    SCHEMA_USER    LAST_DATE    LAST_SEC &nb= sp;  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=3D'AMERICAN' NLS_TERRITORY= =3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUA= GE=3D'AMERICAN' NLS_SORT=3D'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
"    0    wa_ship_label_table_cleanup;    NLS_LANGUAGE=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUA= GE=3D'AMERICAN' NLS_SORT=3D'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=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'BINARY'    0102000000000000    0
6    161    SYSADM    SYSADM&n= bsp;   SYSADM    27-Oct-05 7:11:36 AM    07:11:36            28-Oct-05 5:24:00 AM    05:24:00    11219  &n= bsp; N    trunc(least(next_day(sysdate, 'MONDAY'), next_day(sysda= te, 'TUESDAY'), next_day(sysdate, 'WEDNESDAY'), next_day(sysdate, 'THURSDAY'), next_day(sysdate, 'FRIDAY'))) + 05.40/24    0  &nb= sp; wa_customer_profile_generator;    NLS_LANGUAGE=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'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  &nbs= p; wa_acct_control_updates;    NLS_LANGUAGE=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'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;&n= bsp;   NLS_LANGUAGE=3D'AMERICAN' NLS_TERRITORY=3D'AMERICA' NLS_CURRENCY=3D'$' NLS_ISO_CURRENCY=3D'AMERICA' NLS_NUMERIC_CHARACTERS=3D'.,' NLS_DATE_FORMAT=3D'DD-MON-RR' NLS_DATE_LANGUAGE=3D'AMERICAN' NLS_SORT=3D'BINARY'    0102000000000000    0<= /span>

 




--
Magnus Andersen
Syst= ems Administrator / Oracle DBA
Walker & Associates, Inc. ------=_Part_4271_27412727.1130511843978-- -- http://www.freelists.org/webpage/oracle-l