Dear DBA-Mates, Happy New Year to you all!!!
Hope you all
doing good.
Here, we
would like to share user creation error ORA-65096:
invalid common user or role name in 19c database.
How to create
database user in 19c oracle database because when you create database user in oracle
19c database you may get an ORA error like ORA-65096 as shown below in details.
So, to avoid that user creation error either we can set one hidden parameter to true or else put pre-fix word as c##.
For kind
information without alter of the hidden parameter or pre-fix word c##
you can’t create the user in oracle 19c database like previous version of the
oracle database.
Please find
the below details:
Error:
SQL> show
user
USER is
"SYS"
SQL> create
user ogg identified by ogg account unlock;
create user
ogg identified by ogg account unlock
*
ERROR
at line 1:
ORA-65096:
invalid common user or role name
SQL>
Solutions:
1. Here, we have one hidden parameter which
needs to be set as True as shown in below command:
SQL> alter session set "_ORACLE_SCRIPT"=true;
USER is
"SYS"
SQL>
SQL> GRANT
CONNECT, RESOURCE, DBA TO ogg;
SQL> conn
ogg/ogg
Connected.
SQL> show
user
USER is
"OGG"
SQL>
2. As discussed, there is another method also which can be used here but it will be different like pre-fix word as shown below:
SQL> create user C##OGGS identified by oggs;
SQL>
19c DB aler
log path and details:
[oracle@linux
trace]$ view alert_orcl.log
[oracle@linux
trace]$ pwd
/u01/19cDB/diag/rdbms/orcl/orcl/trace
[oracle@linux
trace]$
SQL>
select name,open_mode from v$database;
NAME OPEN_MODE
---------
--------------------
ORCL READ WRITE
SQL>
SQL>
select BANNER_FULL from v$version;
BANNER_FULL
--------------------------------------------------------------------------------
Oracle
Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version
19.3.0.0.0
SQL>
Some more important
links:
Cloud Service
Models in cloud computing
What is PDB and CDB in oracle 12c