19c创建用户报错ORA-65096 公用用户名或角色无效,如下所示
SQL> create user user_tts identified by tts;
create user user_tts identified by tts *
ERROR at line 1:
ORA-65096: invalid common user or role name
原来oracle19c在cdb中创建公共用户名必须要以c##或者C##开头,如下添加上c##,成功创建用户.
SQL> create user c##tsp_tts identified by tts;
User created.