Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter system set "_ORACLE_SCRIPT"=true SCOPE=SPFILE;

Maciek1Jul 16 2024

I use Oracle Database 21c Express Edition. I login in SQL Plus “system as sysdba". I command “create user store identified by store_password;”. Then I have the error “ORA-65096: invalid common user or role name”. I tried "alter system set "_ORACLE_SCRIPT"=true SCOPE=SPFILE;" I “shutdown immediate” and “startup”. Then I command “create user store identified by store_password;”. Then I have the error “ORA-65096: invalid common user or role name” again. I can command "alter session set "_ORACLE_SCRIPT" = true;" then command “create user store identified by store_password;” and it works. But alter session is solution only for session. How do it permanently? Could you support me?

Comments
Post Details
Added on Jul 16 2024
3 comments
2,184 views