There comes a time in every Microsoft developers life that he/she will have to work with an Oracle database. I hope that you find this to be a good experience; my experiences have thus far been a mixed bag, mostly because of my own ignorance. Nevertheless, I’ve picked up a few things here and there, and figured that it would be worthwhile to post some of the top tips and tricks I’ve learned over the years.

In this post, I want to discuss how to setup an Oracle database server. I am going to follow-up with a post on how to create an Oracle database. I use those terms loosely, because the terminology within the Oracle world is different from the SQL Server world. I promise I’ll do my best to get it right, but chances are I’ll make a mistake or two - please feel free to point out my gaffes.

So, without further ado, let’s see go through the steps needed to install Oracle 9.2 (sorry, I don’t have 10+) on Windows Server 2003 32-bit (note: there are many differences between 32-bit and 64-bit Windows, and my experience has shown that the following steps will not work in 64-bit Windows. Perhaps I’ll follow-up in the future if I figure out how to get it to work …)

  1. Secure a copy of Oracle 9.2. I assume that you have a copy available through work.

  2. Start the Oracle Universal Installer. Click the Next button.

  1. Confirm the installation destination (you’ll need at least 3 GBs available for the installation) and click Next.

  1. Select “Oracle9i Database 9.2.0.1.0”, and click Next.

  1. Select “Enterprise Edition”, and click Next. (Why? Well, I don’t have any compelling reason here - it’s just what I’ve used to get things working …)

  1. Select “General Purpose”, and click Next.

  1. Leave the Port Number as 2030, and click Next.

  1. Define the Global Database Name. I choose “orcl”, but feel free to choose whatever. Make sure that the SID is unique - it’s probably easiest to make it the same value as the Global Database Name. Click Next.

  1. Specify the Directory for Database Files. I choose to leave the default value. Click Next.

  1. Unless you have a reason to change it, leave the “default character set” selected, and click Next.

  1. On the Summary screen, click Install. This installation process will take a little while. Be patience. Read one of my other posts, while you’re waiting.

  1. The next screen to appear is the Database Configuration Assistance. On this screen, specify the SYS and SYSTEM passwords. Do NOT click OK yet.

  1. Before you click OK, click the Password Management Button. Specify passwords for SYS, SYSTEM, and DBSNMP (SCOTT too, if you’d like).

  1. Once you get to the End of Installation, click Exit.

  1. After you click Exit, the Oracle Enterprise Management Console will start. Check and make sure you can log into your Oracle database server by expanding databases, right-click ORCL (or whatever you called it) and click Connect. Enter the “system” Username, and change Connect as from “Normal” to “SYSDBA”. Click OK.

  1. If you were able to successfully connect to the Oracle database server, then restart Windows. There’s a number of reasons to do this, including updates to the PATH environment variable.

And that’s it!

Now, I realize that this installation procedure pretty much accepts the defaults, and clicks next. However, at least you have the benefit of knowing that this procedure does work, and will prepare you for the next step: configuring Oracle databases, tablespaces, users, and user access.

Best of luck!