error ORA-65096 invalid common user or role name in oracle

0 votes

I have just completed installing Oracle and it was missing the Scott schema. So I am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query:

create user Scott identified by tiger;

it displays the following error:

ORA-65096: invalid common user or role name in oracle.
Basically it is not allowing me to create a user Scott.

Why is that, and how can I fix my problem?

Feb 16, 2022 in Others by Rahul
• 9,670 points

1 answer to this question.

+1 vote
To start with, the oerr utility is not useful for the ORA-65096 ERROR mentioned below:-

ORA-65096: invalid common user or role name

Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.

Action: Specify a valid common user or role name.

The solution to the ORA-06596 is to set a hidden parameter "_oracle_script".  When you set the undocumented (hidden) parameter "_oracle_script"=true  you can create the fred user without a C## in front of the user ID.  However, this user will not used useful in a pluggable/container database:

connect system/manager as sysdba
alter session set "_ORACLE_SCRIPT"=true;
create user fred identified by flintstone;
grant dba to pubs;

connect fred/flintstone

Always consult Oracle support before using any hidden Oracle parameters. Oracle makes a distinction in multitenant databases for local vs. "common" user ID's wherein, the Common user IDs must always be created at the CDB level and start with a C### prefixes while, the Local users can only be created at the PDB layer, additionally also must use the CONTAINER clause set to CURRENT for the user to be created

answered Feb 16, 2022 by Aditya
• 7,680 points

Related Questions In Others

0 votes
0 answers

how to take user input in in PLSQL

How to take user input in Oracle ...READ MORE

Jun 8, 2022 in Others by polo
• 1,480 points
0 votes
1 answer

Name not recognized error in List.Generate

Try this: let Source = < >, columnsToExpand ...READ MORE

answered Feb 16, 2023 in Others by narikkadan
• 63,700 points
0 votes
1 answer

Using unserialize in PHP throws the same error repeatedly

I googled 'Node no longer exists', and ...READ MORE

answered Nov 14, 2018 in Others by DataKing99
• 8,240 points
0 votes
2 answers

Unable to use jenkins to run oracle script on remote DB

add ORACLE_HOME  in jenkins global variable. READ MORE

answered Mar 27, 2019 in DevOps & Agile by hal
+2 votes
2 answers

How to connect to Oracle using Service Name instead of SID?

HII.. I hope this information may help you- Thin-style ...READ MORE

answered Sep 29, 2020 in Java by SRI
0 votes
1 answer

How can i copy tables from one database to other on AWS?

You can use AWS Data pipeline to ...READ MORE

answered Jul 5, 2018 in AWS by Priyaj
• 58,090 points
–1 vote
1 answer

What is the difference between oracle JDK and open JDK

Both OpenJDK and Oracle JDK are created ...READ MORE

answered Jul 10, 2018 in Java by Akrati
• 3,190 points
0 votes
1 answer

How to fix "Headers already sent" error in PHP

The functions that send and modify the ...READ MORE

answered Feb 17, 2022 in Others by Aditya
• 7,680 points
0 votes
1 answer

'composer' is not recognized as an internal or external command in windows server

For anyone coming here from Google who ...READ MORE

answered Feb 17, 2022 in Others by Aditya
• 7,680 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP