Show Menu
Cheatography

Oracle 12.2 Em Express Cheat Sheet (DRAFT) by

This is a draft cheat sheet. It is a work in progress and is not finished yet.

EM before 12c

$ORACLE_HOME/bin/emctl
$ORACLE_HOME/bin/emca

cd $ORACLE_HOME/bin
./emca -config dbcontrol db -repos create|drop|recreate
./emctl stop|start|status dbconsole

12.1

--emctl and agent service are gone

--Set em port:
exec dbms_xdb_config.sethttpsport(5500);
exec dbms_xdb_config.sethttpport(8080);

--get em prot
select dbms_xdb_config.getHttpsPort() from dual;
select dbms_xdb_config.getHttpPort() from dual;

--privilege to access em
EM_EXPRESS_BASIC  --read
EM_EXPRESS_all -- all action available to em
--Both are assigned to DBA role.

12.2

from 12.2,
--all CDB and pdb using one global EM port by default.

exec dbms_xdb_config.SetGlobalPortEnabled(TRUE);