Thursday, June 27, 2013

Enable Enterprise Express for Database 12c

Oracle Database 12c comes with new feature called Enterprise manager 12c express, this new enterprise manager control Database 12c using GUI , manager storage , performance , user, roles, accounts and others new features added , No command to start or shutdown EM 12c express by default when you start/shutdown database it will be up/down.


  • export ORACLE_SID
  • Make sure listener is up and database is registered.

sqlplus / as sysdba
SQL> show parameter dispatcher ;
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers     string (PROTOCOL=TCP) (SERVICE=db12cX
DB)
  • Configure HTTP PORT 
SQL> exec DBMS_XDB_CONFIG.setHTTPPort (8080);
Check the below pictures that describe EM Express :








DBMS_XDB.setHTTPPort is deprecated

Thank you
Osama mustafa

2 comments:

  1. Osama. Small remarkt (on this nice post)...

    DBMS_XDB.sethttpport() is deprecated. Use DBMS_XDB_CONFIG.sethttpport() instead.

    Gr

    Marco

    ReplyDelete