Configuring EM Express on 19c Rac Database

 

SQL> select dbms_xdb_config.getHttpPort() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
—————————–
0

SQL> select dbms_xdb_config.getHttpsPort() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
——————————
0

SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

PL/SQL procedure successfully completed.

SQL> select dbms_xdb_config.getHttpsPort() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
——————————
5500

 

SQL> SELECT ‘https://’||SYS_CONTEXT(‘USERENV’,’SERVER_HOST’)||’.’||SYS_CONTEXT(‘USERENV’,’DB_DOMAIN’)||’:’||dbms_xdb_config.gethttpsport()||’/em/’ from dual;

‘HTTPS://’||SYS_CONTEXT(‘USERENV’,’SERVER_HOST’)||’.’||SYS_CONTEXT(‘USERENV’,’DB
——————————————————————————–
https://<hostname>:5500/em/

If the URL still does not work perform the below steps

 

[oracle@dbtest ~]$ lsnrctl stat | grep HTTP

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dbtest.oracle.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/19.0.0/dbhome_1/admin/testcdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbtest.oracle.com)(PORT=5550))(Presentation=HTTP)(Session=RAW))

[oracle@dbtest ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/admin/testdb/xdb_wallet

[oracle@dbtest xdb_wallet]$ ls -l
total 8
-rw——- 1 oracle asmadmin 3880 Dec 16 14:53 cwallet.sso
-rw——- 1 oracle asmadmin 3835 Dec 16 14:53 ewallet.p12
[oracle@dbtest xdb_wallet]$ chmod 640 ewallet.p12
[oracle@dbtest xdb_wallet]$ ls -l
total 8
-rw——- 1 oracle asmadmin 3880 Dec 16 14:53 cwallet.sso
-rw-r—– 1 oracle asmadmin 3835 Dec 16 14:53 ewallet.p12
[oracle@dbtest xdb_wallet]$ chmod 640 cwallet.sso

 

exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501);
exec DBMS_XDB_CONFIG.SETHTTPSPORT(5502);