After nocdb to the PDB, an application account was found. Export from PDB using EXPDP. Import additional nocdb. Error ora-01917:user or role ' HUE ' does not exist
[Email protected] ~]$ more 1HUE.log
;;;
Import:release 12.2.0.1.0-production on Wed 9 23:20:59 2018
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to:oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production
Master table "SYSTEM". " Sys_import_full_01 "Successfully loaded/unloaded
Import done in Al32utf8 character set and Al16utf16 NCHAR character set
Export done in UTF8 character set and Al16utf16 NCHAR character set
Starting "SYSTEM". " Sys_import_full_01 ": system/******** directory=test dumpfile=hue.dmp Logfile=1hue.log
Processing Object Type Schema_export/system_grant
Ora-39083:object type System_grant failed to create with error:
Ora-01917:user or role ' HUE ' does not exist
Failing SQL is:
GRANT CREATE SESSION to "HUE"
Ora-39083:object type System_grant failed to create with error:
Ora-01917:user or role ' HUE ' does not exist '.
Above the PDB, use this account to log in to the database and report the following errors
Errors in File/u01/app/oracle/diag/rdbms/bigcdb/bigcdb/trace/bigcdb_ora_32410.trc (incident=241057) (PDBNAME=CDB$ ROOT):
Ora-00600:internal error code, arguments: [KZIAVRFYACCTSTATINROOTCBK:!user], [HUE], [], [], [], [], [], [], [], [], [], []
Incident details in:/u01/app/oracle/diag/rdbms/bigcdb/bigcdb/incident/incdir_241057/bigcdb_ora_32410_i241057.trc
Processing method:
Alter session set CONTAINER=MANCO2;
CREATE TABLE backup_user$ as SELECT * from user$;
Update user$ set spare1=0 where name= ' apex_public_user ';
Commit
Conn/as SYSDBA
Shutdown abort
Startup
Finding on MoS is a bug.
ORA-00600 when Trying to Connect Through the SQL Plus using the Apex_public_user after Conversion of A non-cdb to PDB on 1 2.2 Database (document ID 2309896.1)
In this Document
Applies To:
Oracle Application Express (formerly HTML DB)-Version 4.0.2.00.07 and later
Information in this document applies to any platform.
Symptoms
After conversion from a non-cdb (12CR2) to a PDB with Noncdb_to_pdb.sql, when trying to connect to the new PDB as Apex_pub Lic_user using Sql*plus The following error is raised:
[Email protected] admin]$ Sqlplus
Apex_public_user/[email Protected]_adress:1521/manco2
Sql*plus:release 12.2.0.1.0 Production on Fri APR 28 08:34:05 2017
Copyright (c) 1982, Oracle. All rights reserved.
ERROR:
Ora-00600:internal error code, arguments: [KZIAVRFYACCTSTATINROOTCBK:
!user],
[Apex_public_user], [], [], [], [], [], [], [], [], [], []
Cause
The issue have been identified as the product defect and documented over the Bug 25979661-ora-00600: [Kziavrfyacctstatinr OOTCBK:! USER] [Apex_public_user]
Solution
The bug is still being worked by the development and the workaround are available to override this issue.
As a workaround you can make Apex_public_user local USER by updating User$.spare1 column in the PDB.
Sqlplus/as SYSDBA
Alter session set CONTAINER=MANCO2;
CREATE TABLE backup_user$ as SELECT * from user$;
Update user$ set spare1=0 where name= ' apex_public_user ';
Commit
Conn/as SYSDBA
Shutdown abort
Startup
REFERENCES
bug:25979661-ora-00600: [KZIAVRFYACCTSTATINROOTCBK:! USER] [Apex_public_user]
Small bug encountered when NOCDB to PDB