Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Can not login into Oracle 18c XE EM EXPRESS

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
Answers
-
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
-
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.
-
Hi,
is the PDB XEPDB1 open?
Please try "show pdbs" when connected in SQL*Plus
Regards
Markus
-
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 -
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:
- Connect to sqlplus as sysdba
- alter session set container=XEPDB1;
- select dbms_xdb_config.gethttpsport() from dual;
- If port returned is zero, then you need to manually configure an HTTPS port for the PDB
- exec DBMS_XDB_CONFIG.SETHTTPSPORT(5502);
- Allow access to EM Express from non-local address
- sqlplus system
- EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
- Run 2. again, but first alter your session to use xepdb1 container
- 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 -
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.
-
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