Oracle Job Scheduler "Stuck" -


we have 2 production environments xx , xy. both on oracle 11g release 11.2.0.2.0. both environments have queue table , job queue en-queue/de-queue jobs , process them. application server apache tomcat version 6.0.32.

the problem facing in xx environment, oracle scheduler gets "hanged" or "stuck" daily @ 4.30pm local time, whereas in xy environment works fine. entries scheduled jobs start accumulating in queue table causing alerts trigger off. has re-start application server after whole thing works fine , pending jobs processed without issues. dba says no issues in database, not convinced.

searching on google led me link : dbms_scheduler jobs stuck after upgrade 11.2 , based on explanation checked , compared db parameter job_queue_processes. has got same values/details, @ dead-end here.

values job_queue_processes

once while re-starting application got below exception on output/display not in logs:

mar 18, 2014 11:44:19 org.apache.catalina.startup.catalina stopserver severe: catalina.stop: java.net.connectexception: connection refused @ java.net.plainsocketimpl.socketconnect(native method) @ java.net.plainsocketimpl.doconnect(plainsocketimpl.java:351) @ java.net.plainsocketimpl.connecttoaddress(plainsocketimpl.java:213) @ java.net.plainsocketimpl.connect(plainsocketimpl.java:200) @ java.net.sockssocketimpl.connect(sockssocketimpl.java:366) @ java.net.socket.connect(socket.java:529) @ java.net.socket.connect(socket.java:478) @ java.net.socket.<init>(socket.java:375) @ java.net.socket.<init>(socket.java:189) @ org.apache.catalina.startup.catalina.stopserver(catalina.java:422) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:39) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:25) @ java.lang.reflect.method.invoke(method.java:597) @ org.apache.catalina.startup.bootstrap.stopserver(bootstrap.java:338) @ org.apache.catalina.startup.bootstrap.main(bootstrap.java:416)

so wondering,

  • is case while jobs getting enqueued, connection db getting lost in between, causing oracle scheduler "hang" in between?
  • is there other database parameter need verify/validate? known bug in oracle? if yes documented anywhere? sorry may have missed out reading.
  • is there other information need ask dba check?

thanks in advance help.

edit: link output of query => select * dba_scheduler_jobs given in excel @ link: job_output.xlsx

thanks!

update on 20/mar/2014

the problem not resolved yet. hence more output queries posted below in question.

sql> select queue,msg_state,expiration_reason,count(*)   2  aq$job_qtbl   3  group queue,msg_state,expiration_reason;  queue                          msg_state        expiration_reason    count(*) ------------------------------ ---------------- ------------------ ---------- job_q                          ready                                        4  sql> select owner, name, queue_type, max_retries, retry_delay   2    dba_queues   3   queue_table = 'job_qtbl'   4   , owner = 'env_xx';  owner                          name                           queue_type         max_retries retry_delay ------------------------------ ------------------------------ -------------------- ----------- ----------- env_xx                        aq$_job_qtbl_e                 exception_queue                0           0 env_xx                        job_q                          normal_queue                   5           0  sql>


Comments

Post a Comment

Popular posts from this blog

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

vb.net - Virtual Keyboard commands -

i wondering difference between virtual these keyboard commands is: keyeventf_extendedkey , keyeventf_keyup is. everywhere have looked gives me description based off integers , not want know each of them does. you've tagged question vb.net, these have nothing @ vb.net. they're constants defined in windows header files, use win32 api functions. as far difference, can't tell looking @ values. individual values not particularly important, that's why named identifiers used. what's important used , documentation functions tells mean. the first one, keyeventf_extendedkey , used keybdinput structure (which used along e.g. sendinput function) pass information synthesized keyboard input. if flag used, means scan code should interpreted extended key. technically, means scan code preceded prefix byte value 224 (&he0 in hexadecimal notation). the second one, keyeventf_keyup , 1 of flags available use structure. means key being released (going up)...
Read more

How to get multiresult with multicondition in Sql Server -

i need solve this. hopefully can giving me advices. for sample, i've got data : proclib.march 1 first 10 rows flight date depart orig dest miles boarded capacity ----------------------------------------------------------------- 114 01mar94 7:10 lga lax 2475 172 210 202 01mar94 10:43 lga ord 740 151 210 219 01mar94 9:31 lga lon 3442 198 250 622 01mar94 12:19 lga fra 3857 207 250 132 01mar94 15:35 lga yyz 366 115 178 271 01mar94 13:17 lga par 3635 138 250 302 01mar94 20:22 lga 229 105 180 114 02mar94 7:10 lga lax 2475 119 210 202 02mar94 10:43 lga ord 740 120 210 219 02mar94 9:31 lga lon 344...
Read more