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