Unable to create schema in CDB$ROOT ORA-65096: invalid common user or role name

Issue :

On pluggable database , unable to create user....

SQL> create user sapsr3 identified by sapsr3;
create user sapsr3 identified by sapsr3
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

Solution:

For this connect as sys or system to the database and set parameter "_ORACLE_SCRIPT' to true.

SQL> alter session set "_ORACLE_SCRIPT"=true;
Session altered.
SQL> create user sapsr3 identified by sapsr3;
User created.

SQL> select username,account_status from dba_users where username='SAPSR3';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SAPSR3                         OPEN

Best Wishes,
Nikhil Kumar.

Comments

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

Queryable inventory could not determine the current opatch status.