Tuesday, March 28

Oracle on CentOS 4.3

Just to confirm, 10g/10gR2 and 9iR2 all work perfectly on CentOS 4.3. 9iR2 needs the normal RHEL 4 patch from Metalink.

And little simple SQL query I wrote the other day.
This little sniplet shows how long ago the last archive log was applied.
round((sysdate-max(completion_time))*60*24) min_ago

I used this query to write a simple Nagios plugin to make sure our Oracle Dataguard standby machines do actually keep receiving logs.

The script in full here.

No comments: