Error received when using TOAD to access Procedures to load a package:
"ORA-03113 end-of-file on communication channel"
Once you click OK, the Procedures section shows an empty list.
This is an Oracle issue.
Dead Shared Servers And Connections Fail with ORA-3113 Calling External Procedures
Doc ID 333026.1 Type: PROBLEM
Last Revision Date: 03-MAR-2006 Status: MODERATED
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7 to 10.1.0
This problem can occur on any platform.
Symptoms
User connections fail with ORA-3113 and ORA-3114 errors when calling external procedures.
Alert log shows the following.
Wed Aug 10 16:58:29 2005
found dead shared server 'S000', pid = (15, 125)
found dead shared server 'S001', pid = (27, 89)
Wed Aug 10 17:12:38 2005
found dead shared server 'S000', pid = (15, 126)
Wed Aug 10 17:20:19 2005
found dead shared server 'S003', pid = (29, 154)
Changes
1. Using shared servers. (MTS)
2. Calling external procedures.
Cause
Internal Bug 3243584 - Shared Servers Crash If Hs (Heterogeneous Services routine, which is used by external procedures) Session Can Migrate
The stack trace from the core logs generated, indicate failure in these routines.
ncrflctx
ncrowht
_horcsX_SendExecCall
Solution
1. Apply patch 3243584.
-or-
2. A temporary fix or workaround would be to switch to dedicated connections instead of running shared servers. (MTS)
