We use VictorOps for our paging/notification system, and we're pretty happy with it so far. On the DBA team, we've just been using a simple email gateway to send notifications from Oracle Enterprise Manager (EM) to VictorOps. Even then, we can only send the initial notification and not really send... [Read More]
Just XFS Things
$ uptime 16:36:42 up 4 days, 12:28, 6 users, load average: 1029.20, 995.42, 865.77See https://www.centos.org/forums/viewtopic.php?f=47&t=52412 and https://access.redhat.com/solutions/532663 (requires RedHat subscription) for details. And defrag your XFS volumes.
The Leap Second is No Laughing Matter (if you have java on an older Linux kernel)
Earlier this month we began getting frequent email warnings from our EM12c server that some agents were experiencing read time outs. Then we saw that the emagent java process was using A LOT of CPU, regularly around 500% but sometimes as high as 800% as seen from "top". Restarting the... [Read More]
Upgrade to Oracle 12c, Get the Huge Trace Files for Free!
Last week we began testing a copy of our production database on Oracle 12c (220.127.116.11). This past weekend we were alerted that the disk holding our ADR diagnostic directory was near full. We noticed some pretty big (and recent) trace files there. Then it happened twice more. This last time... [Read More]
Returning Error Codes from sqlplus to Shell Scripts
When I have to run SQL scripts, I prefer to do it via executable ksh scripts (I use ksh because it's usually an Oracle pre-requisite so I can rely on it being installed). One thing that I've just recently started adding into my scripts is exiting sqlplus on error and... [Read More]