After Creating Oracle Database 19c CDB and Run catmgd.sql Result in "ORA-28010: cannot expire external users, global users, or users with no authentication method"
(Doc ID 2861024.1)
Last updated on APRIL 11, 2022
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
After creating Oracle Database 19c CDB, as from below document, running catmgd.sql resulted in below error.
2.2 Database Installation
9. Create the CDB MGDSYS schema
Error
.. lock the user and expire the password
alter user MGDSYS ACCOUNT LOCK PASSWORD EXPIRE
*
ERROR at line 1:
ORA-28010: cannot expire external users, global users, or users with no
authentication method
Steps
1. Create a fresh new EBS 12.2 instance using StartCD 51
2. Perform all the steps as described in
Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)
Section 2: Upgrading an Oracle E-Business Suite Release 12 Database to Oracle Database 19c
until
2.2 Database Installation
9. Create the CDB MGDSYS schema
3. Use SQL*Plus to connect to the CDB as SYSDBA and run the $ORACLE_HOME/rdbms/admin/catmgd.sql script.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |