Author Archives: April C Sims

About April C Sims

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

Archive Logs in $ORACLE_HOME/dbs

This has been happening over the years but I couldn’t figure out why….finally found this article on My Oracle Support (MOS): ┬áSetup Local archiving on standby to Prevent Logs sent to $ORACLE_HOME/dbs (on both GRID and SQLPLUS) (Doc ID 1271095.1) … Continue reading

Posted in 11g, DATA GUARD, MOS, my oracle support, oracle, Physical Standby, RMAN, standby, Uncategorized | Leave a comment

IOUG Collaborate 2016

Collaborate_Sims_1235_final

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 WordPress.com 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