Author Archives: April C Sims

About April C Sims

Oracle DBA for over a decade...enough said.

IOUG Collaborate 2016


Posted in Uncategorized | Leave a comment

Surviving A Month of Dead Connection Detection Zombie Land!

Timeline August 11th – Switched Over using a Physical Standby on new hardware for our ERP software in about 15 minutes. This was a manual SQLPLUS command-line method because of issues with using DataGuard to complete this task without hanging … Continue reading

Posted in Uncategorized | 3 Comments

Deinstalling an ORACLE_HOME in 11gR2 DB = MORE WORK!

This is a post about using the deinstall script (it is a perl script on UNIX machines) without some testing on a non-production server. Why? It has the ability remove important database components that may still be needed for that … Continue reading

Posted in Uncategorized | 6 Comments

Discounts on Packt Publishing Oracle Books

Calling all High Rollers: Hit the Oracle PacktPot! Packt Publishing prepares for COLLABORATE 12 with discounts on Oracle titles all month As a leading publisher of Oracle books/eBooks, Packt Publishing is inviting their readers to celebrate the upcoming COLLABORATE 12 … Continue reading

Posted in Uncategorized | Leave a comment

2011 in review

The stats helper monkeys prepared a 2011 annual report for this blog. Here’s an excerpt: The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 46,000 times in 2011. If it were a … Continue reading

Posted in Uncategorized | Leave a comment

Disabling ORACLE Reports to plug SQL Injection Attacks , Don’t do this if you still need Oracle Reports to WORK!

Posting this because I had a hard time disabling all of the reports functionality in Fusion Middleware Server…this will also work for older versions of Oracle Application Server. Just wanted to alert people to the fact that you may have … Continue reading

Posted in Uncategorized | 2 Comments

How to Install FMW Standalone Forms/Reports, AKA How to Get to Never Never Land

Hmmm….seems Fusion MW is Peter Panish – a child that doesn’t want to grow up. Our team is currently using in production the FMW (RH 5) install using the Standalone Forms and Reports 32-bit version. Having encountered memory leaks … Continue reading

Posted in Uncategorized | 17 Comments