Two Oracle user group events in California this week

Donald Burleson points out two Oracle user group events happening in California this week. There’s the Northern California Oracle Users Group Spring Conference and the Los Angeles Oracle Users Group Spring Conference.

Unfortunately I’m on the wrong coast to take advantage of these, but if you are in or near California check it out. It’s important to take advantage of these conferences when they’re close to home!

dba, database administration, database, oracle, conference

Shell Scripting Presentation at the Green Mountain Oracle User Group

GMOUGNext Tuesday, May 8th I will be presenting at the Green Mountain Oracle User Group annual meeting in South Burlington, Vermont. The topics will be Shell Scripting for the Oracle Professional and SQL Tuning.

This event is $20 for members (which includes breakfast and lunch) but non-members can pay $90 for the registration fee and 2007 dues. The event also includes the annual meeting of the GMOUG so it would be a great time to join and meet some of the members!

The event is in South Burlington, Vermont and will run from 8:15 AM to 4:00 PM. See the GMOUG website for a full agenda and RSVP information.

vermont, technology, oracle, information technology, unix

How to reset a lost Oracle Enterprise Manager password

Below documents how I was able to reset the ias_admin password for an Oracle Application Server 9i instance. This may or may not work on other versions or products. If in doubt, check with support.

Oracle’s Enterprise Manager Web Site will enforce use of the current Administrator (ias_admin) password when you log in to Enterprise Manager, stop the Enterprise Manager Service, or change the ias_admin password. If you have forgotten your ias_admin password then you must reset it using the following procedure while you are logged on to your system as the person who installed Oracle Application Server:

1. Edit the following file and locate the line that defines the credentials property for use the ias_admin user:


The jazn-data.xml with the credentials entry in boldface type:



2. Remove the entire line that contains the credentials property from jazn-data.xml.

3. Set a new password with emctl set password reset new_password

I hope this helps if folks have this same problem, but as I mentioned above, mileage may vary. If you’re unsure, check with support.

oracle, application server, oas

Seven Deadly Habits of a DBA

In my travels today I came across the Pythian Group’s Seven deadly habits of a DBA… and how to cure them.

Citing such pitfalls as blind faith in backups, lack of monitoring and finger pointing we’ve all seen these symptoms at one point or another, and they’re all worth some attention. While many of these are largely a product of inexperience I’ve seen my favorite, number 4, The Memory Test at all levels. The “if it happens again I’ll remember how we fixed it” syndrome is often a product of another environmental problem, a lack of documentation procedure. This exact problem is one reason I started blogging in the first place!

Check out the whole list, including their suggested cures for these problems.

dba, database, database administration, oracle

Bestselling Oracle books and a bit about the biz

Don Burleson has an interesting artucle about some of the bestselling Oracle authors. Perhaps more interesting than the actual list is Don’s comments on how the book market has changed from the 90’s to the 00’s. He also talks a little about how royalties work.

Fair to say that today’s Oracle author (me included) isn’t expecting to get rich from their books, but it remains a great way to increase your personal visibility, give a subject a more complete treatment than it might otherwise get and help ease the learning curve for others who are less experienced.

oracle, technology, book, books, book sales, author, writing, publishing, royalties