RE: job fails
Date: Thu, 20 Feb 2014 15:11:47 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF022A98D6_at_WIN02.hotsos.com>
Check job_queue_processes perhaps?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Thursday, February 20, 2014 4:03 PM To: David Fitzjarrell; oracle-l (oracle-l_at_freelists.org) Subject: RE: job fails
Nope, that didn’t help it still failed with the same error……
Brian
From: Zelli, Brian
Sent: Thursday, February 20, 2014 3:42 PM
To: 'David Fitzjarrell'; oracle-l (oracle-l_at_freelists.org)
Subject: RE: job fails
Yes. But I think I may have found the error. My ORACLE_BASE was pointing to the wrong directory (10g not 11g)…..
Brian
From: David Fitzjarrell [mailto:oratune_at_yahoo.com] Sent: Thursday, February 20, 2014 3:38 PM To: Zelli, Brian; oracle-l (oracle-l_at_freelists.org) Subject: Re: job fails
I understand this to mean you're running this from cron?
David Fitzjarrell
Primary author, "Oracle Exadata Survival Guide"
On Thursday, February 20, 2014 1:35 PM, "Zelli, Brian" <Brian.Zelli_at_RoswellPark.org> wrote:
I’m running a dbms_stats.gather_schema_stats job thru a unix job and it runs for a while then fails with a
ORA-01013: user requested cancel of current operation
I didn’t cancel the job so why is this stopping?
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 20 2014 - 22:11:47 CET