?
Solved

Reg : DB Jobs

Posted on 2008-06-17
5
Medium Priority
?
544 Views
Last Modified: 2013-12-19
Hi

Good Evening

I have faced an issue with db job while we migrate WebMethods6.1 to Webmethods 6.5. When we try to run the db migration scripts. we had db lock on wmlog table. The job also running in the same schema which does the cleanup activity. The job suppose to run at everyday 5 AM. But,we executed the scripts in 7:15 Pm

I would like know the magic behind how the job has been initiated automatically. when shutdown and start the system.

Also, our system doesn't enabled with sql_trace,audit_trace

Please find hereunder the trace file for your kind perusal and advice.

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /ora/920
System name:    AIX
Node name:      sss
Release:        3
Version:        5
Machine:        00C6E13E4C00
Instance name: webm
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 2936954, image: oracle@sss (J001)

*** SESSION ID:(23.1) 2008-06-14 10:42:55.143
OPIRIP: Uncaught error 1089. Error stack:
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-00448: normal completion of background process


Thanks in advance
0
Comment
Question by:rengudi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 21803294
If a job fails it will automatically resubmit itself 1 minute later, if fails again 2 minutes later, if fails again 4 minutes later, etc. doubling each time until it either succeeds, or fails 16 times.
If the doubled resubmit would exceed the normal reexecution time then it will submit at the normal time.


If a data base is shutdown and restarted any jobs that were supposed to run while it was down will be automatically run as soon as the database starts.
0
 

Author Comment

by:rengudi
ID: 21811280
Hi,

  Actually that job wasnt failed on that day and hardly it tooks 2-3 hrs to complete the job.we scheduled the job at 5 Am everyday. we have shutdown the database at 10:42 , and started up 4:30 PM in the evening.
 
  One more thing we have killed the job forcibly from OS level using kill -9 option for making other script run sucessfully.  Actually the job cleaning up the data from the few tables which are old 30 days.

  My question here is "By killing the job is there any chance to corrupt the data"?
And is there any chance to get the logs to investigation on this. we are not enable the trace on.

Thanks in Advance.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 21812066
different kinds of corruption could occur.  If you have commits in your job and part A commits but part B did not get a chance to before it was killed then your data is now out of synch.
trace would not help you here, except possibly to tell you what step in your job you were on.

depending on what kind of logs you are talking about definitely.  If your application writes logs itself (it should) maybe, maybe not.  Depends on if those logs were written before the kill
if you're talking about oracle's archive and/or redo logs.  it depends on if your database is in archive log mode.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question