A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Oracle-maintained users password change

1 min read
man in gray sweater holding black smartphone

Photo by Mikhail Nilov on Pexels.com

From oracle 12c onwards the default user’s account passwords have to change from cdb container. container class is optional. 

sys user password change
=======================

CDB level using container class with current option:
----------------------------------------------------------
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL>
SQL>
SQL> alter user sys identified by admin container=current;
alter user sys identified by admin container=current
*
ERROR at line 1:
ORA-65066: The specified changes must apply to all containers



PDB level using container class with current option:
----------------------------------------------------------

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





CDB level using container & without container class:
----------------------------------------------------------
SQL> show con_name

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

SQL> alter user sys identified by admin;

User altered.

SQL> alter user sys identified by admin container=all;

User altered.