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.