Small bug encountered when NOCDB to PDB

Source: Internet
Author: User
Tags sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.