Check

To report only problem users, use something like this...

SET LINESIZE 132

COLUMN username FORMAT a30

COLUMN profile FORMAT a20

SELECT i.instance_name,

       u.username,

       u.created,

       u.profile,

       u.account_status,

       u.lock_date,

       u.expiry_date

  FROM dba_users u,

       v$instance i

 WHERE (u.account_status != 'OPEN'

        OR u.lock_date IS NOT NULL

        OR u.expiry_date < SYSDATE+30)

   AND username NOT IN ('ANONYMOUS','APEX_040200','APPQOSSYS','CTXSYS','DIP','EXFSYS','FLOWS_FILES','MDDATA','MDSYS',

                        'ORACLE_OCM','ORDDATA','ORDPLUGINS','ORDSYS','OUTLN','SI_INFORMTN_SCHEMA',

                        'SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SQLTXADMIN','WMSYS','XDB','XS$NULL')

 ORDER BY u.username;

Change Password

Oracle Enterprise Manager Credentials

If you change a password related to the account used by OEM as Database Instance Monitoring Credentials (usually DBSNMP), do this is OEM...

• Setup - Security - Monitoring Credentials - select "Database Instance" - Manage Monitoring Credentials - select your Target Credential - Set Credentials

If you change a password related to a Named or Preferred Credential you can do something similar...

• Setup - Security - Named Credentials...

• Setup - Security - Preferred Credentials...