Oracle is a widely used relational database management system
(RDBMS). Developed by Oracle Corporation, Oracle RDBMS offers a robust
solution for storing, retrieving, and managing structured data. It
follows the relational model, where data is organized in tables composed
of rows and columns. Oracle provides advanced features such as data
integrity, ACID transactions, multi-platform support, and scalability.
Additionally, it offers a powerful query language called SQL (Structured
Query Language) for performing data manipulation and retrieval
operations. With its extensive adoption in the industry and its ability
to handle large volumes of data, Oracle is often used in
mission-critical applications and corporate environments that require
high availability, security, and performance.
How to Monitor Oracle on the One Platform
To set up monitoring for Oracle on the platform, follow these steps:
-
Go to the product application where you want to add Oracle as a dependency in the platform.
-
Click on the “Products” menu and select the desired product card.
-
Then, click on the name of the specific application where you want to configure Oracle monitoring.
-
Look for the section called “External Dependencies,” usually located just below the latency graph of the application.
-
To add an already registered dependency, type the name of the
dependency in the search field and select it when it appears in the
list. -
If Oracle is not yet registered as a dependency, click on the green button with a plus (+) symbol to add a new dependency.
Click “Add” and a modal will
appear allowing you to name the database and select the Environment. In
the “Check type” field, choose the option “DB,” and in the “Method”
field, select “Oracle.” After selecting the method, a field for the
Healthcheck URL will appear.
Below is an example of string for Oracle:
ex: USER/PASSWORD@HOST:PORT/DATABASE/ as SYSDBA
Note: For security reasons, it is not permitted to enter an IP in the
healthcheck field. To monitor an IP, you need to enter it in a secret
and use it in healthcheck