Author: Matheus Boesing

I received the above message related to an ORA-7445 on my 11.2.0.4 database: ORA-07445: exception encountered: core dump [kcflfi()+1016] [SIGFPE] [Integer divide by zero] [0x10053AD10] [] []     After some checks, I noticed the following: SQL> select file_name, bytes…

From ORAchk/EXAchk/ODAchk, Database Security Assessment Tool (DBSAT) and Hang Manager, to Cluster Health Advisor (CHA), Cluster Verification Utility (CVU), Memory Guard and Tracefile Analyzer (TFA), Oracle DBAs have an abundance of great tools at their fingertips. Another plus is there’s…

I wanted to share a brief summary–a cheat sheet–to highlight the Autonomous Health Framework (AHF) setting and how we use this great tool in database installations. AHF is an out-of-box solution that provides automated monitoring and proactive issues detection. If…

I ran across an interesting case within OEM 12 (Oracle Enterprise Manager) Release 5. A client reported the “tablespace allocation metric” was not being updated on OEM for a specific database. In this case, the most recent gathering was done…

This seems like a simple message to fix, right? The parameter is different between the broker configuration and the database parameters—it was most likely changed directly on the database after the DG (Data Guard) broker configuration was created or the…

In a previous post, I discussed that the APEXExport tool may be the best one to use when exporting APEX applications. You may also have experience using this tool. Today, I’d like to present some alternatives to the APEXExport tool….

I was performing a spot health check in a client environment, when I encountered this: [[email protected] ~]$ crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [12.1.0.2.0] [[email protected] ~]$ crsctl query crs activeversion -f Oracle…

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Hanganalyze Now, onto today’s post: Many DBAs have been…

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: ASH Dump Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto…

Editor’s note: This “post-mortem analysis” series consists of four posts in total. Make sure you also check out: Post-Mortem Analysis Tools: Systemstate Dump Post-Mortem Analysis Tools: Hanganalyze Post-Mortem Analysis Tools: Using Preliminary Connection (publishing Thursday, April 22) Now, onto today’s…