Problem with ORA -03113 End of Communication Channel
680108Sep 1 2010 — edited Sep 1 2010Hello,
Oracle Database 10g Release 10.2.0.1.0 - Production
Windows Server 2003 Version V5.2 Service Pack 2
Im having this problem when executing an stored procedure that executes a SQL statement wich has uses db links... I get this end of communication channel error.. so I thought it was a network issue, but all connections are fine.
The thing is that the procedure works fine, but just out of the nothing starts to give that problem, shutting down the database would not correct the problem, only restarting the server will fix the issue temporarily. I checked the dump file related to the process am running and I found this, I think it might be like a memory problem but not sure
Windows thread id: 5632, image: ORACLE.EXE (J002)
*** ACTION NAME:() 2010-09-01 09:18:59.490
*** MODULE NAME:() 2010-09-01 09:18:59.490
*** SERVICE NAME:(SYS$USERS) 2010-09-01 09:18:59.490
*** SESSION ID:(545.34045) 2010-09-01 09:18:59.490
*** 2010-09-01 09:18:59.490
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kghalf+478] [PC:0x603BEB04] [ADDR:0x61E26AE8] [UNABLE_TO_WRITE] []
No current SQL statement being executed.
what do you recommend me to try here?