You can get ” ORA-65096: invalid common user or role name ” error while creating new user in Oracle 12c.
When i create new user in Oracle 12c , i got following error.
[oracle@MehmetSalih ]$ sqlplus / as sysdba SQL*Plus: Release 220.127.116.11.0 Production on Thu Mar 21 10:01:05 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> create user mehmet identified by mehmet; create user mehmet identified by mehmet * ERROR at line 1: ORA-65096: invalid common user or role name
To solve this problem, execute following query and try to create new user again.
alter session set "_ORACLE_SCRIPT"=true;
Do you want to learn Oracle Database for Beginners, then read the following articles.
832 views last month, 2 views today