ORA-01089
Moderators: chulett, rschirm, roy
ORA-01089
Hi All,
One of our jobs failed in a sequence was aborted with the following error
ORA-01089: immediate shutdown in progress - no operations are permitted
we are guessing that possibly the server went down so the sequence aborted. the job was running properly previously. What could be the possible reason for failure. any ideas?
thanks
ash.
One of our jobs failed in a sequence was aborted with the following error
ORA-01089: immediate shutdown in progress - no operations are permitted
we are guessing that possibly the server went down so the sequence aborted. the job was running properly previously. What could be the possible reason for failure. any ideas?
thanks
ash.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi Sai/Craig,
rerun was successful.....obviusly was some db problem....
and my apologies.....
My mistake....my project manager pointed out that the other jobs never completed sucessfully...the status "finished" seeing which i was confused was from the previous day..big oops Sorry and thanks for the attention.
rerun was successful.....obviusly was some db problem....
and my apologies.....
My mistake....my project manager pointed out that the other jobs never completed sucessfully...the status "finished" seeing which i was confused was from the previous day..big oops Sorry and thanks for the attention.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I guess this could be one of the reason, suppose you are retreaving data from Database A; and suppose you are running three jobs simultaniously, at some point of time this databse A got shut down, in thease three jobs two jobs compleated retreavel of the dat and ferforming the transferamtion, so still they are not compleate but they had finished accessing the database, so both of they are not impacted by the database shut down, but the job 3 is still accessing the Databse, obiously third job will abort and first two jobs will compleate. :D
So you can not genaralise things on this basis and think that message throuwn by the datastage is incorrect, most of the times thease messages mean business and there will be reasons for the abort, we have to consider various scenarios and possibilities..
thanks
So you can not genaralise things on this basis and think that message throuwn by the datastage is incorrect, most of the times thease messages mean business and there will be reasons for the abort, we have to consider various scenarios and possibilities..
thanks
RRCHINTALA
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India