Oracle 12c: EM Express prompting for username and password

I installed 12c r2, and when I try to access Enterprise Manager Express (EM Express), it kept prompting for username/password. You can google your way to find the answer, but here is what fixed for me.

1) Container Name: It should always be CDB$Root and not your actual container name.2) Make sure to enable to Port, In my case its 5500, so you enable the port using the following command  as SYS exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)

Always check the alert log for errors, before you start googling. In my case, Alert log had the following error<app\Oracle12\>diag\rdbms\suppdb12\suppdb12\alert\log.xml
<msg time='2019-06-07T09:31:59.083-04:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='XXXXXXXXXX' host_addr='::1' module='ORACLE.EXE (S000)' pid='21256' con_uid='1' con_id='1' con_name='CDB$ROOT'> <txt>Global ports off in Root, do SetGlobalPortEnabled(TRUE) to enable. </txt></msg>

ORA-28003: Password verification for the specified password failed

We have a maintenance database, where we have bunch of schemas running.

Though its not preferred, for simplicity sake, we keep username and password same for all those schema's and I had to reset password for bunch of schema's.

When I tried to reset password for a schema, I get an message say "ORA-28003: Password verification for the specified password failed", basically asking me to set up a complex password.

Workaround for this is to remove complex password check. You do this by changing your PROFILE.





When you query Profile, you could see "VERIFY_PASSWORD" set for the profile, and that is forcing a complex password.



To remove "VERIFY_PASSWORD"  check, you need to run following

Alter profile DEFAULT Limit PASSWORD_VERIFY_FUNCTION NULL;

Once thats done, you will be able to reset back to easy password.