Troubleshooting | Oracle - Database

Issue / Error Message: ORA-65096: invalid common user or role name
View More

Scenario: You have installed Oracle database like 18c Express Edition etc and trying create a user or role that throws the above error.

Cause: The default configuration is causing this issue.

Solution: Either you should follow the proper naming convention as expected/configured in your database OR if you wan’t to override and create user/role, you can run the below command to resolve the issue.

alter session set “_ORACLE_SCRIPT”=true;

Caution: It is better to connect with your DBA before changing any such values unless you are trying out anything in development/evaluation kind of environment.