Configure Nagios to monitor Oracle database on a remote Linux Host Using CHECK_ORACLE_HEALTH

Monitoring Oracle Database with Nagios involves using plugins and configurations that allow Nagios to check the status and performance of the Oracle Database.

JBO-25077 OEM has a problem with collecting the information of a host

 When I opened the target host to view the related report, I got this page.

Set up DELTA (DB Endpoint Latency Testing Ammeter) to test the latency from a Windows system using venv to an oracle database

 What is the DELTA?

DELTA (DB Endpoint Latency Testing Ammeter) is a tool or framework designed to measure the latency of database endpoints. It is used to assess the performance of database connections, helping developers and database administrators understand the time it takes for a database query to travel from the client to the database server and back.

Automating Archive Log Cleanup in DBCS Standby Databases: A Step-by-Step Guide

In Oracle Cloud Infrastructure (OCI) Database Cloud Service (DBCS), the ability to use crontab or similar utilities to schedule jobs for the oracle user is restricted by default due to security and operational best practices. Here's why this restriction exists and alternative approaches you can use:

Encrypt an existing MS SQL Server 2019 database in Always on environment using TDE.

Transparent Data Encryption (TDE) 

Transparent Data Encryption (TDE) in SQL Server protects data at rest by encrypting database data and log files on disk. It works transparently with existing applications, so they don’t need to be changed when TDE is enabled. TDE uses real-time encryption at the page level. In SQL Server 2019, TDE is available as a Standard Edition feature, eliminating the need to upgrade to Enterprise Edition just for TDE.

Restore a database in the MS SQL Server Always On Availability Group

Prerequisites

1.     Backup File: Ensure you have a valid full backup of the database you want to restore. I used AdventureWorks2019.bak for my test.

Configure Nagios to monitor Remote Linux Host

To monitor a remote Linux host using Nagios, we'll need to install Nagios Plugins and NRPE (Nagios Remote Plugin Executor) on the remote host.