Re: Seeking help with ORA-03113, ORA-01041, exp

On 6 Apr 2004 22:08:19 -0700, Allan Streib <streib_at_cs.indiana.edu> wrote:

> I wrote:
>
>> Trying to perform a full export of a database, I get the following.
>> This
>> is repeatable and fails at the same point every time.
>
> [...]
>
>> 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
>
> I have found that this is avoidable by using a DEDICATED connection.
>
> Also have received indications that this may be due to undersized
> large pool, but have not definitively confirmed this.
>
> Allan

Crikey! You mean you actually tried exporting with a shared server? Not a good idea... when you hijack a shared server for X minutes (or possibly even hours) to perform an export, you might as well have just gone for a dedicated process in the first place. Shared servers should not be used for any job that takes more than a couple of seconds.

Even so, whilst shared servers place some of their memory in the Large Pool if one's available, I would have thought you would have seen ORA-04031 errors if it was anything at all to do with the Large Pool.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================