How do I monitor an Oracle database hosted in a Docker container in the same machine?
To monitor your Oracle Database hosted in a Docker container, follow these steps:
- Log in to Site24x7 and install the Site24x7 Linux monitoring agent.
- Execute the following command in your terminal and enter your Oracle Database instance's username and password as well as the Host Name, Port, and Service Name for the Site24x7 agent to authenticate and configure Oracle monitoring:
/opt/site24x7/monagent/scripts/AgentManager.sh oracledb --add_instance - Choose This server option, and provide the Host port that is mapped to the Oracle listener in the container, the User name, Password, and Service name to add the Oracle Database for monitoring.
The Host port is available in the Ports section of the docker ps output.
After successful installation and execution, the Site24x7 Oracle Database monitor will start collecting data.
- Log in to Site24x7 and click Database > Oracle on the navigation pane.
- You will be directed to the monitor page, where you can view the list of Oracle Database instances you have added.
The instance name will be in the below format:
host:port - servicename - ORACLE
Sample: 10.71.95.97:3400 - ORCLCDB - ORACLE