APEX url not working .. Issue with XDB listener

APEX url not working .. Issue with XDB services not getting registered with the listener.


SQL> select dbms_xdb.gethttpport() from dual;

DBMS_XDB.GETHTTPPORT()
----------------------
                  8020

SQL> show parameter shared_servers;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_shared_servers                   integer
shared_servers                       integer     1

SQL> alter system register;

System altered.

SQL> select * from dba_errors;

no rows selected

SQL> select count(*) from dba_objects where owner='XDB' and status='INVALID';

  COUNT(*)
----------
         0

SQL> select comp_name, status, version from DBA_REGISTRY  where comp_name='Oracle XML Database';

COMP_NAME
--------------------------------------------------------------------------------
STATUS                                       VERSION
-------------------------------------------- ------------------------------
Oracle XML Database
VALID                                        12.2.0.1.0


SQL> exec dbms_xdb.sethttpport(8020);

PL/SQL procedure successfully completed.

SQL> alter system register;

System altered.

SQL> show parameter dispatchers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=prodapexXDB)
max_dispatchers                      integer

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_PRODAPEX


SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=prodapex)(port=1521))';

System altered.

SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (ADDRESS=(PROTOCOL=TCP)(HOST=prodapex)(port=1521))

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

[oracle@prodapex product]$ lsnrctl stop prodapex

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.4.203)(PORT=1521)))
The command completed successfully

SQL> startup

Total System Global Area 1.0066E+10 bytes
Fixed Size                 12169992 bytes
Variable Size            2248150264 bytes
Database Buffers         7784628224 bytes
Redo Buffers               21381120 bytes
Database mounted.
Database opened.

[oracle@prodapex product]$ lsnrctl start prodapex


Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/prodapex/prodapex/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.203)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.4.203)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     prodapex
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                01-FEB-2018 21:40:32
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/prodapex/prodapex/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.203)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "prodapex" has 1 instance(s).
  Instance "prodapex", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


SQL> alter system register;

System altered.



[oracle@prodapex product]$ lsnrctl status prodapex


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.4.203)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     prodapex
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                01-FEB-2018 21:40:32
Uptime                    0 days 0 hr. 1 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/prodapex/prodapex/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.4.203)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=prodapex.example.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/prodapex/xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prodapex.example.com)(PORT=8020))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "prodapex" has 1 instance(s).
  Instance "prodapex", status UNKNOWN, has 1 handler(s) for this service...
Service "prodapex.example.com" has 1 instance(s).
  Instance "prodapex", status READY, has 1 handler(s) for this service...
Service "prodapexXDB.flex.com" has 1 instance(s).
  Instance "prodapex", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@prodapex product]$

After this steps URL started working fine.

Thanks,