Oracle9i: EXP-8 ORA-3113 ORA-1041 EXP-0 While Exporting Using MTS

(Doc ID 205442.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Facts

1. Oracle9i Enterprise Edition Release 9.2.0.1.0 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


Symptoms

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.

Changes

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

Cause

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 hundreds of Community platforms