oracle-12C-configure-db-express

From oracle 12C onward there is no Enterprice manager database controller and EMCTL utility. they have introdused new management console called DB-Express. This artical shows how to configure DB-Express in 12C.
Once you installed 12C you have to manually configure the DB-Experss as given below.


*************** Check if it is enabled via: ***************

[oracle@orcl12 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 26 11:21:23 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select dbms_xdb_config.gethttpport() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
----------------------
     0



*******************Enable, for example on port 8080, and check HTTP access:

SQL> exec dbms_xdb_config.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport() from dual;

DBMS_XDB.GETHTTPPORT()
----------------------
  8080

No comments:

Post a Comment