Urgent !! Oracle -end-of-file on communication channel
Posted: Fri Dec 03, 2004 4:36 am
Hi,
I have a very simple PX job: Oracle stage --> copy
The DB version is Oracle 8
Evry other time I execute the job it fails after few minutes because of oracle error - ORA-03113: end-of-file on communication channel
The table is quite a big one
I checked with the oracle DBA and there is no session limit. I did a test with 15 SQLPLUS sessions executing the same SQL and it did not fail.
Other Datastage jobs connects to Oracle 9 so I have a 9 client with 32bit lib (maybe this gives a clue)
Does anyone has an idea ?
Cheers,
Amos
I have a very simple PX job: Oracle stage --> copy
The DB version is Oracle 8
Evry other time I execute the job it fails after few minutes because of oracle error - ORA-03113: end-of-file on communication channel
The table is quite a big one
I checked with the oracle DBA and there is no session limit. I did a test with 15 SQLPLUS sessions executing the same SQL and it did not fail.
Other Datastage jobs connects to Oracle 9 so I have a 9 client with 32bit lib (maybe this gives a clue)
Does anyone has an idea ?
Cheers,
Amos