Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

encounter "ORA-03113 : end-of-file on communication channel error "

744607May 26 2010 — edited May 27 2010

Hi experts :

I schedule a job of MS SSIS(SQL 2005) to do data transfer from Oracle to MS sql server every morning. Few days ago, SQL server report an error as bellow

錯誤: 2010-05-26 06:04:27.87
代碼: 0xC0202009
來源: Package 連接管理員 "pro.twacelifeapp"
描述: 發生 OLE DB 錯誤。錯誤碼: 0x80004005。
有 OLE DB 記錄可用。來源: "OraOLEDB" Hresult: 0x80004005 描述: "ORA-03113 : end-of-file on communication channel error"。
錯誤結束

"ORA-03113 : end-of-file on communication channel error " happened.
many times It makes SSIS interupt. And the wierd thing is, as I restart SSIS again. Then the process done successfully.
I check Oracle alert.log at the event time, it report "inbound connection timed out (ORA-3136)".
sqlnet.log also list "TNS-12535: TNS:operation timed out".
from the day on, MS SQL server reported this error msg everyday.

I'm really confused and can't find the result of cause.
dose any helps ,thanks~

SQL server version : SQL server 2005
Oracle : Oracle 10g r2

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2010

Added on May 26 2010

#general-database-discussions

5 comments

2,739 views