Easy setup guide EM Express formally known as DB Console


EM

Configure Dispatcher

SQL> alter system set dispatchers='(PROTOCOL=TCP) (SERVICE=NOMT1XDB)' SCOPE=both;

Configure XDB Listener
For HTTP

SQL> exec dbms_xdb_config.sethttpport(8080);

FOR HTTPS

SQL> exec dbms_xdb_config.sethttpsport(5500);

Set the XDB to allow local and remote connections

SQL> exec DBMS_XDB_CONFIG.SETLISTENERLOCALACCESS(false);

Make sure the listener is allowing to connect on the HTTP(s)

oracle@nomtdb01 NOMT1 ]$ lsnrctl status NOMT1
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 08-JUL-2015 21:14:12
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nomtdb01.nomt.local)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias NOMT1
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 08-JUL-2015 16:03:23
Uptime 0 days 5 hr. 10 min. 49 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /san/network/admin/listener.ora
Listener Log File /san/network/log/NOMT1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nomtdb01.nomt.local)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nomtdb01.nomt.local)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nomtdb01.nomt.local)(PORT=5500))(Presentation=HTTPS)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "NOMT1" has 2 instance(s).
Instance "NOMT1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@nomtdb01 NOMT1 ]$