Oracle Designer 9i to 10g Upgrade

I know I said “A day with Ralph Kimball, Part 2” would be next but I wanted to get this tech note out there while it was fresh in my mind. I’ll post items like this periodically as they occur to me to do so.

I upgraded our Oracle Designer repository from 9i to 10g. It looks like the little things that annoyed me in 9i will continue to do so in 10g, at least in the short term. I don’t see any dramatic changes and my problem child ERD still can’t be transformed to tables. I have a UK/PK conflict that I can’t seem to resolve.

Anyway, I wanted to address the upgrade more than features. Something to note, when you use Designer 10g, the version is still 9, to be exact (at least for now). Don’t expect the displayed version to change to 10g when you’re in the designer tools.

The first step to the upgrade is downloading and extracting the patch. The download is on Oracle Tech Net (OTN, under the 10g Developer download section. Apply the patch to your client side install of designer 9i. If you don’t have designer 9i already installed, you should download and install that first.

For the upgrade, use the same home where your previous installation of designer resides. I tried a couple of tests and with will let you install the patch without having Developer 9i installed (which is useless) and it will let you install to a different home which results in a non-functioning install. 9i will still work but you get errors when running the 10g tools.

The client side upgrade is pretty standard using Universal Installer. If you installed Developer previously, it will be nothing new. Except for making sure you select the correct home (I have 5 or 6 on my workstation), you should probably just accept the defaults and continue to completion.

The server side upgrade is performed from inside the Repository Admin utility (RAU). Unlike a Repository install, you don’t need the sys password to upgrade. Everything is done using the repository manager account. Using RAU 10g, connect to the repository to be upgraded as the repository manager and select the upgrade button. You’ll get the opportunity to optionally change some tablespaces (at least I did). I’m running with the Oracle recommended tablespaces so I chose to accept the defaults and continued on. The upgrade ran for about 30 minutes on my R&D server (that’s a P4 with 1gig ram and ata hard drive running Linux Fedora 3).

If you’re doing this in production, please take a backup first. I had no issues but you can never tell when the hardware might burp or when you will get a conflict on your system.

This is how upgrading should be. Simple, flawless, I give it two thumbs up. This is obviously a case where the upgrade process was engineered into the application. All applications should consider these kinds of things in the design phase and not as an after thought. Designer is a well thought-out, mature application. It also helps that the installer is such a mature product also. Does anyone remember the crappy installer back in the CDE days? Blech.

To verify your install, just select the about box. The version should be

I’m working on part 2 so I hope to post that either tomorrow or Thursday.


Technorati : , , , , , , , , , , , , , , , , ,

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.