Configure 12c EM Express

If like me you somehow managed to install 12c and DBCA didn't give feedback on EM Express or you didn't save the details then fear not, you can retrieve the port and change it.

If its configured you can connect get the portnumber by running:

SQL > select dbms_xdb_config.gethttpsport() from dual;
Then connect : https://database-hostname:portnumber/em/

If the SQL returns no values then you need to set the port,

SQL > exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

Then connect : https://database-hostname:portnumber/em/

(you will need flash player as well to use it, guess that means no ipad app !)