DB version: 12.1.0.2
OS : Oracle Linux 6.6
I created a PDB from Seed. But, I get the following error when I try to change the password of SYS user in PDB. Any idea why ?
SQL> create pluggable database PDB3
admin user pdb_admin identified by oracle123
roles = (DBA)
CREATE_FILE_DEST='/oradata/CDB1/PDB3' ;
Pluggable database created.
SQL> alter pluggable database PDB3 open;
Pluggable database altered.
$ sqlplus pdb_admin/oracle123@10.16.135.185:1521/PDB3
SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 28 11:48:44 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show con_name
CON_NAME
------------------------------
PDB3
-- CREATED column is reflecting Seed PDB's creation date
SQL> select username, account_Status, created from dba_users where username like 'SYS%';
USERNAME ACCOUNT_STATUS CREATED
------------ -------------------------------- ---------
SYS OPEN 07-JUL-14
SYSTEM OPEN 07-JUL-14
SYSBACKUP EXPIRED & LOCKED 07-JUL-14
SYSKM EXPIRED & LOCKED 07-JUL-14
SYSDG EXPIRED & LOCKED 07-JUL-14
SQL> alter user sys identified by pdbsys123;
alter user sys identified by pdbsys123
*
ERROR at line 1:
ORA-65066: The specified changes must apply to all containers
Apparently, I can do something like below . But, I don't want to set a common password for SYS and SYSTEM users across all PDBs
alter user SYSTEM identified by oracle container=all;