Shulou(Shulou.com)06/01 Report--

Today, I would like to talk to you about what the solution of ora-65096 is, many people may not know much about it. In order to make you understand better, the editor summarized the following content for you. I hope you can get something according to this article.

Create a command:

Create user newuser identified by newuser

Error: ORA-65096: invalid common user or role name (invalid public user name or role name).

Cause of error:

The user wants to create a newuser user in PDBORCL, but does not set the session container to PDB, while there is an error in creating a public user in CDB because the name or role cannot be verified.

1. Solution one

a. When you create a user, the user name starts with clocked # or clocked #.

Command: create user c##newuser identified by newuser; (the user name created at this time is: # # newuser in the table user$), which is not the newuser we need

Command: select * from user$ t where t.name like'% newuser%'

Take out the value of user#, which is assumed to be 108

c. Manually change the user name # # newuser to newuser

Command: update user$ set name='newuser' where user#=108

Commit

d. Force refresh

Alter system checkpoint

Alter system flush shared_pool

d. Reset password newuser

Alter user newuser identified by newuser

two。 Solution 2 (http://blog.itpub.net/29357786/viewspace-1995055/), excerpt) is as follows:

The relevant processing flow of ORA65096 is as follows:

1. View the database CDB name

Select name,cdb from v$database

2. View the database PDB name

Col pdb_name for a30

Select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs

Select con_id,dbid,NAME,OPEN_MODE from v$pdbs

3. Set the container library specified by the session PDB

Alter session set container=pdborcl

4. Create PDBORCL library users

Note that you need to make sure that there are users table spaces and temp temporary table spaces in the database first.

Create user ajao identified by ajao default tablespace users temporary tablespace temp

5. Authorization

Grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to AJAO

After reading the above, do you have any further understanding of what ora-65096 's solution is? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.