Install Oracle 9i on Windows 2003 Server

Contents

Introduction

I recently installed Oracle 9i on Windows Server 2003 R2 Service Pack 1 and made the following notes. I used the Oracle discs for version 9.2.0.1.0. Note that some text has been blurred to protect the anonymity of the client.

Downloaded latest patchset from metalink (in this case it was Patch 9.2.0.7 for win32; p4163445_92070_WINNT.zip).

IMPORTANT: Sometimes I find better ways of doing things after I've taken the screenshots. Be sure to refer to the text below each screen shot for any alterations.

Run OUI

Remove the ORACLE_HOME environment variable if it exists.

Insert Oracle disc 1 and select "Install/Deinstall Products". This runs the Oracle Universal Installer.

Welcome

screenshot1

Click Next.

File Locations

screenshot2

We put oracle into D:\oracle\ora92. Click Next.

Available Products

screenshot3

Select Oracle9i Database 9.2.0.1.0 and Click Next.

Installation Types

screenshot4

Select Custom and Click Next.

Available Product Components

screenshot5

Deselect "Enterprise Edition Options", select "Oracle Management Pack for Oracle Standard Edition 9.2.0.1.0" under "Oracle Enterprise Manager Products 9.2.0.1.0. Click Next.

screenshot6

Component Locations

screenshot7

Made sure all components went into D:\oracle. Click Next.

Oracle Management Server Repository

screenshot8

Select "The Management Server will require a new repository" and click Next.

Create Database

screenshot9

Select Yes and click Next.

Summary

screenshot10

Review the options and space requirements and click Install.

Install

screenshot11

If you want to watch the log as it goes, fire up Cygwin and do something like below. This will probably slow down the installation though:

michael@questtest ~
$ cd c:

michael@questtest /cygdrive/c
$ cd Program\ Files/Oracle/Inventory/logs

michael@questtest /cygdrive/c/Program Files/Oracle/Inventory/logs
$ tail -f installActions2006-07-11_12-01-41PM.log

Disk Location

screenshot12

Don't forget you'll have to swap discs!

Oracle Net Configuration Assistant

Welcome

screenshot13

Select "Perform typical configuration" and click Next.

screenshot14

Database Configuration Assistant

DBCA: Welcome

screenshot15

Click Next.

DBCA: Step 1 of 8: Operations

screenshot16

Select "Create a database" and click Next.

DBCA: Step 2 of 8: Database Templates

screenshot17

Select "New database" and click Next.

DBCA: Step 3 of 8: Database Identification

screenshot18

We enter the same name for the global name and your SID. Click Next.

DBCA: Step 4 of 8: Database Identification

screenshot19

Deselect "Example Schemas" and say yes to delete the tablespace in the dialogue box. Click Next.

DBCA: Step 5 of 8: Database Connection Options

screenshot20

Select "Dedicated Server Mode" and click Next.

DBCA: Step 6 of 8: Initialization Parameters

screenshot21

These vary depending on the application and the hardware. The values I used are in the screen shot.

screenshot22

Change the Database Character Set to AL32UTF8.

screenshot23

The default block size and sort area are OK.

screenshot24

The default file locations are OK too.

screenshot25

Turn on Archive Log Mode. Consider using another drive/partition for these. Click Next.

DBCA: Step 7 of 8: Database Storage

screenshot26

Review the locations of the database files. Control file on D:, Y: and Z:. Tablespaces on Y:, Redo logs on Z:. Click Next.

DBCA: Step 8 of 8: Creation Options

screenshot27

Select "Generate Database Creation Scripts" to save your choices. Click Finish.

Summary

screenshot28

Saved HTML file for reference at C:\Quest\database-summary.html, then click OK.

screenshot29

Scripts should be created. Click OK.

screenshot30

The first couple of times we got error ORA-03113 here. This was because the user we were installing as wasn't in the administrators group on the local machine.

screenshot31

Enter your SYS and SYSTEM passwords and click Exit.

Enterprise Manager Configuration Assistant

EMCA: Step 1 of 3: Welcome

screenshot32

Click Next.

EMCA: Step 2 of 7: Create New Repository Options

screenshot33

Select custom and click Next.

EMCA: Step 3 of 7: Select Database Location

screenshot34

Select "In another existing database" and click Next.

EMCA: Step 4 of 7: Select Database for Repository

screenshot35

Enter the details for SYSTEM, the service as "localhost:1521:your SID", and click Next.

EMCA: Step 5 of 7: Repository Login Information

screenshot36

Enter a password twice and click Next.

EMCA: Step 6 of 7: Select Repository User Tablespaces

screenshot37

Defaults are fine. Click Next.

EMCA: Step 7 of 7: Create Repository Summary

screenshot38

Review and click Finish.

screenshot39

Another quick cup of tea.

screenshot40

Click close.

End of Installation

screenshot41

Click Exit.

Apply Latest Patchset

Login to Metalink and click on "Patches and Updates". Click "Simple Search" under patches. Search by "Product or Family", enter "RDBMS Server", select 9.2.0.x where x is the highest number. The platform is "Microsoft Windows (32-bit)".

screenshot42

At the time of writing, 9.2.0.8 was the highest patch level, but wasn't available for 32-bit Windows so I took 9.2.0.7. Download the patchset and unzip to somewhere outside of ORACLE_HOME, e.g. C:\Oracle_patch.

Run C:\Oracle_path\Disk1\setup.exe. This starts the Oracle Universal Installer. Note: this is a different version of the OUI than the one you installed from the CD. You must use this newer version.

From Control Panel -> Administrative Tools -> Services, stop the following services:

Welcome

screenshot43

Click Next.

Specify File Locations

screenshot44

Enter OraHome92 into the name field and this should update the path to your ORACLE_HOME. Click Next.

If any services are still running you'll see this:

screenshot45

Summary

screenshot46

Click Install.

Install

screenshot47

Fancy a brew?

End of Installation

screenshot48

Click Exit, then restart the following services:

Upgrade the database

Run SQL*Plus as SYS, restart the database and run the upgrade script. Note that this took around 30 mins for just one smallish OpenACS schema:

SHUTDOWN ABORT
STARTUP
SHUTDOWN IMMEDIATE
STARTUP MIGRATE
SPOOL C:\patch.log
@D:\Oracle\ora92\rdbms\admin\catpatch.sql
SPOOL OFF

Review C:\patch.log for any errors (there were none). Restart the database in the normal way.

Note: I forgot this step and it didn't manifest itself until I tried to drop a user, which gave the error:

drop user user cascade;
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [],
[], [], []

Detailed instructions can be found accompanying the patchset.

Sep 2006