Can not login into Oracle 18c XE EM EXPRESS

Jesús Moreno Díaz

Does anyone gets another login (XDB) after login into https://localhost:5500/em?

Using to login: user "sys" password "<my password>" container "XE" checked "as sysdba"

And can you connect from other host after configured?

(you must issue a) "exec dbms_xdb.setlistenerlocalaccess(false)" to set listener open to other hosts, b) exec dbms_xdb.sethttpport(8080)" to enable 8080 port

Markus Flechtner

Hi,

please do not use "XE" as the container name.

It's the name of the instance (ORACLE_SID) and the name of the container database, but not the name of the container

Leave "container name" empty => you will connect to the root container CDB$ROOT

Enter "CDB$ROOT" ==> root container CDB$ROOT

Enter "XEPDB1" ==> you will connect to the PDB "XEPDB1"

HTH

Markus

Nikola Smuk

I was able to connect to EM when i leave container name empty.

But when i enter xepdb1 ( uppercase or lowercase ) i get new windows popup that says:

"https://db_server_name:5500 is requesting your username and password. The site says: “XDB”

Username:

Password:

I enter sys and sys password but can't get in EM.

Markus Flechtner

Hi,

is the PDB XEPDB1 open?

Please try "show pdbs" when connected in SQL*Plus

Regards

Markus

Haniel Burton

Hi Markus,

I'm having the same issue.

XEPDB1 is in open READ/WRITE mode.

I can login to EM Express using SYS and blank container name, but if I specify a PDB then the web browser asks for what looks like basic HTTP auth credentials.

Any thoughts?

I'm thinking some configuration or access rights are missing at the PDB level.

Thanks,
Haniel Burton

Haniel Burton

After fiddling around some more I found a work around and was able to set a specific HTTPS port for XEPDB1 by following documentation for 12c multi-tenant architecture.

Resources (In order used):

• https://docs.oracle.com/database/121/ADMQS/GUID-06C767B0-B435-4C6B-9123-C39C030DF457.htm#ADMQS12485
• https://docs.oracle.com/database/121/ADMQS/GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5.htm#ADMQS032
• https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinl/making-oracle-database-em-express-available-remote-c…

You can configure EM Express on a separate port that is specific to the PDB you're trying to access by doing the following:

1. Connect to sqlplus as sysdba
   1. alter session set container=XEPDB1;
   2. select dbms_xdb_config.gethttpsport() from dual;
2. If port returned is zero, then you need to manually configure an HTTPS port for the PDB
   1. exec DBMS_XDB_CONFIG.SETHTTPSPORT(5502);
3. Allow access to EM Express from non-local address
   1. sqlplus system
   2. EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
   3. Run 2. again, but first alter your session to use xepdb1 container
4. You should now be able to access EM Express at the new port and only see information for XEPDB1 by logging in as SYS or another privileged user.

Note: This is what worked for me, I may not have had to enable listener access at the CDB level and only at the PDB level, but it works now so I'm going to work on getting ORDS and APEX installed next.

Hope this helps!

I know it still doesn't solve the issue with entering the PDB name into the container field.

Thanks,
Haniel Burton

f7a19a6e-08cb-4f72-b579-6691a9fea0d5

Jesus always saves. Sorry I did not resist the joke. But yes, its placement solved my installation on a CentOS 7. Even after I freed the 5500 and 8080 ports on the firewall, I continued to have trouble accessing EM. But now for me it's all solved in my virutal testing machine.

Tamás Bene

By default every PDB and also the root container has its own EM listener port in Oracle XE 18c. If you don't like to access EM for every PDB on different port, then you can enable EM Global Access. It means, you will be able to specify container on EM login screen (empty string for the root container and XEPDB1 for the first container created by oracle installer).

Enter the following command into SQL Developer or SQL Plus:

DBMS_XDB_CONFIG.SETGLOBALPORTENABLED(true);

Resource:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_XDB_CONFIG.html