Oracle Management Cloud (OMC) Part 2 – Monitoring Database

OMC monitoring a Premises Database

In my previous blog, we looked at monitoring a premises linux server (Agent Install). In this blog we will add the monitoring of the database to the agent. For this we need 2 files :

 

File 1 (A Credential file for the Oracle database, you will need to update the password to what you have set in your environment): omc_oracle_db_creds.json

{

    "credentials" : [

        {

            "id" : "SQLCreds",

            "name" : "SQLCreds",

            "credType" : "DBCreds",

            "properties" : [

                {

                    "name" : "DBUserName",

                    "value" : "CLEAR[dbsnm]p"

                },

                {

                    "name" : "DBPassword",

                    "value" : "CLEAR[w1ll0w]"

                },

                {

                    "name" : "DBRole",

                    "value" : "CLEAR[Normal]"

                }

            ]

        }

    ]

}

 

File 2 (The Agent Configuration file, you will need to update the fields highlighted in yellow to your environment) : oracle_agent_add.json

{

      "entities": [{

            "name": "C_stest1",

            "type": "omc_oracle_db",

            "displayName": "stest1",

            "timezoneRegion": "BST",

            "credentialRefs": ["SQLCreds"],

            "properties": {

                  "host_name": {

                        "displayName": "host_name",

                        "value": "e33392"

                  },

                 "port": {

                        "displayName": "port",

                        "value": "1521"

                  },

                  "sid": {

                        "displayName": "sid",

                       "value": "stest1"

                  },

                  "capability": {

                        "displayName": "capability",

                        "value": "monitoring"

                  }

            }

      }]

}

Lets get started to monitor the database. Lets check the status of the upload That's all, Now if we log onto the OMC and drill into the Infastructure Monitoring – we can see the server and see our database being monitored.
We can drill into the database to see Top SQL and Top Wait Events Also the TableSpace Usage!