How can I solve the issue of “ORA-65096”?
When I was busy in the process of designing a new user in an Oracle-based database, I encountered a scenario in which an error message occurred which was showing “ORA-65096”. Now I am puzzled about this particular error. What is the reason behind this error and how can I get rid of this particular issue?
In the context of SQL, If you are getting the issue of “ORA-65096” then it reflects an attempt to create a user with a common use name without specifying the containers. This particular issue generally occurs in an environment of multilatent where you generally have a pluggable database within the container database. Here is the solution given to troubleshoot this particular issue:-
Specify the containers
As we discussed above this issue could be raised when you do not specify the container. Therefore firstly, try to specify the container when creating a user to avoid the error of ORA-65096. Here is the example given:-
CREATE USER username IDENTIFIED BY password CONTAINER = ALL;After the session
Now, you can alter the session to set the current container. It will allow user creation even without specifications needed each time. For example:-
ALTER SESSION SET CONTAINER = container_name;
CREATE USER username IDENTIFIED BY password;Check common users
Try to ensure and verify that the user name which you are attempting to create should be not already included in a common user in the root container. If the name is already existed try to rename the users or try to create it in a pluggable database.