About DBMS_XDB_CONFIG.SETGLOBALPORTENABLED

Setting the Global Port for EM Express to Manage a CDB and the PDBs (Oracle Database 12.2 Only)

In Oracle Database 12c Release 2, you can configure a single port (known as the global port), which enables you to use EM Express to connect to all of the PDBs in the CDB using the HTTPS port for the CDB.

In database deployments created after early December 2016, the global port is set by default.

To configure the global port in deployments created before December 2016:

1. Invoke SQL*Plus and log in to the root container (CDB) as the SYS user with SYSDBA privileges.

2. Execute the DBMS_XDB_CONFIG.SETGLOBALPORTENABLED procedure.

   SQL> exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/access-em-database-express-12c.html

------------------

Usage Notes

• Use the DBMS_XDB_CONFIG.SETGLOBALPORTENABLED procedure if you use EM Express to manage database ports in a multitenant environment. 

• To use a global port, you must enable it in both the CDB and the PDB. PDBs have it enabled by default. For CDBs, you must run the DBMS_XDB_CONFIG.SETGLOBALPORTENABLED procedure in the CDB root. 

• After you set DBMS_XDB_CONFIG.SETGLOBALPORTENABLED to TRUE, then you must specify a PDB to use for the global port. You can do so by specifying the PDB name in the Container Name field of the EM Express login page. For example, if you enter hr_pdb, then the EM Express URL becomes http://server_name:5500/hr_pdb/em. This example uses the port 5500 in the CDB root, which in turn routes messages to the EM Express in the PDB hr_pdb. The port can be an HTTP or HTTPS port.

• The PDB that you specify in the EM Express login page must be open in read/write mode before you can run DBMS_XDB_CONFIG.SETGLOBALPORTENABLED. You can check the read/write mode status of a PDB by connecting to the PDB and then querying the OPEN_MODE column of the V$PDBS dynamic view.

• The DBMS_XDB_CONFIG.ISGLOBALPORTENABLED function returns the value of the DBMS_XDB_CONFIG.SETGLOBALPORTENABLEDsetting.

• You can use the XDB_PROTOCOLS lockdown profile to control the security for the global port.

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_XDB_CONFIG.html#GUID-24CC7F8C-33C9-4444-A4FA-48BAD06353BA

PS: for boio.deora.io I have set it to TRUE. The database is usual (not container).