Are you using an Oracle 11g Database Server in your Application? You can monitor your Oracle Database instance for Availability and Performance using IDERA Uptime Cloud Monitor .
As an illustration, you can configure and receive alerts for the following scenarios:
The full set of metrics monitored from an Oracle 11g instance is listed here. You can configure and receive alerts on any of these metrics.
Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box solution for monitoring Oracle 11g Database instance for availability and performance. If you are not familiar with the concept of custom metrics as used in Uptime Cloud Monitor, please go through Custom Metrics information once before continuing with this document. More details on Custom Metrics can be found here.
NOTE: Monitoring an Oracle Database in Windows is not currently supported.
Figure 1: The Basic Architecture of the Oracle 11g Server Monitoring Setup
The Custom Metric Agent will be installed on your Linux Server running Oracle 11g. Once this setup is completed, the Custom Metrics Agent will regularly collect performance & availability metrics from the monitored Oracle 11g Database and upload those metrics to your IDERA Uptime Cloud Monitor Account. If any performance issues arise, an alert will be triggered and you will be notified about it immediately.
There are three steps that you need to do to start monitoring an Oracle 11g Database Server using IDERA Uptime Cloud Monitor:
Figure 2: Navigate to Custom Tab -> Getting Started inside IDERA Uptime Cloud Monitor
Login to your UCM account and navigate to Custom tab -> Getting Started. Click on the Oracle icon displayed above.
Figure 3: The installer script for the Custom Metrics Agent for Oracle 11g Monitoring
Check the prerequisite steps (step 2 and 3). If Oracle server is installed on a different server machine than the one where this agent is being installed, you need to :
Now, click on icon to copy the installer script to your clipboard. Paste the command into a terminal window on the Oracle Server to be monitored.
NOTE: This installer script can also be run on another server which is connected to the Oracle Server to be monitored.
As soon as the script is run on a terminal with root privileges, it starts downloading the required Custom Metrics Agent for Oracle monitoring. You will need to configure the following items in the agent installation process. Item specified in square brackets ( [ ] ) are the default.
Figure 4: Executing the Custom Metrics Agent installation script with user as copperegg, Group as copperegg and monitoring frequency as 60 seconds
Figure 5: Executing the Custom Metrics Agent installation script with values being set for the Custom Metrics Groups and Dashboard and the Oracle Server connection parameters
3. Set values for the Custom Metrics Group name, Customer Metrics Group Label and the Dashboard name to the values [oracledb], [OracleDB Metrics] and “Oracle DB Dash” respectively.
4. Set the unique identifier for this Oracle server as “local-oracledb”
5. Set the URL for the Oracle Server as localhost and mention the username and password to connect to the Oracle Server
6. Specify the port. The default of  is set.
Navigate to Dashboard and you will see a new Oracle Monitoring Dashboard titled “Oracle DB Dash” has been added automatically by the installer.
Some of the metrics you will see in this Dashboard are listed below:
Figure 6: Oracle DB Dashboard showing the Free Buffer Waits
Figure 7: Oracle DB Dashboard showing the Parse to Execute Ratio
The complete set of metrics being tracked for the Oracle Server is shown below. You can see the same by navigating to the Custom Tab > Custom Objects and selecting Details on the Custom Metrics Group Label [Oracle DB Metrics] that was given as installation input.
Figure 8: The complete set of metrics being tracked for the Oracle11g Server
Default Pre-Configured Alerts for the Oracle Database
As soon as your Oracle Database Monitoring Dashboard comes up, you will notice that some alert configurations have been automatically created by our Installation Script (under Alerts > Configure Alerts). These pre-configured alerts for Oracle Database include:
Current Concurrent Sessions
The number of concurrent sessions.
Alert will be triggered if sessions reach 1600.
If the alerting condition is met for these pre-configured alerts, some alert notifications may also be triggered.
Configuring your own Alerts for the Oracle Database
Figure 9: A new alert being added that will be triggered when more than 5 concurrent users are connected to your OracleDB
You can configure new alerts that will be triggered when performance issues arise with your Oracle 11g DB. You can also configure the notification mechanisms for a triggered alert.
Notification mechanisms include:
Webhooks are also exposed for clients to configure custom notification mechanisms. More about setting up website probe alerts can be found here.
Sign up for a 14 day FREE TRIAL of Uptime Cloud Monitor (no Credit Card required).
You can find more information about Uptime Cloud Monitor pricing options here.
We charge only $0.08 per month per metric!
Sign up today!