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!

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
Post Details
Added on Aug 22 2019
8 comments
744 views