dbconsole in Oracle

I was working with a customer the other day and they were asking for some help setting up dbconsole for their 12c database. It seems that it wasn’t working out of the box and they needed some help configuring it. So of course I said sure no problem! I have done dbconsole setups several times and it’s not a huge project.

So I started off by checking to see what was running and configured with my emctl commands, but to my surprise they were nowhere to be found. I was a bit confused, but apparently I had missed that in 12c Oracle did away with dbconsole and put in its place Oracle Enterprise Manager Database Express.

To configure OEM Database Express you simply need to run one of the below commands and specify a port.

For HTTPS: exec dbms_xdb_config.sethttpsport(5500);
For HTTP: exec dbms_xdb_config.sethttpport(8080);

To see what ports have been configured you can run one of the below commands.

For HTTPS: select dbms_xdb_config.getHttpsPort() from dual;
For HTTP: select dbms_xdb.getHttpPort() from dual;

To grant users view only access to see the web UI interface you can grant them the role EM_EXPRESS_BASIC.

grant EM_EXPRESS_BASIC to <user>;

This is obviously a quick and dirty on how to setup OEM Database Express, but I hope this saves someone a few minutes of looking around for emctl with Oracle 12c.

Share This