by Jason L Froebe on May 6, 2010, 3 comments
It is really really easy to change the default NLS_DATE_FORMAT setting but to be honest, you should set it at a session level IMHO. We basically just need to run “ALTER SYSTEM SET NLS_DATE_FORMAT=’YYYY-MM-DD’ SCOPE=SPFILE” as a user with sysdba privileges. If you started the Oracle instance without a spfile (it should be located at [...]
by Jason L Froebe on May 5, 2009, 3 comments
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 [...]
by Jason L Froebe on March 10, 2009, no comments
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 [...]
by Jason L Froebe on November 14, 2008, one comment
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 [...]
by Jason L Froebe on October 22, 2008, 4 comments
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 Ubuntu Linux 8.04 [...]