Sunday, May 14, 2017

ORA-65096: invalid common user or role name oracle database 12c



              ORA-65096: invalid common user or role name



Cause: when you create a common user in oracle database 12c  it was  invalid for common users or roles. The usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.

SQL> create user tra identified by tra default tablespace users;
create user tra identified by tra default Tablespace users
            *
ERROR at line 1:
ORA-65096: invalid common user or role name










Action: Specify a valid common user or role name.
The solution to the ORA-06596 is to set a hidden parameter "_oracle_script".  When you set the undocumented (hidden) parameter "_oracle_script"=true  you can create the tra user without a C## in from of the user ID.  therefore this user will not used useful in a pluggable/container database.

SQL> alter session set "_ORACLE_SCRIPT"=true;

Session altered.


SQL> create user tra identified by tra ;

User created.

SQL> grant dba to tra;

Grant succeeded.



No comments:

Post a Comment