How To Change Enterprise Manager Database Express Port in 12c

dbtut

5 years ago

You can also change the port of Enterprise Manager Database Express 12c after installation.

You can find the current port as follows.

[oracle@oradb trace]$ lsnrctl status | grep HTTP
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oradb)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/dbhome_1/admin/UDW/xdb_wallet))(Presentation=HTTP)(Session=RAW))

1 2	[oracle@oradb trace]$ lsnrctl status \| grep HTTP (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oradb)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/dbhome_1/admin/UDW/xdb_wallet))(Presentation=HTTP)(Session=RAW))

You can also find it via SQL Plus with the following query.

SQL> select dbms_xdb.getHttpPort() from dual;

DBMS_XDB.GETHTTPPORT()
----------------------
		     0

SQL> select dbms_xdb_config.getHttpsPort() from dual;

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

			  5500

SQL> select dbms_xdb.getHttpPort() from dual;

DBMS_XDB.GETHTTPPORT()

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

SQL> select dbms_xdb_config.getHttpsPort() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()

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

5500

You can change the current port for http and https as follows.

https:

SQL> exec dbms_xdb_config.sethttpsport(5500);

http:

SQL> exec dbms_xdb_config.sethttpport(8080);

https:

SQL> exec dbms_xdb_config.sethttpsport(5500);

http:

SQL> exec dbms_xdb_config.sethttpport(8080);