Removal and creation of common user issues with Oracle 12.1

Version 12.1, Cdb-rac mode

One cluster, 4 nodes, one CDB, with 12 pdb below.

Os:linux 64

---

Delete User

Drop User C # #test

Atler.log Tips

Ora-00600:internal error code, arguments: [Ktpjptsr-nocurtxn], [], [], [], [], [], [], [], [], [], [], []
Incident details in:/u01/app/oracle/diag/rdbms/wgdb/wgdb1/incident/incdir_735958/wgdb1_ora_27222_i735958.trc

Where's the problem? See this hint does not understand, there is no Oracle service number.

A blind guess! It should be because the PDB was closed (to reduce unnecessary network consumption and resource contention, a PDB on some instances was closed, for example, Pdb_test was closed on instance 1)

How to resolve:

Open Pdb_test on instance 1

Alter pluggable Pdb_test Open instances= (' cdb1 ')

Result: OK

Add user

Create User C # #xtjk identified by "123456"

Executes half a day, the Discovery statement card is on the Pdb_sa of instance 1.

Had to kill the process (otherwise it would prompt a transaction)

Conjecture: It should be because of the locks caused by the data dictionary, why these dictionaries are locked, probably because there is no configuration to tell the server user, so the system needs to go to each PDB to query the system fields, just

In Pdb_sa, there are some reasons for being stuck (guessing, because of a lack of conditions, so querying these fields is time consuming)

WORKAROUND: Provide the complete statement

Create User  by "123456"    defaulttemporarytemp  Default on Users container=all     

Result: Create now
In the CDB mode RAC, the cost of operating the system fields is particularly high!

Conclusion!

This cluster has some problems in general, so there will be some inexplicable problems!

Removal and creation of common user issues with Oracle 12.1