Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

Install PL/JAVA in Postgres Plus Advanced Server 9.5

By | Database Administration & Monitoring | 28 Comments

While doing a project at a customer we came to a point where we needed to install pl/java into Postgres Plus Advanced Server 9.5. If you follow the official documentation you will probably fail and get stuck when trying to build pl/java with maven (at least I did fail several times). Unfortunately there is not much documentation around for solving the issues that popped up. As we have a very good communication channel into EnterpriseDB…

 
Read More
Oracle Team

GTT in Exadata are eligible to SmartScan

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I wanted to check if Exadata predicate offloading can occur on Global Temporary Tables. Actually, I thought it did not and I was wrong. I was ready to post that as an hypothesis for https://community.oracle.com/thread/3903836 but, before any post to forums, I try to test what I say because I may be wrong, or things may have changed from versions to versions. Here I will show how it’s easy to quickly…

 
Read More
David Barbarin

Sudden drop of the page life expectandy but don’t panic yet!

By | Database Administration & Monitoring, Development & Performance | No Comments

A couple of weeks ago, I had an interesting discussion with one of my customer about the page life expectancy (aka PLE). He asked me if monitoring the metric value is a best practice because he often noticed a big drop of the PLE under the recommended threshold during the night or sometimes during the business hours. In addition, he didn’t want to get false positive especially during the night when maintenance tasks are performed without…

 
Read More
Nathan Courtine

SQL Server Database failed to generate a checkpoint

By | Database Administration & Monitoring | One Comment

Last time, I experienced a strange error when I tried to perform an integrity check or a simple checkpoint of a database: One or more recovery units belonging to database ‘mydatabase’ failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to database corruption. Examine previous entries in the error log for more detailed information on this failure. The log scan…

 
Read More
Pierre Sicot

Always-on Monitoring EM 13C

By | Database Administration & Monitoring | No Comments

As the Enterprise Manager Cloud 12c is configured for sending warnings and alerts if a target database is down, what’s happening if the Enterprise Manager Repository database crashes? With Enterprise Manager Cloud Control 12c, a quite good solution is available: after an easy configuration, the management agent is able to run script to notify database administrators there is a problem with the repository. But what happens if the OMS itself is down? Enterprise Manager 13c offers…

 
Read More
Pierre Sicot

EM 13c target is fully broken !!

By | Database Administration & Monitoring | 2 Comments

At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at this timeI discovered that half of my database targets in 11.2.0.3 version were in the following state : 2016-02-05 15:31:46,863 [2527:A154C6AD] INFO – Target: [oracle_database.TESTDBA] is fully broken: Dynamic Category property error (code=0x400) The gcagent.log showed…

 
Read More
Oracle Team

The taboo of ‘underscore parameters’

By | Database Administration & Monitoring | 6 Comments

By Franck Pachot . Oracle provides lots or parameters that can control the behavior of the software. The default values are probably the best ones most of the time. Hundreds of parameters are documented and we can set them to customize the Oracle software for our context because default values can’t fit all different database sizes, usage, workload, infrastructure, etc. And in addition to them there are those ‘underscore parameters’ or ‘hidden parameters’ or ‘undocumented…

 
Read More
Mouhamadou Diaw

Dataguard Environment and Database Tempfiles

By | Database Administration & Monitoring | One Comment

Last day I found a curious message in the backup alert log in a dataguard environment. The message was related to an issue with the resync catalog and was something like RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of resync command on default channel at 02/18/2016 17:48:42 ORA-00001: unique constraint (RMAN.TS_P2) violated After few researches, it seems that this error is due to a mismatch of tempfiles between Primary and Standby….

 
Read More