Reset SYS and SYSTEM password for PDB about oci-oracle-xe

[gvenzl]

According to the Oracle Documentation, the CONTAINER=ALL is the default when executed from the CDB$ROOT container:

CONTAINER Clause
If the current container is a PDB, then you can specify CONTAINER = CURRENT to change the attributes of a local user, or the container-specific attributes (such as the default tablespace) of a common user, in the current container. If the current container is the root, then you can specify CONTAINER = ALL to change the attributes of a common user across the entire CDB. If you omit this clause and the current container is a PDB, then CONTAINER = CURRENT is the default. If you omit this clause and the current container is the root, then CONTAINER = ALL is the default.

Tests confirm this behavior:

bash-4.4$ sqlplus system/MyPassword@//localhost/XE

SQL*Plus: Release 18.0.0.0.0 - Production on Sun May 9 01:25:07 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Last Successful login time: Sun May 09 2021 01:24:20 +00:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

---> Change password to a new one when connected to the instance/SID = XE

SQL> alter user system identified by MyTestPassword123;

User altered.

SQL> exit
Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

---> Logon to instance with old password does no longer work, as expected

bash-4.4$ sqlplus system/MyPassword@//localhost/XE

SQL*Plus: Release 18.0.0.0.0 - Production on Sun May 9 01:25:31 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C

---> Logon to PDB with old password does not longer work either, as it got reset too

bash-4.4$ sqlplus system/MyPassword@//localhost/XEPDB1

SQL*Plus: Release 18.0.0.0.0 - Production on Sun May 9 01:25:39 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C

---> Logon to instance with new password works, as expected

bash-4.4$ sqlplus system/MyTestPassword123@//localhost/XE

SQL*Plus: Release 18.0.0.0.0 - Production on Sun May 9 01:25:52 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Last Successful login time: Sun May 09 2021 01:25:07 +00:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> exit
Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

---> Logon to PDB with new password works because it got implicitly reset

bash-4.4$ sqlplus system/MyTestPassword123@//localhost/XEPDB1

SQL*Plus: Release 18.0.0.0.0 - Production on Sun May 9 01:25:56 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Last Successful login time: Sun May 09 2021 01:25:52 +00:00

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL> exit
Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
bash-4.4$