How to Configure Database Express

Introduction

Database Console no longer exists from 12c onwards. Instead, a new tool called Database Express is available. It is similar to Database Console, but comes with less functionality and instead of being a separate install, it runs entirely within the database. This makes it very easy to install and configure. Unlike dbcosnole where you would have the following tasks to perform <insert link http://oracledatabase.wikidot.com/premium:startdocshowtoinstalldeinstalldbconsole), the installation and configuration is a single command.

Step-By-Step – Check to See if Database Express is Installed.

. oraenv <enter SID>

SQL> SELECT DBMS_XDB_CONFIG.gethttpport FROM dual;

GETHTTPPORT

-----------

          0

Note - 0 Means Database Express is not configured.

Step-By-Step – How to Configure Database Express.

. oraenv <enter SID>

SQL> EXEC DBMS_XDB_CONFIG.sethttpsport(5500);

SQL> SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual;

GETHTTPSPORT

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

        5500