Aug 30, 2017

Accessing Enterprise Manager Database Express 12c

Connect to your database:-

$ sqlplus / as sysdba

SQL> select dbms_xdb_config.gethttpsport() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
0

SQL> exec dbms_xdb_config.sethttpsport(5501);
PL/SQL procedure successfully completed.

SQL> execute dbms_xdb_config.setglobalportenabled(TRUE);


N
ow open your favorite browser, and access Enterprise Manager Database Express 12c;

https://hostname:port_name/em

in my example;
hostname=
dummyserver

so I connect to DB Express, as;

https://
dummyserver:5501/em

In order to configure OEM DB Express for Pluggable Database, switch to pluggable database:-

$ sqlplus / as sysdba

SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT

SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
0

SQL> exec dbms_xdb_config.sethttpsport(5502);
PL/SQL procedure successfully completed.

SQL> execute dbms_xdb_config.setglobalportenabled(TRUE);


Now open your favorite browser, and access Enterprise Manager Database Express 12c;

https://hostname:port_name/em

in my example;
hostname=
dummyserver

so I connect to DB Express, as;

https://
dummyserver:5502/em

No comments:

Post a Comment