Oracle 8i Download For Windows

Posted on |

  1. SQLTools is a spin-off of the original SQLTools for Oracle. Like the original SQLTools SQLTools is a light weight and robust Windows GUI SQL frontend for Oracle databases. It works with Oracle 7.3/8/8i/9i/10g and 11g. Note: Oracle Client required.
  2. Oracle 8i isn't supported on Windows 10. You needed 11.2.0.4 in order to run Oracle on Windows 8 - let alone Windows 10 I'll see if I can find the OS compatibility chart for you.
  3. Oracle 8i free download - Toad for Oracle (64-bit), Oracle 10g, Runes, the Ancient Oracle, and many more programs.
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
For

Oracle 8i software, free download For Windows 7 32 Bit DOWNLOAD 5f91d47415 Oracle8i - Free downloads and reviews - CNET Download.comoracle8i free download - Cydia Installer, OpenLink Lite Edition ODBC Driver for Oracle 8i & 9i.

Oracle 8i download for windows 8 64-bit

Note: The Oracle ODBC driver is installed bydefault when installing the Oracle Client.

Oracle 8.1.7 Client is supported in Windows 95,98, NT, and 2000. If you requireOracle Client 8.1.7 for Windows XP, you should use this web form tocontact UITSEnterprise Decision SupportServices for compatibility information.

Preinstallation instructions

  1. From the Start menu, select Find, and thenFiles or Folders.
  2. In the 'Named' field, type mfc42u.dll. Usingthe 'Look In' drop-down box, search all drivers that have or have hadOracle programs installed. Click Find Now.
  3. If Windows doesn't find a file with this name, skip the remainingsteps, close the 'Find' window, and proceed to either Running Oracle Client Setup from CD or Running Oracle Client Setup from IUwareOnline. If Windows finds the file, follow the remainingsteps.
  4. Right-click mfc42u.dll, and in the Namecolumn, choose rename.
  5. Move the cursor to the end of the filename and type a few lettersto change it. For example, type orig at the end of thefilename, changing it to mfc42u.dllorig, and pressEnter.
  6. After successful completion of these tasks, you are now ready toinstall the Oracle Client. Close the Find window. If youhave a Client CD, proceed to the next section, Running Oracle Client Setup from CD. Otherwise,proceed to Running Oracle Client Setup fromIUware Online.

Running Oracle Client Setup from CD

To install Oracle Client from CD:

Note: If you are using Windows NT or 2000, log inas Administrator.

  1. Insert the Oracle Client CD and wait for the Oracle8i Client- Autorun window to open. If it doesn't auto-start,double-click My Computer, double-click the CD-ROM icon, andthen double-click setup.exe.
  2. You can now skip to the section Clientinstallation process.

Running Oracle Client Setup from IUware Online

Note: This method of installation is analternative to using an Oracle Client Setup CD.

  1. Visit IUware at:
  2. From the Software menu to the left, clickDatabase.
  3. From the list of choices, click Oracle8i (8.1.7) Client Softwareand Documentation.
  4. Click Download. Enter your Network ID whenprompted, and then click Save to save the file to yourcomputer.
  5. After the download is complete, start the installation wizard bydouble-clicking the setup.exe file that was saved to yourcomputer. A window will open showing where the files will be unpacked.Type C:IUware OnlineOracle8.1.7 Client for thedirectory or click Browse to set the location, and then clickNext.

    Note: When installation is complete, you can deletethe C:IUware OnlineOracle8.1.7 Client folder and its contents.

  6. The wizard will spend several minutes installing files to thedirectory you specified. When it is complete, check the box next toInstall Oracle 8_17 Client, and then clickFinish. If you would prefer not to start the Oracle Clientinstallation now, uncheck this box and click Finish, and whenyou are ready to install the Oracle Client, open thesetup.exe program directly from the folder in which youinstalled the installation files.

Client installation process

Before continuing, you must have the following four pieces ofinformation:

  • The name or SID of the database (e.g., oed1) and thefull service name of the database that includes an SID followed by anextension (e.g., oed1.world oroed1.ucs.indiana.edu)
  • The version of the database to connect to (8 or8i)
  • The name or IP address of the computer hosting theOracle database
  • The port number (default is 1521)

Note: Confirm this information with thedatabase administrator before proceeding.

  1. When installation has begun, a window will appear with threechoices:
    • Install/Deinstall Products
    • Explore CD
    • Browse Documentation

  2. Choose Install/Deinstall Products.
  3. When the Oracle Universal Installer appears, chooseNext.
  4. The default file locations are shown. Click Next if thedefault file locations are acceptable (recommended). Otherwise, entera new path for the destination of your files and clickNext. Oracle will load the product information.
  5. A window titled 'Installation Types' will open. The selections are:
    • Administrator (356 MB): Includes managementtools in addition to Net8, SQL*Plus, and the ODBC drivers.
    • Programmer (233 MB): Recommended for mostsetups. Includes Net8, SQL*Plus, and ODBC drivers.
    • Application User (157 MB): Does not includeSQL*Plus. Installs very basic network software.
    • Custom: Installs whatever items are wanted.Space usage is variable.

    Choose Programmer unless your needs differ, and then selectNext.

  6. Product information will load, and then the summary informationwill be displayed. (If there is a previous version of Oracle on yourcomputer, it will be removed before installing.) Check the summaryinformation and choose Install.
  7. Oracle will begin the installation. This will take some time.

    Note: If you receive an error 'mfc42u.dll', youmay need to work through the Preinstallation instructions at thebeginning of this document.

  8. Once the software installation has completed, to configure theOracle Net8 client, follow the instructions in the section Configuring Net8 for Windows 95, 98, NT, and 2000.

    Note: If the installer freezes at this point ofthe installation, see ARCHIVED: How do I configure Net8 manually?

    To configure Net8 at a later time, follow the instructions in thesection Adding new database services.

Configuring Net8 for Windows 95, 98, NT, and 2000

  1. From the Net8 Configuration Assistant 'Welcome' window, chooseNext.
  2. The first window has two radio buttons. Selecting Yeswill create a directory service, whereas selecting No willallow you to create net service names manually. Choose No(unless instructed otherwise), and then click Next.
  3. In the 'Naming Methods' window, accept the default value (Local),and then click Next.
  4. The next window asks what version of Oracle database or service toaccess. Choose the same database version as the one you areconnecting to (i.e., 8 or 8i). Click Next.
  5. In the next window, you will be asked to enter either the servicename (for 8i) or SID (for 8).
    • If you chose 8i as the database version, type the name of thedatabase followed by an extension (usually .world, e.g.,oed1.world). Click Next.

      Note: If you do not know the service name, checkwith the database administrator.

    • If you chose 8 as the database version, type the name of thedatabase SID (e.g., oed1), and then choose Next.

  6. By default, TCP should already be selected. If not,choose TCP, and then click Next.
  7. Enter the hostname (e.g., dbserv.uits.indiana.edu),and then click Next. Unless specified otherwise, leave thedefault port number as 1521.
  8. Choose Yes, perform test to make sure the configurationis successful, and then click Next.

    Note: If the login test fails, click theChange Login button. Type your correct user informationand try again. When the test is successful, click Next.

  9. You will be prompted to choose Yes or No toconfigure another net service name. If you choose Yes,follow the instructions in this section again. If you chooseNo, the installation is complete, and you can proceed to thenext step.
  10. Click Next, then Next again, thenFinish, and then Exit. Click Yes whenprompted to confirm exiting the program.

You are done configuring the Oracle Client. At this point, you maywant to go the section Connecting to Oracle withSQL*Plus. Or, if you want to set up ODBC data sources forconnecting to Oracle from applications such as Access or ER/Studio, goto the section Configuring and locating an ODBC datasource.

Adding new database services

To set up an Oracle Client connection to an Oracle database onanother computer:

  1. Navigate to Start Oracle Network Administration Net8Configuration Assistant.
  2. Choose Local Net Service Name Configuration, and clickNext.
  3. Click Add, and then click Next.
  4. The next window will prompt you for the version of Oracle databaseor service to access. Choose the same version of database as theversion of the database being connected to (either 8 or 8i). ClickNext.
  5. In the next window, you will be asked to enter either the servicename (if you chose an Oracle 8i database) or the SID (if you chose anOracle 8 database).
    • If you chose 8i as the database version, type the name of thedatabase followed by an extension, (usually .world, e.g.,oed1.world). Click Next.
    • If you chose 8 as the database version, type the name of thedatabase SID (e.g., oed1), and then click Next.

  6. By default, TCP should already be selected. If not,choose TCP, and then click Next.
  7. Enter the hostname (e.g.,dbserv.uits.indiana.edu). Unless specified otherwise,leave the default port number as 1521. Click Next.
  8. Choose Yes, perform test to make sure the configurationis successful. Click Next.

    Note: If the login test fails, click ChangeLogin. Enter your correct user information, and clickNext when the test is successful.

  9. Enter the net service name (use the same name you chose in step5, e.g., oed1.world). Click Next.
  10. To configure another net service name, choose Yes, andrepeat the instructions in this section. To exit, choose No,then click Next twice, and then Exit.

Connecting to Oracle with SQL*Plus

To connect to Oracle with SQL*Plus:

Oracle 8i Download For Windows

  1. From the Start menu, select Programs, thenOracle, then Application Development, and thenSQL Plus.
  2. In the spaces provided, enter your Oracle username andpassword. For 'Host String', for example, if you are connecting to theOed1 database, type oed if you chose anOracle 8 database, and oed1.world if youchose an Oracle 8i database. Click OK.
  3. You should now be in the SQL*Plus command line interfaceenvironment. If you would like to change your password, see ARCHIVED: How do I change my Oracle password using SQL*Plus?

Configuring and locating an ODBC data source

Programs that use ODBC to connect to remote databases must have away to identify the type of database and the computer to which theywish to connect. This is accomplished through an ODBC data source,which associates a name with some database connection information. Inthe case of Oracle, the database connection information is simply thename of the Net8 Service you set up during the Oracle ClientConfiguration.

To configure and locate an ODBC data source:

Oracle 8i Download For Windows 10

  1. From the Start menu, select Settings, and thenControl Panel.
  2. Double-click ODBC Data Sources (on some systems, this iconmay be named ODBC or ODBC Data Sources (32-bit)). InWindows 2000, this is in a separate folder. If you are using Windows2000, double-click the Administrative Tools folder. Withinthe Administrative Tools folder, click ODBC DataSources.
  3. At the top of 'ODBC Data Source Administrator' window, click thetab labeled System DSN. Click Add.
  4. In the list, select Oracle ODBC Driver, and then clickFinish.
  5. Enter the following information in the Oracle ODBC for OracleSetup window:

    Note: The examples listed will create an OracleODBC data source for the Oed1 database ondbserv.uits.indiana.edu.

    Field Explanation Example
    Data source name
    User-specified name by which you will refer to this ODBC data source
    		oed1_ora
    Description
    Not required; just a phrase reminding you why you created this ODBC data source
    Oracle ODBC for Oed1 Database on dbserv.uits.indiana.edu
    Service name
    The Net8 service name you created for the database to which you want to connect
    oed1.world for an 8i database
    oed1 for an 8 database
    User name
    Usually left blank; you will be prompted for this later.
  6. Click OK. You will see the oed1_ora ODBC data sourceappear in your System DSN list. Click OK to finish your ODBCconfiguration.