Jason L. Froebe - Tech tips and How Tos for Fellow Techies

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 [...]

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 [...]

In case you have to create an Oracle 10g Enterprise Manager instance from scratch, it is very easy.

emca -repos create
emca -config dbcontrol db

If you need to blow away the existing Enterprise Manager configuration, you can either recreate the repository, which will wipe out all the configurations:

emca -repos recreate
emca -config dbcontrol db

or, you can recreate just [...]

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 [...]

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 [...]