Overview of Database Service Events
The Database Service Events feature implementation enables you to be notified about health issues with your Oracle Databases, or with other components on the Guest VM.
Note:
You are opting in with the understanding that the list of events can change in the future. You can opt-out of this feature at any timeDatabase Service Events feature implementation generates events for Guest VM operations and conditions, as well as Notifications for customers by leveraging the existing OCI Events service and Notification mechanisms in their tenancy. Customers can then create topics and subscribe to these topics through email, functions, or streams.
Note:
Events flow on Oracle Exadata Database Service on Exascale Infrastructure depends on the following components: Oracle Trace File Analyzer (TFA), sysLens, and Oracle Database Cloud Service (DBCS) agent. Ensure that these components are up and running.
Manage Oracle Trace File Analyzer
- To check the run status of Oracle Trace File Analyzer, run the
tfactl status
command asroot
or a non-root user:# tfactl status .-------------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status| +----------------+---------------+--------+------+------------+----------------------+------------+ | node1 | RUNNING | 41312 | 5000 | 22.1.0.0.0 | 22100020220310214615 | COMPLETE | | node2 | RUNNING | 272300 | 5000 | 22.1.0.0.0 | 22100020220310214615 | COMPLETE | '----------------+---------------+--------+------+------------+----------------------+------------'
- To start the Oracle Trace File Analyzer daemon on the local node, run the
tfactl start
command asroot
:# tfactl start Starting TFA.. Waiting up to 100 seconds for TFA to be started.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Successfully started TFA Process.. . . . . . TFA Started and listening for commands
- To stop the Oracle Trace File Analyzer daemon on the local node, run the
tfactl stop
command asroot
:# tfactl stop Stopping TFA from the Command Line Nothing to do ! Please wait while TFA stops Please wait while TFA stops TFA-00002 Oracle Trace File Analyzer (TFA) is not running TFA Stopped Successfully Successfully stopped TFA..
Manage sysLens
- If sysLens is running, then once every 15 minutes data is collected
in the local domU to discover the events to be reported. To check if sysLens is
running, run the
systemctl status syslens
command asroot
in the domU:# systemctl status syslens \u25cf syslens.service Loaded: loaded (/etc/systemd/system/syslens.service; disabled; vendor preset: disabled) Active: active (running) since Wed 2022-03-16 18:08:59 UTC; 34s ago Main PID: 358039 (python3) Memory: 31.6M CGroup: /system.slice/syslens.service \u2514\u2500358039 /usr/bin/python3 /var/opt/oracle/syslens/bin/syslens_main.py --archive /var/opt/oracle/log/... Mar 16 18:08:59 node1 systemd[1]: Started syslens.service. Mar 16 18:09:09 node1 su[360495]: (to oracle) root on none Mar 16 18:09:09 node1 su[360539]: (to grid) root on none Mar 16 18:09:10 node1 su[360611]: (to grid) root on none Mar 16 18:09:11 node1 su[360653]: (to oracle) root on none
- If the sysLens is enabled, when there is a reboot of the domU, then
sysLens starts automatically. To validate if sysLens is enabled to collect
telemetry, run the
systemctl is-enabled syslens
command asroot
in the domU:# systemctl is-enabled syslens enabled
- To validate if sysLens is configured to notify events, run the
/usr/bin/syslens --config /var/opt/oracle/syslens/data/exacc.syslens.config --get-key enable_telemetry
command asroot
in the domU:# /usr/bin/syslens --config /var/opt/oracle/syslens/data/exacc.syslens.config --get-key enable_telemetry syslens Collection 2.3.3 on
Manage Database Service Agent
View the /opt/oracle/dcs/log/dcs-agent.log
file to identify
issues with the agent.
- To check the status of the Database Service Agent, run the
systemctl status
command:# systemctl status dbcsagent.service dbcsagent.service Loaded: loaded (/usr/lib/systemd/system/dbcsagent.service; enabled; vendor preset: disabled) Active: active (running) since Fri 2022-04-01 13:40:19 UTC; 6min ago Process: 9603 ExecStopPost=/bin/bash -c kill `ps -fu opc |grep "java.*dbcs-agent.*jar" |awk '{print $2}' ` (code=exited, status=0/SUCCESS) Main PID: 10055 (sudo) CGroup: /system.slice/dbcsagent.service ‣ 10055 sudo -u opc /bin/bash -c umask 077; /bin/java -Doracle.security.jps.config=/opt/oracle/...
- To start the agent if it is not running, run the
systemctl start
command as theroot
user:systemctl start dbcsagent.service