.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
dbms_job failed to execute

dbms_job failed to execute

2005-10-28       - By Gogala, Mladen
Reply:     <<     11     12     13     14     15     16     17     18     19     20     >>  

Some people (I will not mention any names, of course)  feel that asking
questions without doing even

a minimal investigation is disrespectful to oracle professionals who did
invest some work into becoming

oracle professionals. Some people will probably continue to discourage such
lazy beginners by using

all means at their disposal.  Some people are equally entitled to their
opinion as you are to yours.

The first amendment of the email lists reads as follows:


Moderator  shall make no rule respecting an establishment of religion, or
prohibiting the free exercise thereof; or abridging the freedom of speech,
or of the press; or the right of the people peaceably to assemble, and to
petition the moderator for a redress of grievances.


--

Mladen Gogala

Ext. 121

 __ __  

From: Jared Still [mailto:jkstill@(protected)]
Sent: Friday, October 28, 2005 12:33 PM
To: mag.andersen@(protected)
Cc: Oracle-L Freelists
Subject: Re: dbms_job failed to execute



Hi Magnus,

You can  ignore the comments about going to a beginners list.

Some feel it is a somehow a  waste of their time to see an easy
question in this list, and then be forced to either skip it or delete it.

To deal with jobs that don't run, apply some basic troubleshooting
techniques.

First read the docs about dbms_job.  There you will find there is a
DBMS_JOB.RUN procedure.

Simply login as the account that owns the job and run it:
eg.  exec dbms_job.run(15,true)

If there is a problem running the job from the scheduler, this method will
usually fail as well, with the difference that you can see what the errors
are.

If the job runs, but still fails from the scheduler, a next step might be to
trace the job.  This could cause a rather large tracefile - that depends on
how long the job runs before failing. (google for 10046 traces. This can be
enabled by modifying the job, logon trigger, etc.)

HTH,

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On 10/27/05, Magnus Andersen <mag.andersen@(protected)
<mailto:mag.andersen@(protected)>  > wrote:

I do frequently look at asktom.  I've signed up for the new beginners list.
Don't really know about other beginners lists.  Also I was recommended this
list from a Pro who stated that it had a lot of Oracle pros who didn't mind
to help.  Maybe he was wrong???

One thing to keep in mind when targeting "beginners" is that I've seen
several posts on here and even helped out an a few when it comes to shell
scripting that I would most definitely consider beginner questions...

Have to be careful when dealing with elitism.....

Sincerely,

Magnus



On 10/27/05, Gogala, Mladen < <mailto:MGogala@(protected)>
MGogala@(protected)> wrote:

Have you ever considered a beginner list or asktom? .Maybe those forums
would be appropriate for you?

I  wouldn't object to you asking a question like this if  it didn't end up
in my mailbox. I really think that

this is not a forum for questions like yours.



--

Mladen Gogala







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




<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=us-ascii">


<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="PersonName"/>
<!--[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:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
h3
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:13.5pt;
  font-family:"Times New Roman";
  font-weight:bold;}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:blue;
  text-decoration:underline;}
p
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailStyle21
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
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'>Some people (I will not mention any names,
of course) &nbsp;feel that asking questions without doing even<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 minimal investigation is disrespectful
to oracle professionals who did invest some work into becoming<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'>oracle professionals. Some people will
probably
continue to discourage such lazy beginners by using<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'>all means at their disposal. &nbsp;Some
people are equally entitled to their opinion as you are to yours.<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'>The first amendment of the email lists
reads as follows:<o:p></o:p></span></font></p>

<h3><b><font size=2 face="Times New Roman"><span style='font-size:10.0pt;
font-weight:normal'>Moderator &nbsp;shall make no rule respecting an
establishment of religion, or prohibiting the free exercise thereof; or
abridging the freedom of speech, or of the press; or the right of the people
peaceably to assemble, and to petition the moderator for a redress of
grievances</span></font></b>.<font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font><font
size=2><span style='font-size:10.0pt;font-weight:normal'><o:p></o:p></span><
/font></h3>

<div>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>--</span></font><font color=navy><span
style='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'>Mladen Gogala</span></font><font
color=navy><span style='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'>Ext. 121</span></font><o:p></o:p></p>

</div>

<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'> Jared Still
[mailto:<st1:PersonName w:st="on">jkstill@(protected)</st1:PersonName>] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, October 28, 2005
12:33 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">mag
.andersen@(protected)</st1:PersonName><br>
<b><span style='font-weight:bold'>Cc:</span></b> Oracle-L Freelists<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>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Hi Magnus,<br>
<br>
You can&nbsp; ignore the comments about going to a beginners list.<br>
<br>
Some feel it is a somehow a&nbsp; waste of their time to see an easy<br>
question in this list, and then be forced to either skip it or delete it.<br>
<br>
To deal with jobs that don't run, apply some basic troubleshooting techniques.
<br>
<br>
First read the docs about dbms_job.&nbsp; There you will find there is a <br>
DBMS_JOB.RUN procedure.<br>
<br>
Simply login as the account that owns the job and run it:<br>
eg.&nbsp; exec dbms_job.run(15,true)<br>
<br>
If there is a problem running the job from the scheduler, this method will<br>
usually fail as well, with the difference that you can see what the errors are.
<br>
<br>
If the job runs, but still fails from the scheduler, a next step might be to<br>
trace the job.&nbsp; This could cause a rather large tracefile - that depends
on<br>
how long the job runs before failing. (google for 10046 traces. This can be<br>
enabled by modifying the job, logon trigger, etc.)<br>
<br>
HTH,<br>
<br>
-- <br>
Jared Still<br>
Certifiable Oracle DBA and Part Time Perl Evangelist<o:p></o:p></span></font><
/p>

<div>

<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman">
<span
style='font-size:12.0pt'>On 10/27/05, <b><span style='font-weight:bold'>Magnus
Andersen</span></b> &lt;<a href="mailto:mag.andersen@(protected)">mag.andersen
@(protected)</a>
&gt; wrote:</span></font></span><o:p></o:p></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I do frequently look at asktom.&nbsp; I've signed up for the new
beginners list.&nbsp; Don't really know about other beginners lists.&nbsp; Also
I was recommended this list from a Pro who stated that it had a lot of Oracle
pros who didn't mind to help.&nbsp; Maybe he was wrong???<br>
<br>
One thing to keep in mind when targeting &quot;beginners&quot; is that I've
seen several posts on here and even helped out an a few when it comes to shell
scripting that I would most definitely consider beginner questions...<br>
<br>
Have to be careful when dealing with elitism.....<br>
<br>
Sincerely,<br>
<br>
<span class=sg>Magnus</span><o:p></o:p></span></font></p>

<div><span id="q_10732b90ae6b624e_2">

<p class=MsoNormal style='margin-bottom:12.0pt'><span class=e><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p>&nbsp;</o:p></span><
/font></span></p>

<div>

<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman">
<span
style='font-size:12.0pt'>On 10/27/05, <st1:PersonName w:st="on"><b><span
style='font-weight:bold'>Gogala, Mladen</span></b></st1:PersonName> &lt;<a
href="mailto:MGogala@(protected)" target="_blank">
MGogala@(protected)</a>&gt; wrote:</span></font></span><o:p></o:p></p>

<div>

<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>Have you ever considered a beginner list or asktom? .Maybe
those forums would be appropriate for you? </span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>I&nbsp; wouldn't object to you asking a question like this if
&nbsp;it didn't end up in my mailbox. I really think that</span></font><o:p></o
:p></p>

<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>this is not a forum for questions like yours. </span></font>
<o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>&nbsp;</span></font><o:p></o:p></p>

<div>

<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>--</span></font><o:p></o:p></p>

<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>Mladen Gogala</span></font><o:p></o:p></p>

</div>

</div>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
<br>
<o:p></o:p></span></font></p>

</div>

</span>

<div><span id="q_10732b90ae6b624e_3">

<p class=MsoNormal><span class=e><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>-- </span></font></span><br>
<span class=e>Magnus Andersen</span><br>
<span class=e>Systems Administrator / Oracle DBA</span><br>
<span class=e>Walker &amp; Associates, Inc. </span></span><o:p></o:p></p>

</div>

</div>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p>&nbsp;</o:p></span><
/font></p>

</div>

</body>

</html>