Create common user is hang in CDB database (Doc ID 3022625.1)

Last updated on MAY 15, 2024

Applies to:

Symptoms

Create Common user is hanging:
++++++++++++++++++++++++++++

22:01:10 SQL> create user C##USER_NAME identified by ******* container=all;
create user C##USER_NAME identified by *******
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation


Elapsed: 00:25:43.45

+++++++++++++++

But when they try to create with this set, it is only creating user in Container not on Pluggable DB.


SQL> alter session set "_oracle_script"=TRUE;

Session altered.

SQL> create user C##USER_NAME identified by ****** container=all;

User created.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.