OMC: Discovering Entities for Oracle Infrastructure Monitoring — Part II
Authors: Monowar Mukul (OCM), Nassyam Basha (Oracle ACE Director, OCM)
Introduction
This article is a follow-up for the article “Discovering Entities for Oracle Infrastructure Monitoring — Part I”, Here we will focus how to create the user to monitor the Oracle database from OMC and in detail, we will now review how to enable licensing and finally we will perform crosscheck operations of the target components.
We are going to cover below subtopics
- Prerequisites for Oracle Database
- Add Database Entity
- Enabling License for Entity
- Validation of the Entity
- Crosscheck of Oracle CRS/DB configuration
Prerequisites: Add Oracle RAC Database Entity
In this phase, we will perform prerequisites of RAC Database entity of Oracle Management Cloud. In Enterprise Manager, we do use monitoring credentials DBSNP likewise to add and monitor the entity we may create exclusively another monitoring user in the database.
Create Monitoring Credentials for Oracle Database
We are going to create the user “OCMMON” — this user job is to only monitor Oracle Database. Initially login to the database host with oracle user or owner of the Oracle RDBMS and then execute the script to set up the MONCS user. This script will create a user and as well as grants the required roles and privileges for Infrastructure Monitoring
Access to the location cd /u01/app/OMC/omcagent/plugins/oracle.em.sgfm.zip/1.35.0/scripts and then run ./grantPrivilegesMonSvc.sh shell script as below. In case of RAC database this script we can run any one of the nodes.
- Database Home
- Database SID
- SYSDBA user
- SYSDBA Password
- Monitoring User
- Monitoring User password
- Output/log file location
In the process of user creation, It automatically detects CDB/PDB and will add c## prefix if required.
Above we have created credentials for Oracle Database monitoring and now we will grant few permissions needed for both monitoring and for the data collection/Analytics.
Note: If the DBSNMP user is already available, then these roles are not required. DBSNMP user has all the roles and privileges for the database monitoring and for Oracle IT analytics data.
To grant the roles/privileges login to the database host as the OS software owner (eg. Oracle) and execute the script to set up the MONCS user.
Add Oracle RAC Database Entity
We have performed all he prerequisites for the Oracle Database Entity and now we will add the entity to the OMC. Navigate to “OMC Console URL à Administrationà Discovery à Add Entity”
In the “Add Entity” form and complete the below fields to process the entity to be added to OMC.
- Entity Type
- Entity name
- Host Name
- Port Number
- Service Name
- Cloud Agent
- Job Name
- Database Credentials
- License edition
After submitting the request to add the database to the OMC for the monitoring, we can see the status of the database with various options such as configuration, performance monitoring, and troubleshooting.
Enabling Licenses for the Entity
After adding the entity, now we will enable monitoring, or we will enable OMC licensing for the entities we have added. Until unless we acknowledge the licensing for the entity the targets will not collect the data, or we cannot monitor the targets. Navigate to the entity’s configuration as “From Hamburger menu, go to Administration → Drill into Entities Configuration → select Licensing → Select Entities”
A basic review of the Database Properties
From the Database entity, we can see various tabs associated with the database. Each page will give rich of information such as “Configuration” — it will fetch all the database related information and in a single page with one shot.
In the performance table tab, we can view most of the DBA Daily activities including with various other performance metrics such as top wait events, latency and etc.
Validate the Entities
Now we have enabled licensing for all entities by selecting Licence Edition to “Set All to Enterprise” and click on Save button. As soon as after this step we shall be able to monitor, troubleshoot, review of configuration is easily accessible. We will walk through to monitoring page to view the entities status. “Hamburger menu à Monitoring” Confirm Entity has now been enabled in monitoring page.
After collecting the data through an agent and now it should push the alerts from all the entities which we enabled licensing
To review all the entities status we can view from the “Entities” option — it will show the statuses of all the targets.
Verify the Clusterware Configuration
In this section we will verify the configuration of Oracle Clusterware and also overall the agent status after adding entity for the Oracle RAC Database.
[oracle@racdb1 ~]$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall[oracle@racdb1 ~]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml |grep -i CRS=\”true\”
<HOME NAME=”OraGrid18000" LOC=”/u01/app/18.0.0.0/grid” TYPE=”O” IDX=”1" CRS=”true”/>[oracle@racdb1 ~]$ cat /etc/init.d/init.ohasd |grep “^ORA_CRS_HOME”
ORA_CRS_HOME=/u01/app/18.0.0.0/grid[oracle@racdb1 ~]$ /u01/app/18.0.0.0/grid/bin/olsnodes -cRacdb
Summary
In short, we have performed all the prerequisites for the Oracle RAC Databases entity by creating user and granting necessary roles/privileges for the IT Analytics, after that we have added the Oracle RAC database entity to OMC and enabled licenses for the Oracle RAC Database monitoring and finally we have verified all the Clusterware configuration including the agent status with step by step instructions.
Authors Bio
Nassyam Basha is a Database Administrator. He has around ten years of experience as a Production Oracle DBA, currently working as Database Expert with eProseed KSA. He holds a master’s degree in Computer Applications from the University of Madras. He is an Oracle 11g Certified master an Oracle ACE Director. He actively participates in Oracle-related forums such as OTN with a status of Super Hero, Oracle support awarded as “Guru” and acting as OTN Moderator and written numerous articles with OTN and on Toad World. He maintains an Oracle technology-related blog, www.oracle-ckpt.com and can be reached at https://www.linkedin.com/in/nassyambasha/
Monowar Mukul is currently working as a Principal Oracle Database Specialist. I am an Oracle certified Master (Oracle 12c Certified Master Administration, Oracle 12c Certified Master MAA and Oracle 11g Certified Master Administration). He has been working as an Oracle DBA consultant over 17 years with Oracle MAA space for both Exadata and non-Exadata Systems, Oracle Cloud Space and SOA Middleware. He worked across various business sectors including tertiary education, energy, government, mining and transport in Australia. He demonstrated highly developed critical thinking and analytical skills working as a Principal Oracle Database Specialist. You can find more details about him and his work achievements at https://www.linkedin.com/in/monowarmukul/
