EM监控数据库活动
1.SYSTEM登录数据库
sqlplus / as sysdba
2.确认HTTP或者HTTPS侦听端口
select dbms_xdb_config.gethttpport from dual;
select dbms_xdb_config.gethttpsport from dual;
exec dbms_xdb_config.sethttpport(5501);
exec dbms_xdb_config.sethttpsport(5500);
3.连接Database Express,登录用户为SYSTEM
http://192.168.56.1:5501/em
https://192.168.56.1:5500/em
4.查看Database Express的相关信息
1.查看监听的状态
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER------------------------Listener Log File /u01/app/oracle/diag/tnslsnr/bonda2/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.21)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.23)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=bonda2)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0/db_1/admin/study/xdb_wallet))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bonda2)(PORT=5501))(Presentation=HTTP)(Session=RAW))2.查看调度进程
SQL> show parameter dispatch
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------dispatchers string (PROTOCOL=TCP) (SERVICE=studyX DB)