Author: Matheus Boesing

How to Set Up Out Of Band Notifications in OEM 13C

So, after an abnormally quiet weekend, I was being paged: Oracle Management Services (OMS) was down! Well, this requires monitoring the monitoring, right? So, how to monitor the monitoring? Oracle Enterprise Manager (OEM) 13c has a feature called Out of…

Read More >

AWS’s Top 5 Commands: ALTER SYSTEM and Managing SYS Objects in RDS

We often manage services over EC2, this is not news. But when migrating to Amazon RDS, it’s usual for new users to have issues with performing some administrative actions on the database, especially when it’s done via internal Oracle procedures…

Read More >

How to Automate Killing Inactive Sessions with Resource Manager

Are you manually (or via a script) killing idle sessions on your database? As a consequence, your users are getting error “ORA-00028: your session has been killed” and probably getting angry at you. What about doing it automatically, in a…

Read More >

Why you should not uninstall Database Vault from a CDB

Now that we are fully into database upgrades, here is an important item to be aware of: As you may know, the Database Vault (DV) option could be reported as not installed in source when converting non-CDB to PDB, and…

Read More >

How to fix Error: OMSPatcher finds that previous patching session is not yet completed

When planning a patch for a client’s OMS, I found the following: OMSPatcher finds that previous patching session is not yet completed. Please refer log file “/u01/app/oracle/middleware/cfgtoollogs/omspatcher/28018178/omspatcher_2019-07-09_23-44-58PM_deploy.log” for the previous session and execute the script “/u01/app/oracle/middleware/.omspatcher_storage/oms_session/scripts_2019-07-09_23-44-39PM/run_script_singleoms_resume.sh” to complete the previous…

Read More >

How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error

Have you received this error on OMS 12.1.0.3? “Metric evaluation error start – Get dynamic property error,” After performing some research on MOS and a confirmation SR, it seems related to Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH…

Read More >

How to Reduce Exadata Core Count

During preparation for a client’s datacenter migration, we decided to move services one-by-one to the datacenter / hardware in order to keep the scope of changes controlled. To accomplish this, we also needed to resize the CPU count of Exadata…

Read More >

Stop Migrating Databases to 12c!

If you are starting an upgrade plan, do it directly to Oracle Database 19c. Why? Well, let’s agree that 19c is “equivalent” to 12.2.0.3 on previous version models, and 18c would be 12.2.0.2, after the latest in the old format:…

Read More >

Exadata: 7 Useful Commands to check Port/Sensor Alarms

Some days ago I was checking for the alarm below, with a very generic message: Message=The aggregate sensor /SYS/CABLE_CONN_STAT has a fault. So, I decided to document some useful commands I used to verify all ports/sensors in my Exadata cluster….

Read More >

How to fix InfiniBand Error: Cable is present on Port “X” but it is polling for peer port

Facing an InfiniBand error? Let me guess: Ports 03, 05, 06, 08, 09 and 12 are alerting? You have a Quarter Rack? Have recently installed Exadata plugin to version 12.1.0.3 or higher? Don’t panic! This is probably related to Bug 15937297:…

Read More >
Page 4 of 41234