Getting Started with Oracle Enterprise Manager Express (Configuring the HTTPS Port for CDB and PDB)

quoted from:

https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r2/2day_dba/12cr2db_ch3emexp/12cr2db_ch3emexp.html#section1

 

 

---

Starting EM Express for non-CDB

 

1. Check if the database is a non container database.

   SQL> select name, cdb, con_id from v$database;
   
   NAME	  CDB	  CON_ID
   --------- --- ----------
   ORCL	  NO	       0

2. Check instance name.

   SQL> select instance_name, status, con_id from v$instance;
   
   INSTANCE_NAME	 STATUS 	  CON_ID
   ---------------- ------------ ----------
   orcl		 OPEN		       0

3. Issue the SQL statement that returns the port that is configured for EM Express.

   SQL> select dbms_xdb_config.gethttpsport() from dual;
   
   DBMS_XDB_CONFIG.GETHTTPSPORT()
   ------------------------------
   			  5500

4. If a port number is not returned by this statement, then you must manually configure an HTTPS port for this CDB, as described in "Configuring the HTTPs Port".

Starting EM Express for CDB

 

1. Check if the database is a multitenant container database.

   SQL> select name, cdb, con_id from v$database;
   
   NAME	  CDB	  CON_ID
   --------- --- ----------
   ORCL	  YES	       0

2. Check the instance name.

   SQL> select instance_name, status, con_id from v$instance;
   
   INSTANCE_NAME	 STATUS 	  CON_ID
   ---------------- ------------ ----------
   orcl		 OPEN		       0

3. Issue the SQL statement that returns the port that is configured for EM Express.

   SQL> select dbms_xdb_config.gethttpsport() from dual;
   
   DBMS_XDB_CONFIG.GETHTTPSPORT()
   ------------------------------
   			  5500

4. Note: When connected to the root, EM Express displays data and enables actions that apply to the entire CDB.

5. If a port number is not returned by this statement, then you must manually configure an HTTPS port for this CDB, as described in "Configuring the HTTPs Port".

Starting EM Express for PDB

 

Use the EM Express URL provided by DBCA when DBCA configured your PDB to start the EM Express. That URL includes the HTTPS port number for the PDB. If you do not know the HTTPS port number for the PDB, then follow the steps below:

SQL> select con_id, name, open_mode from v$pdbs;

    CON_ID
----------
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
         2
PDB$SEED
READ ONLY

         3
ORCLPDB
READ WRITE

    CON_ID
----------
NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------

SQL> ALTER SESSION SET CONTAINER=orclpdb;

Session altered.

SQL> alter pluggable database orclpdb open;

Pluggable database altered.

SQL> SELECT dbms_xdb_config.gethttpsport() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
			     0

Note: When connected to a PDB, EM Express displays data and enables actions that apply to the PDB only.

1. Display the PDBs.
2. Alter the session and set container as pdb (orclpdb in this case).
3. Open the pluggable database (if not already open) and issue the SQL statement that returns the port that is configured for EM Express. 
4. If a port number is not returned by this statement, then you must manually configure an HTTPS port for this PDB, as described in "Configuring the HTTPS Port".

Configuring the HTTPS Port

 

Accessing the Database Home Page