Oracle Database 12c: Enterprise Manager Database Express

Oracle Database 12c says goodbye to a tool being around after the 10gR1: the Database Console.

OC4J for the 10g and weblogic for the 11g, both have had a non-negligible overhead on the systems, especially with many configured instances.

In many cases I’ve decided to switch to Grid/Cloud Control for the main reason to avoid too many db consoles, in other cases I’ve just disabled at all web management.

The new 12c brings a new tool called Database Express (indeed, very similar to its predecessors).

The DB Express runs entirely with pl/sql code within the XDB schema. It’s XDB that leverages its features to enable a web-based console, and it’s embedded by default in the database.

To enable it, it’s necessary to check that the parameter dispatchers is enabled for XDB:

SQL> show parameter dispatchers

NAME        TYPE   VALUE
----------- ------ -----------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=CLASSICXDB)

and then set an https port unique on the server:

SQL> exec dbms_xdb_config.sethttpsport (5502);
 PL/SQL procedure successfully completed.
 SQL>

If you’ve already done it but you don’t remember the port number you can get it with this query:

SQL> select dbms_xdb_config.gethttpsport () from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5502

You can now access the web interface by using the address:

https://yourserver:5502/em

https://i1.wp.com/www.ludovicocaldara.net/dba/wp-content/uploads/2013/06/db_express_home.png

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s