数据库监控--12c Enterprise Manager配置

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.xml
Listening 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)