| Oracle 10G on linux export fails [message #99217] |
Fri, 05 November 2004 18:29  |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
Got an oracle instance on linux when I go manulay to export a user I get a bunch of error messages and also on oracle log
ORA-07445: exception encountered: core dump [[joe_well_known_internal()+102]] [[SIG
SEGV]] [[Address not mapped to object]] [[0xC330421C]] [[]] [[]]
Fri Nov 5 23:08:47 2004
Errors in file /u0/oracle/log/test_ora_4161.trc:
ORA-07445: exception encountered: core dump [[joe_well_known_internal()+102]] [[SIG
SEGV]] [[Address not mapped to object]] [[0xB927E124]] [[]] [[]]
Fri Nov 5 23:16:35 2004
Private_strands 7 at log switch
Thread 1 advanced to log sequence 89
Current log# 1 seq# 89 mem# 0: /u0/oracle/datafiles/TEST/redo01.log
Fri Nov 5 23:28:28 2004
Errors in file /u0/oracle/log/test_ora_4687.trc:
ORA-07445: exception encountered: core dump [[joe_well_known_internal()+102]] [[SIG
SEGV]] [[Address not mapped to object]] [[0xE662D634]] [[]] [[]]
$ exp system/manager file=test1.dmp log=test1.log full=y statistics=none
Export: Release 10.1.0.2.0 - Production on Fri Nov 5 23:28:26 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00000: Export terminated unsuccessfully
$
|
|
|
|
| Re: Oracle 10G on linux export fails [message #99218 is a reply to message #99217] |
Sun, 07 November 2004 11:27  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
I'm unable to reproduce your problem - might be something wrong on your system.
<pre<[[oracle@orafaq admin]]$ exp system/oracle file=test1.dmp log=test1.log full=y statistics=none
Export: Release 10.1.0.2.0 - Production on Sun Nov 7 23:45:12 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL 0 rows exported
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
. . exporting table DEF$_DEFAULTDEST 0 rows exported
. . exporting table DEF$_DESTINATION 0 rows exported</pre>
Try to relink the Oracle utilities ($ relink utilities). If all else fails, use expdp (data pump), or log a TAR with Oracle support for assistance.
Best regards.
Frank
|
|
|
|
| Re: Oracle 10G on linux export fails [message #99223 is a reply to message #99217] |
Wed, 10 November 2004 00:24 |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
According to me this problem is not related to exp/imp. On 10g you should have java_pool_size >= 30m and shared_pool_size >= 60m. If your java_pool_size is less than this value so try to increase it. I also faced the same problem and solved by increasing the java_pool_size value.
Better if you tell us your java, shared and large pool settings and upload the trace file too.
Daljit Singh.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
