ORA-03113 while exporting

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

ORA-03113 while exporting

ORA-03113 while exporting

2005-10-12 - By Susan White

Reply: 1 2 3 4 5

I have seen a similar situation caused by an incomplete install of the java
engine. I can't find my documentation but it should be on Metalink.

=======================

Gabriel Hanauer <gabriel.hanauer@(protected)> wrote:

> Database is 9.2.0.6.0 running on a windows 2000 server.

>

> Every time when a try to do a full export of the database the following
error

> occurs:

>

> . exporting foreign function library names

> . exporting PUBLIC type synonyms

> EXP-00008: ORACLE error 3113 encountered

> ORA-03113 (See ORA-03113.ora-code.com): end-of-file on communication channel

> EXP-00000: Export terminated unsuccessfully

>

> No errors in the alert file and no traces.

> The only file generated is a core file in the cdump dir.

>

> Im restored the database on another server and applied the patchset
9.2.0.7.

> But the error is still there.

>

> I also tried to do a export using transportable tabpespaces. But some

> users have materialized views.

> And when a try drop those views the same error raised up.

>

> I also tried to do a backup with RMAN. But no success.

>

> Any idea?

>

> --

> Gabriel Hanauer

> DBA Oracle

> --

> http://www.freelists.org/webpage/oracle-l
<http://www.freelists.org/webpage/oracle-l>

>

__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">

<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>


I have seen a similar
situation caused by an incomplete install of the java engine.  I can&#8217
;t
find my documentation but it should be on Metalink.<o:p></o:p>


=======================<o:p>
</o:p>


<o:p> </o:p>


Gabriel Hanauer
<gabriel.hanauer@(protected)> wrote:<o:p></o:p>


<o:p> </o:p>


> Database is 9.2.0.6.0
running on a windows 2000 server.<o:p></o:p>


> <o:p></o:p>


> Every time when a try
to do a full export of the database the following error<o:p></o:p>


> occurs:<o:p></o:p>


> <o:p></o:p>


> . exporting foreign
function library names<o:p></o:p>


> . exporting PUBLIC type
synonyms<o:p></o:p>


> EXP-00008: ORACLE error
3113 encountered<o:p></o:p>


> ORA-03113 (See ORA-03113.ora-code.com): end-of-file
on communication channel<o:p></o:p>


> EXP-00000: Export
terminated unsuccessfully<o:p></o:p>


> <o:p></o:p>


> No errors in the alert
file and no traces.<o:p></o:p>


> The only file generated
is a core file in the cdump dir.<o:p></o:p>


> <o:p></o:p>


> Im restored the
database on another server and applied the patchset 9.2.0.7.<o:p></o:p>


> But the error is still
there.<o:p></o:p>


> <o:p></o:p>


> I also tried to do a
export using transportable tabpespaces. But some<o:p></o:p>


> users have materialized
views.<o:p></o:p>


> And when a try drop
those views the same error raised up.<o:p></o:p>


> <o:p></o:p>


> I also tried to do a
backup with RMAN. But no success.<o:p></o:p>


> <o:p></o:p>


> Any idea?<o:p></o:p>


> <o:p></o:p>


> --<o:p></o:p>


> Gabriel Hanauer<o:p></o
:p>


> DBA Oracle<o:p></o:p>


> --<o:p></o:p>


> <a
href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</a><o:p></o:p>


> <o:p></o:p>


<o:p> </o:p>


<o:p> </o:p>


<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

</div>

 
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ 
This email has been scanned by the MessageLabs Email Security System. 
For more information please visit http://www.messagelabs.com/email 
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ 
</body>

</html>