Short Guide to install Oracle 9.2.0 on Windows 2000

On Oracle Technet (http://technet.oracle.com) you can find the distribution for Oracle 9i

The following short Guide shows how to install and configure Oracle 9.2.0 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.

rejabusaf

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\9.2.0
ORACLE_SID = ARK2

Short Installation Description

  Download Software and unpack the distribution

1. Create directories Disk1, Disk2 and Disk3.
2. cd to Disk1 and unzip the 92010NT_Disk1.zip here.
3. Repeat the above step for Disk2 and Disk3.
4. cd to Disk1 and start setup.exe to start the installer.

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

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_SID=ARK2
LOCAL=ARK2

  Check the PATH environment variable, ORACLE_HOME\BIN must be included

  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 ARK2 -intpwd <password> -maxusers 20 -startmode auto
 -pfile D:\Oracle\Product\9.2.0\Database\initARK2.ora

  Edit the file initARK2.ora and initARK2.sql and and save them to ORACLE_HOME\Database.

  Create the needed directories (see initARK2.ora and initARK2.sql)

The database directories must be created manually in the W2K Filesystem, Oracle does not create any directories. Usually the following directories must be created:

Drive 1

oradata/ARK2/ctl
oradata/ARK2/rdo

Drive 2

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

  Create the database with initARK2.sql

sqlplus /nolog
@initARK2.sql

Check the Logfile

  Stop and start the database

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

Install Oracle Options

You may want to install the following Options:

o        Oracle JVM

o        Orcale XML

o        Oracle Spatial

o        Oracle Ultra Search

o        Oracle OLAP

o        Oracle Data Mining

o        Example Schemas

Requirements

Make sure, your INIT.ORA Paramaters SHARED_POOL_SIZE
and JAVA_POOL_SIZE are big enough. We have successfully installed the 9i JVM with the following settings on a Windows 2000 server.

shared_pool_size = 200000000
java_pool_size = 100000000

Script to Install 9i JVM / Options

From your W2K command shell type ...

install_options.bat

... and check the generated logfiles.

Download Scripts for NT / W2K

These Scripts can be used as Templates. Please note, that some Parameters like ORACLE_HOME, ORACLE_SID and PATH must be adjusted for your own Environment. Besides this, you should check the initSID.ora Parameters for your Database (Size, Archivelog, ...)