Our DB was 12cR1 and I upgraded it using DBUA to 12cR2. I didn't check anything when DBUA wizard asked for configuring EM, also EM was working fine before the upgrade.
After the upgrade I've been having trouble accessing it. So I try re configuring it as many manuals suggest:
1-Set my SSL port to 5502:
SQL> exec dbms_xdb_config.sethttpsport (5502);
2-Check SSL port if it's set:
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5502
3- Check if dispatcher is already there:
SQL> show parameter dispatchers;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=OR01XDB)
4- Check local listener param:
SQL> show parameter local_listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_OR01
For some reason I am not able to access the EM anymore. I have tried to access it locally and nothing seems to be running at that port. I also checked the results of LSNRTCTL status and the results are now what they need to be:
Running LSNRCTL status:
oracle [ /u01/app/oracle/product/12.2.0/dbhome/rdbms/admin ]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 09-APR-2019 09:01:44
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.27.64.158)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 05-APR-2019 17:53:34
Uptime 3 days 15 hr. 8 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/dbhome/network/admin/listener.ora
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.27.64.158)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "OR01" has 1 instance(s).
Instance "OR01", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
One of the entries should be the OR01XDB service right? What am I missing here? Also if EM is broken how can I rebuild it? I found an emremove.sql under ADMIN but not an embuild.sql or similar.