Oracle-maintained users password change
1 min readFrom 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.
