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.
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
Post a Comment