The Open Source Swiss Army Knife

/sql_servers/oracle/
/sql_servers/oracle/ + sub-categories		 http://www.sirfsup.com/
web directory content
     
      

Not logged in
Chat Register Login
return to:  http:/www.sirfsup.com      /sql_servers   /oracle 
Permalink: windows_install.htm
Title: add
article options : please login   |  print view
  1. 9i: attempt one (failed on win2k for lack of RAM - 64 k just doesn't cut it)
  2. 8i

9i for 2k

Oracle Services for Microsoft Transaction Server

Oracle MTS Recovery Service Configuration

"The Oracle MTS Recovery Service is automatically installed with Oracle Services for Microsoft Transaction Server. The Oracle MTS Recovery Service accepts requests to resolve in-doubt MS DTC-coordinated transactions started on this computer. Enter the port number on which the Oracle MTS Recovery Service will listen for requests on this computer."

---> 2030

Database Identification

"An oracle 9i database is uniquely identified by a Global Database Name, typically of the form "name.domain" . Enter the Global Database Name for this database."

---> Global Database Name: db.sirfsup.com

"A database is referenced by at least one Oracle9i instance which is uniquely identified from any other instance on this computer by an Oracle System Identifier (SID). A suggested SID has been entered which you can accept or change to a value you prefer."

---> SID: db

Database File Location

"For best database organization and performance, Oracle recommends installing database files and Oracle software on separate disks. The database software should be installed in Oracle Home on one disk, and the database content including datafiles, control files, and redo logs should reside on a different disk.

---> Directory for Database files: d:\oracle\oradata

Database Character Set

"Use the default character set"

Summary

Oracle9i Database 9.2.0.1.0

  • global settings :
  • product languages : english
  • New Installation (203 products)
---> Install ..........
---> you can find a log of this install session at c:\Program Files\Oracle\Inventory\logs\install\Actions2002-07-02_12-47-20PM.log

8i for NT minimum installation

  1. minimal installation
    1. assistant common files
    2. balishare
    3. Development tools
    4. EWT
    5. hotjava browser bean
    6. ice broser
    7. intelligent agent data gatherer
    8. jdbc common
    9. jre
    10. java swing components
    11. MS ODBC
    12. net 8
      • assistant
      • client
      • products
      • server
    13. administrative assistant
    14. configuration assistant
    15. administration assistant
    16. database configuration assistant
    17. database utilities
    18. documentation
    19. enterprise java beans
    20. oracle installation products
    21. jdbc drivers
    22. JServer enterprise edition
    23. java products & tools
    24. ODBC driver
    25. oracle sqlj
    26. oracle utilities
    27. oracle 8i enterprise edition
    28. oracle 8i enterprise edition release notes 8.1.5.0.0
    29. oracle 8i server 8.1.5
    30. sql plus
    31. sqlj translator
    32. ssl common files
  2. launch the oracle database configuration assistant, which, blow all, assists you in configuring an oracle database!
    select the procedure you want to perform
    • create database
      1. first time (first database)
        • global database name: itse
        • SID: itse
        • initialization file: d:\oracle\admin\itse\pfile\init.ora
        • enter the password for the INTERNAL privileged account: see mysql db
        • compatible parameter: 8.1.0
        • control file 1: d:\oracle\oradata\itse2309\control01.ctl
        • control file 2: d:\oracle\oradata\itse2309\control02.ctl
        • max datafiles 254
        • max log files: 32
        • max log members
            all the following are followed by *.dbf in the d:\oracle\oradata\itse2309\ directory
          • system - system01.dbf
          • users - users01.dbf
          • rollback - rbs01.dbf
          • index
          • temp
        • redo log files (redo01.log and redo02.log)
        • trace files
          • user processes - udump
          • background processes - bdump
      2. second time (second database)
        • global database name=itse
        • SID=itse
      3. third time (third database, was a stored file and ran as a batch file, and it really went through)
        since system only has 64M RAM saved thefile to a batch file so I can run it when that damn java installer goes offline
        • OracleServiceORACLE
    • delete a database
    • modify a database

    there is a log of this in System_drive\Program Files\Oracle\Inventory\logs\installActions.log

    initial connection

    1. start a database instance