Home » RDBMS Server » Server Utilities » ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload (11g, 11.2.0.3, Window 7)
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633349] Mon, 16 February 2015 23:48 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

While doing import, getting the below error -

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
 LPX-00210: expected '<' instead of 'A'



Though, log file of expdp doesn't shows any error.-

Master table "SYSTEM"."SYS_EXPORT_FULL_14" successfully loaded/unloaded
******************Master table "SYSTEM"."SYS_EXPORT_FULL_15" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_15 is:
  E:\DP_DIR\EXPDP_TAGIDEV_30_26_17022015.DMP
Job "SYSTEM"."SYS_EXPORT_FULL_15" successfully completed at 09:12:12


There's no character set problem. Characterset is same.

Please suggest what could be the issue? Why do I unable to import the dump?

Dump is taken from 11.2.0.1 database and importing it in 11.2.0.3 database.

Regards,
Ashish Kumar Mahanta
Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633350 is a reply to message #633349] Tue, 17 February 2015 00:02 Go to previous messageGo to next message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the complete command for export and import as well as the 20 first lines of export log and complete import log.

Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633353 is a reply to message #633350] Tue, 17 February 2015 00:11 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

Please find the part of log files -

IMPdp -

;;; 
Import: Release 11.2.0.3.0 - Production on Tue Feb 17 09:43:45 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
 LPX-00210: expected '<' instead of 'A'


EXPDP -

;;; 
Export: Release 11.2.0.1.0 - Production on Tue Feb 17 07:53:03 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_15":  system/******** DUMPFILE=EXPDP_TAGIDEV_30_26_17022015.DMP LOGFILE=EXPDP_TAGIDEV_30_26_17022015.LOG EXCLUDE=STATISTICS DIRECTORY=dp_dir_tagidev FULL=Y parallel=4 
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TTotal estimation using BLOCKS method: 29.92 GB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PProcessing object type DATABASE_EXPORT/TABLESPACE
. . exported "INS"."SERVICE_TRANSACTION_LOG"             1.200 GB 6038959 rows
. . exported "INS"."UWMST_MORATORIUM_BCKUP"              8.641 GB 74839601 rows
. . exported "REINS"."RI_TD_EXECUTION_LOG"               52.55 MB 1476853 rows
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/AUDIT_OBJ
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/JAVA_SOURCE
Processing object type DATABASE_EXPORT/SCHEMA/JAVA_CLASS/JAVA_CLASS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/EVENT/TRIGGER
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/MATERIALIZED_VIEW_LOG
Processing object type DATABASE_EXPORT/SCHEMA/JOB
Processing object type DATABASE_EXPORT/SCHEMA/REFRESH_GROUP
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
. . exported "BATJOB"."BATCH_ERROR_LOG"                  617.3 MB 1183101 rows
Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633355 is a reply to message #633353] Tue, 17 February 2015 00:17 Go to previous messageGo to next message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What were the command lines?
Try to import just using SQLFILE to get the DDL.

[Updated on: Tue, 17 February 2015 00:17]

Report message to a moderator

Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633369 is a reply to message #633355] Tue, 17 February 2015 04:29 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

I tried to import on new env. Same error is appearing there also.

C:\Users\3131540>impdp dumpfile=EXPDP_TAGIDEV_30_26_17022015.DMP sqlfile=ddl_script.sql directory=dp_dir

Import: Release 11.2.0.3.0 - Production on Tue Feb 17 15:57:29 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_SQL_FILE_FULL_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
 LPX-00210: expected '<' instead of 'A'



Please suggest, how to procced with this dump???

Regards
Ashish Kumar Mahanta
Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633370 is a reply to message #633369] Tue, 17 February 2015 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Please suggest, how to procced with this dump???


I post questions in order to find it, so be patient and answer ALL my questions.

Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633372 is a reply to message #633370] Tue, 17 February 2015 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There may be a problem in your export:
DUMPFILE=EXPDP_TAGIDEV_30_26_17022015.DMP ... parallel=4

4 processes on 1 file, I don't know if Oracle have worked with only 1 process or if the 4 ones are writing into a single file which should screw it.

Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633379 is a reply to message #633353] Tue, 17 February 2015 05:29 Go to previous messageGo to next message
John Watson
Messages: 7937
Registered: January 2010
Location: Global Village
Senior Member
Could the dump file have been damaged? Can you compare the size and timestamp with the original?
Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633383 is a reply to message #633349] Tue, 17 February 2015 06:26 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3146
Registered: May 2013
Location: World Wide on the Web
Senior Member
ashishkumarmahanta80 wrote on Tue, 17 February 2015 11:18

Dump is taken from 11.2.0.1 database and importing it in 11.2.0.3 database.


This should not be an issue. Even the Doc ID 553337.1 says so in the compatibility table. But still, can you once try with the parameter VERSION.
Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633384 is a reply to message #633383] Tue, 17 February 2015 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Can you use a VERSION value that is greater than your current version?

Edit: Ah OK, you mean on the import, not the export.

[Updated on: Tue, 17 February 2015 06:32]

Report message to a moderator

Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633385 is a reply to message #633384] Tue, 17 February 2015 06:34 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3146
Registered: May 2013
Location: World Wide on the Web
Senior Member
Yes, I mean in the import with the lower version of the exported dump.
Re: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload [message #633386 is a reply to message #633385] Tue, 17 February 2015 06:39 Go to previous message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Well, he could try but I don't think this is the problem.
I think the problem is during the first step of analyzing the dump file, getting the meta data.

@OP, you can use VERSION on import only with SQLFILE parameter.

Previous Topic: ORA-39166 error
Next Topic: Export Statistics of schema from the database
Goto Forum:
  


Current Time: Mon Jun 24 22:26:32 CDT 2019