Skip to Main Content

SQL & PL/SQL

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!

ORA-65096: invalid common user or role name

User_LWI0VMay 5 2021 — edited May 6 2021

I was trying to connect to sqlplus using cmd using system and my password. I used to get this error initially
"ORA-12154: TNS:could not resolve the connect identifier specified" After a lot of googling and searching in stack overflow. I found out that there should not be @ in my password. I have changed my password and tried connecting again.
This time it let me in.
Now I'm trying to create a user named infarep using the command "create user infarep identified by infarep" and now it is throwing out the error
"ERROR at line 1:
ORA-65096: invalid common user or role name"
I tried searching a lot of blogs and stack overflow solutions but did not find any answer for this.
I have followed this post https://community.oracle.com/tech/developers/discussion/4288833/ora-65096-invalid-common-user-or-role-name
and the blog by @edstevens1
Help! I can’t connect to my database … (0 Bytes)Any help is appreciated
Attached with my tnsnames.ora file as well.
Note: I have uninstalled and installed oracle again. I didn't face any such problems for the first time but I'm facing them now.
Thank you.
Avinash NVSK
tns.txt (630 Bytes)
oracle error.JPG

Comments
Post Details
Added on May 5 2021
13 comments
1,977 views