In case you haven’t heard, Oracle database version 9i will be desupported as of June of 2007. That’s right, next month!

If this is the first you’ve heard of this, don’t panic. A Don Burleson points out you should be concerned if your shop is required to be on a fully supported Oracle release, but if that’s not a concern for you then you have a little leeway.

As described in this message from Oracle and metalink note 161818.1 extended support will be available through July of 2010 with the first year of extended support being at no additional cost.

If you don’t have a plan to get onto 10g (preferably 10gR2) it’s time to start getting one together.

oracle, database, database administration, dba

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

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

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:

$ORACLE_HOME/sysman/j2ee/config/jazn-data.xml

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

[XML]
enterprise-manager


ias_admin
sMrtt1fssLblHhltt97PfnotPLwWsaFr
[/XML]

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

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

« Previous PageNext Page »