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.

It is possible that Oracle Database or Clusterware may not be healthy or various system components may be running out of space in the Guest VM. You are not notified of this situation, unless you opt-in.
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 time

Database 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 as root 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 as root:
    # 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 as root:
    # 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 as root 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 as root 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 as root 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 the root user:
    systemctl start dbcsagent.service