invoke SQL*plus
If you have installed Oracle 12c (12.2.0.1) along with the Enterprise manager. The installation is fine, but if you didn't setup passwords for SYSMAN user etc.,, ???
but when go to the website (https://(server):5500/em) it's always coming up with a windows prompt for a user name and password with the text on the pop-up box of
"The server localhost is asking for your user name and password. The server reports that it is from XDB".
You cannot find any combination of user name/password that satisfies the login request. and the prompt continues for 3 times and then gives me the message "Logon denied; insufficient privileges or invalid username/password".
Don't look for every where.
Step 1: (e.g., for system user)
SQL> alter user system identified by mysystemempwd;
User altered.
Reference doc: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-em-database-express-12c.html
Step 2:
SQL> select dbms_xdb_config.getHttpsPort() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500
STEP 3: To configure a HTTPS port so that you can manage a PDB with EM Express:
SQL> exec dbms_xdb_config.sethttpsport(5500)
PL/SQL procedure successfully completed.
STEP 4:To configure the global port
SQL> exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)
PL/SQL procedure successfully completed.
STEP 5:
Accessing EM Express Using the EM Express Port
https://(server):5500/em)
Login as system user with above passwrod
system user already has Sysdba role privilege, so optional check box for as Sysdba"
Done