Zurück

Short Guide to install Oracle 8.1.7 on Windows NT4 / 2000


The following short Guide shows how to install and configure Oracle 8.1.7 on NT/W2K. You may download our Scripts to create a database, we suggest this way and NOT using DBASSIST. Use DBASSIST only to generate a template script, because some important INITSID.ora values are wrong and may lead to a poorly tuned database. Besides these scripts, you can download our NET8 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\8.1.7
ORACLE_SID = ARK1


Short Installation Description

  Download Software or install CD-ROM in ORACLE_HOME, do not create a database.

  Set the following registry variables using regedt32.exe in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

NLS_LANG=AMERICAN_AMERICA.UTF8
ORACLE_SID=ARK1
LOCAL=ARK1

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

  Create the Oracle NT-ServiceNT

oradim -new -sid ARK1 -intpwd <password> -maxusers 20 -startmode auto
 -pfile D:\Oracle\Product\8.1.7\Database\initARK1.ora

Check the Logfile ORADIM.LOG in the current directory. The file PWDARK1.ORA  
(Password File) was created.

  Create the Oracle Listener-Service with the Net8 Configuration Assistant

  Start the Oracle Listener-Service, first edit the file ORACLE_HOME\network\admin\listener.ora

net start OracleORA816TNSListenerLSNR817

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

  Create the needed directories manually in the NT4 / W2K Filesystem, Oracle does not create any directories.

  Create the database with initARK1.sql

svrmgrl
@initARK1.sql

Check the Logfile

  Stop and start the database

svrmgrl
connect internal
shutdown immediate
startup

  Create Oracle Enterprise Manager Repository

vobsh -c "oem/oem" -o CREATE -p "ALL"

If you want you can delete the Repositiory any time later with

vobsh -c "oem/oem" -o DROP -p "ALL"

  Start Oracle Enterprise Manager Agent

net start oracleAgent80

  Recreate Password File for SYS

orapwd file=pwdARK1.ora password=<password> entries=20

  Set INIT.ORA Parameter

remote_login_passwordfile = exclusive

  Set Password File "hidden"

attrib +h pwdARK1.ora

  Set Password File non "hidden"

attrib -h pwdARK1.ora

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 on your own Environment. Besides this, you should check the initSID.ora Parameters for your Database (Size, Archivelog, ...)

Version 7.3.3 (SID=PARA)

Version 8.0.3 (SID=PAR1)

Version 8.0.4 (SID=RAB1)

init<SID>_init.ora

init<SID>_init.ora

init<SID>_init.ora

init<SID>.ora

init<SID>.ora

init<SID>.ora

init<SID>.sql

init<SID>.sql

init<SID>.sql

listener.ora

listener.ora

listener.ora

tnsnames.ora

tnsnames.ora

tnsnames.ora

sqlnet.ora

sqlnet.ora

sqlnet.ora

snmp.ora

nicht mehr benötigt

nicht mehr benötigt

topology.ora

nicht mehr benötigt

nicht mehr benötigt

Download all Files
(ALL_FILES.tar.gz)

Download all Files
(ALL_FILES.tar.gz)

Download all Files
(ALL_FILES.tar.gz)

Version 8.0.5 (SID=ARK2)

Version 8.1.5 (SID=ARK1)

Version 8.1.6 (SID=SAP1)

init<SID>_init.ora

init<SID>_init.ora

init<SID>_init.ora

init<SID>.ora

init<SID>.ora

init<SID>.ora

init<SID>.sql

init<SID>.sql

init<SID>.sql

listener.ora

listener.ora

listener.ora

tnsnames.ora

tnsnames.ora

tnsnames.ora

sqlnet.ora

sqlnet.ora

sqlnet.ora

Download all Files
(ALL_FILES.tar.gz)

Download all Files
(ALL_FILES.tar.gz)

Download all Files
(ALL_FILES.tar.gz)

Version 8.1.7 (SID=SMA1)

   

init<SID>_init.ora

   

init<SID>.ora

   

init<SID>.sql

   

listener.ora

   

tnsnames.ora

   

sqlnet.ora

   

Download all Files
(ALL_FILES.tar.gz)