Troubleshooting
Problem
When attempting to refresh an environment using the refresh steps documented in the OpenPages Administrator's Guide, the IT administrator is having issues the the Oracle IMPDP command. It is throwing Oracle errors.
Symptom
When attempting to run the impdp command, it throws the following sample errors:
| Import: Release 11.2.0.3.0 - Production on Mon Nov 12 15:17:25 2012 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 option Master table "OPENPAGES"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "OPENPAGES"."SYS_IMPORT_FULL_01": openpages/********@OPDEV DIRECTORY=OP_DATAPUMP_DIRECTORY DUMPFILE=openpages_2012_11_10_06_12_12.dmp LOGFILE=openpages_import.log Processing object type SCHEMA_EXPORT/USER ORA-39083: Object type USER failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: CREATE USER "OPENPAGES" IDENTIFIED BY VALUES 'S:C1CD5C3B3EB22EA0D32EC1B1B8BCF9D983AA098F7D23BC9A27A01ED4F6AF;C9DF6C4EC213D6A4' DEFAULT TABLESPACE "AURORA" TEMPORARY TABLESPACE "AURORA_TEMP" Processing object type SCHEMA_EXPORT/SYSTEM_GRANT ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT QUERY REWRITE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE INDEXTYPE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE OPERATOR TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE TYPE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE MATERIALIZED VIEW TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE TRIGGER TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE PROCEDURE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE DATABASE LINK TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE SEQUENCE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE VIEW TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE SYNONYM TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE TABLE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT UNLIMITED TABLESPACE TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT ALTER SESSION TO "OPENPAGES" ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT CREATE SESSION TO "OPENPAGES" Processing object type SCHEMA_EXPORT/ROLE_GRANT ORA-39083: Object type ROLE_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT "RESOURCE" TO "OPENPAGES" ORA-39083: Object type ROLE_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT "DBA" TO "OPENPAGES" ORA-39083: Object type ROLE_GRANT failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: GRANT "SELECT_CATALOG_ROLE" TO "OPENPAGES" Processing object type SCHEMA_EXPORT/DEFAULT_ROLE ORA-39083: Object type DEFAULT_ROLE failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: ALTER USER "OPENPAGES" DEFAULT ROLE ALL Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "AURORA"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''AURORA'' AN ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "INDX"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''INDX'' AND CO ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "AURORA_NL"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''AURORA_N ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "AURORA_NLI"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''AURORA_ ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "AURORA_SNP"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''AURORA_ ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "AURORA_CLOB_DATA"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''A ORA-39083: Object type TABLESPACE_QUOTA failed to create with error: ORA-31625: Schema SYSTEM is needed to import this object, but is unaccessible ORA-01031: insufficient privileges Failing sql is: DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "OPENPAGES" QUOTA UNLIMITED ON "AURORA_DOMAIN_INDX"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ' Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC ORA-39082: Object type TYPE:"OPENPAGES"."SYS_PLSQL_1215331_1135_1" created with compilation warnings ORA-39082: Object type TYPE:"OPENPAGES"."SYS_PLSQL_1215331_1135_1" created with compilation warnings Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/SEQUENCE/AUDIT_OBJ Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA |
[{"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.2.1;6.2;6.1;6.0.1;6.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS4PJS","label":"IBM OpenPages on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
14
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21512738