ORA-65096: invalid common user or role name

最新推荐文章于 2025-06-11 11:25:24 发布

转载最新推荐文章于 2025-06-11 11:25:24 发布 · 1.3k 阅读

IT管理专栏收录该内容

29 篇文章

订阅专栏

本文详细解析了在Oracle CDB中创建用户时遇到ORA-65096错误的原因及解决方案，重点在于用户名称的正确命名方式，即必须以'C##'或'c##'开头，并且只包含ASCII字符。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sys@LUOCS12C> create user luocs identified by oracle default tablespace luocs;
create user luocs identified by oracle default tablespace luocs
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

sys@LUOCS12C> !oerr ora 65096
65096, 00000, "invalid common user or role name"
// *Cause:  An attempt was made to create a common user or role with a name
//          that wass not valid for common users or roles.  In addition to 
//          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.
// *Action: Specify a valid common user or role name.
//
根据错误提示了解，在CDB中用户得以C##开头，如下：
sys@LUOCS12C> create user c##luocs identified by oracle default tablespace luocs;

User created.