ORACLE12C Create user prompt ORA-65096: Invalid public user name or role

1. Background

Used to be oracle11g, create users have no problem, today on the oracle12c to create users, error. Such as:

I was depressed, opened the Oracle official website to find the next, found that the creation of the user is limited.

2. Solution

User name in C # #或者C # #开头即可 when creating a user.

Error wording: Create user Zhaojiedi identified by Oracle; correct notation: Create User C # #zhaojiedi identified by Oracle;

Note: If you do not struggle with why, the above solution can meet your requirements, the following content can not be looked at.

========================================================================

========================================================================

3. Resolution Process

The following process is my solution to this problem, also written to share.

I entered the Oracle 12c official documentation

Go to the following page

ORACLE12C Home

Administrator ' s Guide

Managing Users and securing the Database

Oracle Database Security Guide

Creating User Accounts

After a search, the Creating User Accounts page found something like:

The above hints are very clear. Creating a public user name must be #开头了 in C # #或者C #. We have an error above. It's because we're creating a public user that doesn't use C # #或者C # #开头的.

By this we will know the reason for the specific mistake. Then the winning solution is there.

If you still have a tangle of public and local users, theCreating user Accounts page has an introduction.

oracle12c Create user prompt ORA-65096: Public user name or role is not valid