Why does the job reports as successful with Fatal Messages?
Posted: Thu Jul 06, 2006 10:59 am
Database: Oracle 9i
Write Method Used: Load and Append
Index Mode: Rebuild
The problem:
Parallel job reports successful completion even though I get messages like this. I do understand that we have to make ControlM and the Shell script which runs the DS jobs robust enough to abend we get the Fatal errors like this..
The first time I got this Fatal Error, I asked the DBA to increase the TEMP space.
Now I get this, which I am not sure of...
I am trying to understand why does the Parallel job reports as successful if there are Fatal messages in the log. I believe the job should abort..It does abort in many cases where there are fatal messages. Is there a reason for this?
I did search the forum and couldn't find a good reason behind this.
Please advice..
Thank You.
Write Method Used: Load and Append
Index Mode: Rebuild
The problem:
Parallel job reports successful completion even though I get messages like this. I do understand that we have to make ControlM and the Shell script which runs the DS jobs robust enough to abend we get the Fatal errors like this..
The first time I got this Fatal Error, I asked the DBA to increase the TEMP space.
Code: Select all
TEST_TABLE: Oracle call failed; sqlcode = -12801; message: ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
TEST_TABLE: Index `SYS_C001634' on table `TEST_TABLE_B' has NOT been rebuilt.
Code: Select all
TEST_TABLE,0: GenericQuery:esqlErrorHandler
Prepare failed for: GenericStmt_9
query is: SELECT banner FROM V$VERSION
sqlcode is: -3113
esql complaint: ORA-03113: end-of-file on communication channel
.
TEST_TABLE,0: Cannot find the version in v$version.
TEST_TABLE,0: GenericQuery:esqlErrorHandler
Prepare failed for: GenericStmt_10
query is: SELECT banner FROM V$VERSION
sqlcode is: -3114
esql complaint: ORA-03114: not connected to ORACLE
I did search the forum and couldn't find a good reason behind this.
Please advice..
Thank You.