Urgent! Please Help! Import Failure on 8.0.6 [message #71583] |
Mon, 25 November 2002 14:23 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
Hi,
I have a new Oracle 8.0.6 installation on Solaris 2.5.1 for migration purposes. It has a fresh new database ready for import. The export (exp) works fine. I tried exporting the database and it exports without any problem. I tried using the import (imp) to import back the data and it gives the following error. None of the database imports work (either with the same database export/or different one). Looks like something is missing. Following is the complete steps and resultant errors. Please provide as much detail as possible. Thanks much.
SECTION 1: (EXPORT OF THE DATABASE - NO ERRORS)
oracle: exp
Export: Release 8.0.6.0.0 - Production on Mon Nov 25 13:04:09 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Username: system
Password:
Connected to: Oracle8 Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production
Enter array fetch buffer size: 4096 > 128000
Export file: expdat.dmp > test806.dmp
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in US7ASCII character set and US7ASCII NCHAR character set
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 foreign function library names
. exporting object type definitions
. exporting cluster definitions
. about to export DBSNMP's tables via Conventional Path ...
. about to export TRACESVR's tables via Conventional Path ...
. about to export SCOTT's tables via Conventional Path ...
. . exporting table BONUS 0 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table DUMMY 1 rows exported
. . exporting table EMP 14 rows exported
. . exporting table SALGRADE 5 rows exported
. about to export SYSTEM's tables via Conventional Path ...
. about to export SA's tables via Conventional Path ...
. exporting referential integrity constraints
. exporting posttables actions
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting triggers
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting user history table
. exporting default and system auditing options
Export terminated successfully without warnings.
SECTION-2 (IMPORT OF THE SAME EXPORT FILE - ERRORS)
oracle: imp
Import: Release 8.0.6.0.0 - Production on Mon Nov 25 12:57:28 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Username: system
Password:
Connected to: Oracle8 Release 8.0.6.0.0 - Production
PL/SQL Release 8.0.6.0.0 - Production
Import file: expdat.dmp > test806.dmp
Enter insert buffer size (minimum is 4096) 30720> 128000
Export file created by EXPORT:V08.00.06 via conventional path
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no > yes
Import grants (yes/no): yes >
Import table data (yes/no): yes >
Import entire export file (yes/no): no > yes
IMP-00017: following statement failed with ORACLE error 4068:
IMP-00021: operating system error - error code (dec 2, hex 0x2)
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 49
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
Thanks
|
|
|
Re: Urgent! Please Help! Import Failure on 8.0.6 [message #71584 is a reply to message #71583] |
Mon, 25 November 2002 17:55 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
Almost found the issue, but not the solution. I found a bunch of packages, including the SYS.DBMS_REPCAT_MIG_INTERNAL package which has internal errors (IMPORT uses this). It wouldn't compile. Could anyone explain why these packages are not being compiled?
Following are some of the packages I ge error when re-compiling. help!
MGR-00073: Warning: PACKAGE SYS.DBMS_AQADM created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_AQ_IMPORT_INTERNAL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFERGEN created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFERGEN_AUDIT created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFERGEN_INTERNAL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFERGEN_PRIORITY created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFERGEN_RESOLUTION created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_IMPORT_INTERNAL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_INTERNAL_SYS created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_QUERY created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_QUERY_UTL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_REPCAT created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_SYS created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_DEFER_SYS_PART1 created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_MAINT_GEN created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_OFFLINE_OG created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_OFFLINE_SNAPSHOT created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_AUTH created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_CONF created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_MAS created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_MIG_INTERNAL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_RPC created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_RPC_UTL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_SNA_UTL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_UTL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_UTL3 created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_UTL4 created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPCAT_VALIDATE created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_REPUTIL created with compilation errors.
MGR-00073: Warning: PACKAGE SYS.DBMS_SNAPSHOT created with compilation errors.
Statement processed.
|
|
|
Re: Urgent! Please Help! Import Failure on 8.0.6 [message #71593 is a reply to message #71583] |
Tue, 26 November 2002 14:59 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
Mahesh, I'm getting the same errors I got before. I ran all the above sqls and during that process, I get many compilation errors on many packages. when I try to import, I get the same error:
Import entire export file (yes/no): no > yes
IMP-00017: following statement failed with ORACLE error 4068:
IMP-00021: operating system error - error code (dec 2, hex 0x2)
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 49
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
|
|
|
Re: Urgent! Please Help! Import Failure on 8.0.6 [message #71595 is a reply to message #71593] |
Tue, 26 November 2002 22:47 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
thats wierd!.
becuase these scripts ( in that sequence) drops those packages, recreates them and compiles them.
it should work.
you must be missing something!.
did u add more space to system tables ( for migration?? add around 50% more to system tablspaces)
and startover again.
|
|
|