My Oracle Support Banner

Alter User Ended Up with Errors ORA-65048, ORA-65066 in Oracle Database Cloud (Doc ID 2398169.1)

Last updated on MAY 14, 2018

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

Customer was trying to change the password for a user which is in the grace period. But ended up with errors ORA-65048, ORA-65066.
This is a 12R1 instance where they have one PDB - PDB1.

SQLPLUS output:

SQL> alter user testuser identified by testuser;
alter user testuser identified by testuser
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database PDB1
ORA-01918: user 'testuser' does not exist

SQL> alter user testuser identified by testuser container=current;
alter user testuser identified by testuser container=current
*
ERROR at line 1:
ORA-65066: The specified changes must apply to all containers

SQL> alter user testuser identified by testuser container =CURRENT;
alter user testuser identified by testuser container =CURRENT
*
ERROR at line 1:
ORA-65066: The specified changes must apply to all containers

SQL> alter user testuser identified by testuser container=ALL;
alter user testuser identified by testuser container=ALL
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database PDB1
ORA-01918: user 'testuser' does not exist

 

SQL> show parameter OS_AUTHENT_PREFIX;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix                     string       ops$

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> select username, account_status from dba_users where username like 'TESTUSER';

USERNAME        ACCOUNT_STATUS
----------------- --------------------------------
TESTUSER        EXPIRED(GRACE)

SQL> alter session set container=PDB1;

Session altered.

SQL> select username, account_status from dba_users where username like 'TESTUSER';

no rows selected

SQL> show parameters common_user_prefix

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
common_user_prefix                 string       C##

 We have asked the customer to execute the DBMS_PDB.SYNC_PDB to sync, but again the issue persists-

SQL> execute SYS.DBMS_PDB.SYNC_PDB;

PL/SQL procedure successfully completed.

SQL> alter session set container=PDB1;

Session altered.

SQL> select username, account_status from dba_users where username = 'TESTUSER';

no rows selected

Changes

 Though customer was unable to provide the vital information like CDB, PDB creation, it seems like the PDB was plugged in from another CDB.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.