My Oracle Support Banner

Oracle9i: EXP-8 ORA-3113 ORA-1041 EXP-0 While Exporting Using MTS (Doc ID 205442.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2]
z*OBSOLETE: Microsoft Windows
***Checked for relevance on 05-Jul-2013***



1. Oracle9i Enterprise Edition Release on MS-Windows Platform.

2. Multi-Threaded Server option (MTS) is configured, e.g.:

SQL> connect / as sysdba
SQL> SELECT name, value
     FROM   v$parameter
     WHERE  name in ('dispatchers', 'max_dispatchers', 'circuits', 'shared_servers', 'max_shared_servers', 'shared_server_sessions');

NAME                       VALUE
-------------------------- ---------------
dispatchers                (protocol=TCP)
max_dispatchers            5
circuits                   170
shared_server_sessions     165
shared_servers             1
max_shared_servers         20

3. Invoke Export utility, and connect using Oracle9i Net to a shared server,

#> exp system/passwd@t920 full=y file=exp_full.dmp log=exp_full.log


1. Export terminates unsuccessfully with:

. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00008: ORACLE error 1041 encountered
ORA-01041: internal error. hostdef extension doesn't exist
EXP-00000: Export terminated unsuccessfully

2. In alert_<SID>.log in BACKGROUND_DUMP_DEST, you see that a shared server has crashed:

found dead shared server 'S000', pid = (10, 1)

3. In trace file of the shared server (e.g.: <SID>_s000.trc) in USER_DUMP_DEST you can find the following line (example):

07/30/2002 09:27:14 UNWIND with no STOPEXIT active.


1. You recently upgraded to Oracle9i release 2 (9.2.0.x).

2. You recently configured the Multi-Threaded Server (MTS) Option in order to enable shared server connections to the database


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.