12c EM express - first view



I thought I'd take a look at the new EM express tool provided by deafult with 12c - no more messing about with the software and having to install em repositories etc - there is now something set up out of the box (well nearly out of the box in my case) with no additional software components running.

Oracle have built on top of the XDB/Apex infrastructure to create a cut down EM that will be useful for most common tasks.


I tried to use the installation after following a completely manual setup of the database and it didnt work - i had to do a couple of extra steps to activate it - these were

alter system set dispatchers="(PROTOCOL=TCP)(SERVICE=DEMOXDB)"; -- where DEMO is your SID
exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);


This is probably just because of a bug in the manual setup process (and me missing the first init parameter).

So after these are set (and the database is restarted).

You should see a couple of extra lines in the listener output

 lsnrctl stat

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 21-JAN-2014 21:22:18

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1531)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date                15-DEC-2013 20:05:56
Uptime                    37 days 1 hr. 16 min. 21 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/12.1.0/grid/network/admin/listener.ora
Listener Log File         /oracle/diag/tnslsnr/server/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1531)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1531)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=server)(PORT=5500))(Security=(my_wallet_directory=/oracle/admin/DEMO/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "DEMO" has 1 instance(s).
  Instance "DEMO", status READY, has 1 handler(s) for this service...
Service "DEMOXDB" has 1 instance(s).
  Instance "DEMO", status READY, has 1 handler(s) for this service...
The command completed successfully


The key line being the
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=server)(PORT=5500))(Security=(my_wallet_directory=/oracle/admin/DEMO/xdb_wallet))(Presentation=HTTP)(Session=RAW))

so something is now listening on port 5500 and somehow a wallet got auto setup to allow https

we can now access the app at

https://server:5500/em

which looks like this (ignore the certficate warnings)





You can then login with your normal credentials,
SYSDBA will only work if a passwordfile has been set up.

You then get the home page - giving access to the 'stuff'



It's not the all singing all dancing thing it was before but it's good enough i think. We have a full cloud control installation anyway so are unlikely to use this facility anyway.

I'm not sure if the old style em installation is still available any more.



Comments

  1. Would you happen to know of a emctl-equivalent in 12g that can be used to debug the EM Express service if all this is set up properly, and it's still not working? I have the port set up, the listener is ready, but the URL returns nothing...

    ReplyDelete
  2. Hi,
    I'm not sure there really is a direct equivalent....

    In your case are you seeig port 5500 listed in the listener output. Are you accessing it using https?

    Have you tried running it locally to the database server to rule out any network/firewall issues?

    Cheers,
    Rich

    ReplyDelete
  3. yes, the listener status looks fine, I'm also using https, and am trying locally.
    I've also recently figured out that using the IP address (instead of hostname) in the URL -does- work, but very very very slowly. I've added more information on stackexchange. If you have more ideas, maybe you could add them there?: http://dba.stackexchange.com/questions/104288/unable-to-display-page-with-oracle-12c-enterprise-manager-database-express/116483#116483

    ReplyDelete
    Replies
    1. Hi,
      just sounds like a name resolution issue to me - do you have the short name and the fqdn in the hosts file?

      What order is specified in nsswitch.conf (assuming this is linux)

      Cheers,
      Rich

      Delete

Post a Comment