"Role" errors in importing demo libraries
- Article Type: General
- Product: Aleph
- Product Version: 22
Problem Symptoms:
Importing the demo libraries (Aleph Installation Kit doc, Appendix B) after the manual database creation (Aleph Installation Kit doc, Appendix A) and after running Upgrade Express, the log contains many errors, such as:
"ROLE_GRANT failed to create with error",
"role 'ALEPH_SCHEMA' does not exist",
"Object type TABLESPACE_QUOTA failed to create with error", and
"tablespace 'LOG' does not exist"
Cause:
Uncertain.
Resolution:
If "imported "USM01"."Znn" lines, indicating success, are seen later in the log and if util f/4 and util a/17/11/1 for usm01, usm50, etc.,shows that the records are there, errors such as the preceding can be ignored.
See Additional Information below for example.
Additional Information
Excerpts from log:
Master table "ALEPH_ADMIN"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "ALEPH_ADMIN"."SYS_IMPORT_FULL_01": ALEPH_ADMIN/******** DIRECTORY=DUMPDIR DUMPFILE=aleph_22_demo%U.dmp PARALLEL=8 CLUSTER=NO LOGFILE=aleph_22_demo.import.1405191127.log remap_tablespace=TS4X:TS1
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"EXT01" already exists
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'ALEPH_SCHEMA' does not exist
Failing sql is:
GRANT "ALEPH_SCHEMA" TO "EXT01"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'ALEPH_SCHEMA' does not exist
Failing sql is:
GRANT "ALEPH_SCHEMA" TO "UNI60"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'ALEPH_SCHEMA' does not exist
Failing sql is:
GRANT "ALEPH_SCHEMA" TO "UNI50"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'ALEPH_SCHEMA' does not exist
...
...
DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "EXT04" QUOTA UNLIMITED ON "LOG"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''LOG'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
ORA-00959: tablespace 'LOG' does not exist
Failing sql is:
DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "EXT03" QUOTA UNLIMITED ON "LOG"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''LOG'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
ORA-00959: tablespace 'LOG' does not exist
Failing sql is:
...
...
DECLARE TEMP_COUNT NUMBER; SQLSTR VARCHAR2(200); BEGIN SQLSTR := 'ALTER USER "VIR01" QUOTA UNLIMITED ON "LOG"'; EXECUTE IMMEDIATE SQLSTR;EXCEPTION WHEN OTHERS THEN IF SQLCODE = -30041 THEN SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES WHERE TABLESPACE_NAME = ''LOG'' AND CONTENTS = ''TEMPORARY'''; EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "USM01"."Z01" 111.5 MB 476509 rows
. . imported "USM10"."Z01" 121.0 MB 512593 rows
. . imported "USR00"."Z304" 180.8 MB 200283 rows
<etc.>
Category: System Management (500)
- Article last edited: 5/21/2014