Short Guide to install Oracle 10g on Windows 2000

Overview

The following short Guide shows how to install and configure Oracle 10g on W2K. You may download our Scripts to create a database, we suggest this way and not using the Database Configuration Assistant Besides these scripts, you can download our NET configuration files: LISTNER.ORA, TNSNAMES.ORA and SQLNET.ORA.

For our installation, we used the following ORACLE_HOME AND ORACLE_SID, please adjust these parameters for your own environment.

ORACLE_HOME = D:\Oracle\Product\10.1.0
ORACLE_SID = FOC1

Download Software and unpack the distribution

10g_win32_db.zip (604,262,301 bytes) (cksum - 384326363)

1. Check if your Download is OK
  cksum 10g_win32_db.zip

2. Unzip in an empty directory and run setup.exe in the /Disk1 directory

Setup Registry

Set the following registry variables using regedit in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE \KEY_Ora101

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_SID=FOC1
LOCAL=FOC1

Check the PATH Variable

Check the Environment variable PATH, ORACLE_HOME\BIN must be included.
Start->Settings->Control Panel->Sytem->Advanced->Environment Variables

Create the Oracle W2K-Service

The ORADIM utility is a command line tool that is available with the Oracle9i database. When you use the ORADIM utility, a log file called oradim.log opens in ORACLE_BASE\ORACLE_HOME\database, or in the directory specified by the ORA_CWD registry parameter. All operations, whether successful and failed, are logged in this file. You must check this file to verify the success of an operation. Create the W2K Service with the following command (all in one line):

oradim -new -sid FOC1 -intpwd <password> -maxusers 20 -startmode auto
 -pfile D:\Oracle\Product\10.1.0\Database\initFOC1.ora

Edit the initFOC1.ora and initFOC1.sql

cd D:\Oracle\Product\10.1.0\Database

Set your desired File Locations.

Create the needed Database Directories

The database directories must be created manually in the W2K Filesystem, Oracle does not create any directories. Usually the following directories must be created ( see initFOC1.ora and initFOC1.sql )

Drive 1

oradata/FOC1/ctl
oradata/FOC1/rdo

Drive 2

oradata/FOC1/adm/bdmp
oradata/FOC1/adm/cdmp
oradata/FOC1/adm/udmp
oradata/FOC1/adm/utld
oradata/FOC1/arc
oradata/FOC1/ctl
oradata/FOC1/idx
oradata/FOC1/rbs
oradata/FOC1/rdo
oradata/FOC1/sys
oradata/FOC1/tab
oradata/FOC1/tmp
oradata/FOC1/usr

Create the Database with initFOC1.sql

sqlplus /nolog
@initFOC1.sql

Check the Logfile

Stop and start the Database

sqlplus /nolog
connect sys/manager as sysdba
shutdown immediate
startup

Download Scripts for NT / W2K

Download here