Posts

Showing posts from July 16, 2017

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.