How to monitor Oracle database?

How do I monitor my Oracle databases? Q: I can’t figure out how to create monitor for Oracle database(s). Can you help? A: Add and configure the Oracle DB monitor like in the example below: Use your database name and user credentials, specify an SQL request that returns an integer value. Let’s check several typical […]

How to specify database name for Oracle DB monitor?

How should I specify database name for Oracle DB monitor? Q: What shall I enter into “Oracle Database Name” field when creating Oracle DB monitor? Alias from tnsnames.ora, server name (IP address) or service name (TRAD11P_PROD)? A: “Oracle Database Name” is database instance name. Oracle database monitor type doesn’t make use of TNS. Note: it […]