Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Division by 0 and ORA-07445 while running imp on 18c XE

User_SDELXAug 22 2019 — edited Aug 23 2019

imp 'system/***@xe' file=C:\SHARE\CPSDBBACKUP_08152019.DMP full=yes log=C:\SHARE\implog.txt

Import: Release 18.0.0.0.0 - Production on Thu Aug 22 09:26:18 2019

Version 18.4.0.0.0

...

IMP-00017: following statement failed with ORACLE error 3113:

"CREATE TABLESPACE "EXAMPLE" BLOCKSIZE 8192 DATAFILE  'D:\APP\ORADATA\CPSPRO"

"D\EXAMPLE01.DBF' SIZE 104857600       AUTOEXTEND ON NEXT 655360  MAXSIZE 32"

"767M EXTENT MANAGEMENT LOCAL  AUTOALLOCATE  ONLINE PERMANENT  NOLOGGING SEG"

"MENT SPACE MANAGEMENT AUTO"

IMP-00003: ORACLE error 3113 encountered

ORA-03113: end-of-file on communication channel

IMP-00000: Import terminated unsuccessfully

alert_xe.log

CREATE TABLESPACE "SYSAUX" ...

ORA-1543 signalled during: CREATE TABLESPACE "SYSAUX" ...

CREATE UNDO TABLESPACE "UNDOTBS1" ...

ORA-1543 signalled during: CREATE UNDO TABLESPACE "UNDOTBS1" ...

CREATE TEMPORARY TABLESPACE "TEMP" ...

ORA-1543 signalled during: CREATE TEMPORARY TABLESPACE "TEMP" ...

CREATE TABLESPACE "USERS" ...

ORA-1543 signalled during: CREATE TABLESPACE "USERS" ...

CREATE TABLESPACE "EXAMPLE" ...

Exception [type: INT_DIVIDE_BY_ZERO, ] [] [PC:0x7FFE00843ADB, skgfrcre()+459]

Errors in file E:\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_7588.trc  (incident=20995) (PDBNAME=CDB$ROOT):

ORA-07445: exception encountered: core dump [skgfrcre()+459] [INT_DIVIDE_BY_ZERO] [] [PC:0x7FFE00843ADB] [] []

Incident details in: E:\ORACLE\diag\rdbms\xe\xe\incident\incdir_20995\xe_ora_7588_i20995.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

2019-08-22T09:26:24.445026-04:00

Dumping diagnostic data in directory=[cdmp_20190822092624], requested by (instance=1, osid=7588), summary=[incident=20995].

xe_ora_7588.trc

JMH bmunit: 8  KTFBN_FBMP_MAX_BLOCKS: 262144

Exception [type: INT_DIVIDE_BY_ZERO, ] [] [PC:0x7FFE00843ADB, skgfrcre()+459]

Encountered exception while getting args for function:0x00007FFE20B9F9B0

2019-08-22T09:26:19.108718-04:00

Incident 20995 created, dump file: E:\ORACLE\diag\rdbms\xe\xe\incident\incdir_20995\xe_ora_7588_i20995.trc

ORA-07445: exception encountered: core dump [skgfrcre()+459] [INT_DIVIDE_BY_ZERO] [] [PC:0x7FFE00843ADB] [] []

Thank you

Comments

Processing

Post Details

Added on Aug 22 2019
8 comments
607 views