Too Jewish with Rabbi Cohon

How to clean up Oracle archive logs when you don’t have a RMAN catalog (10g/11g)

If you’re not using Oracle’s RMAN for backup management but you have turned on archive mode for hot backups, you can create a job in Enterprise Manager (Maintenance -> Manage Current Backups).
Recently I ran into a problem with one our Enterprise Manager installs where scheduled jobs would not run. So, I wrote a very [...]

FW: Oracle 10g+ Security and Audit – Part 1

Over at the Database Geek Blog, Lewis Cunningham has provided the first of three blog posts on Oracle Security.  The first post is well done IMHO:

Oracle 10g+ Security and Audit – Part 1
This is a three-part definition of Oracle Security (specifically in 10g but applies to later versions also). Part 1 covers the various types [...]

Installing Oracle Instant Client and DBD::Oracle on Ubuntu Linux 8.04 Server JEOS

Ever want to just install the minimal amount of Oracle client software for client applications on Linux? Well, Oracle has provided Oracle Instant Client to do this but they have neglected to make it intuitive to install. I’ve written a couple scripts that make it easy on Linux. I’ve tested this on [...]

Installing Oracle 10g / 11g on Ubuntu 8.04.1 (Hardy Heron) Server JEOS in VMware Server 1.0x/2.0x

I’ve been tasked with becoming an Oracle DBA, so I need to be able to create an VMware Server image containing 32 bit Ubuntu 8.04.1 Server JEOS and Oracle 10g. Much of the work was taken from Augusto Bott’s Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon) and Peter Cooper’s How to Install [...]