Indiana University
University Information Technology Services
  
What are archived documents?
Login>>
Login

Login is for authorized groups (e.g., UITS, OVPIT, and TCC) that need access to specialized Knowledge Base documents. Otherwise, simply use the Knowledge Base without logging in.

Close

ARCHIVED: How do I install and configure the Oracle 8.1.7 client in Windows 95, 98, NT, and 2000?

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

Oracle 8.1.7 Client is supported in Windows 95, 98, NT, and 2000. If you require Oracle Client 8.1.7 for Windows XP, you should use this web form to contact UITS Enterprise Decision Support Services for compatibility information.

On this page:

Preinstallation instructions

  1. From the Start menu, select Find, and then Files or Folders.

  2. In the "Named" field, type mfc42u.dll . Using the "Look In" drop-down box, search all drivers that have or have had Oracle programs installed. Click Find Now.

  3. If Windows doesn't find a file with this name, skip the remaining steps, close the "Find" window, and proceed to either Running Oracle Client Setup from CD or Running Oracle Client Setup from IUware Online. If Windows finds the file, follow the remaining steps.

  4. Right-click mfc42u.dll, and in the Name column, choose rename.

  5. Move the cursor to the end of the filename and type a few letters to change it. For example, type orig at the end of the filename, changing it to mfc42u.dllorig, and press Enter.

  6. After successful completion of these tasks, you are now ready to install the Oracle Client. Close the Find window. If you have a Client CD, proceed to the next section, Running Oracle Client Setup from CD. Otherwise, proceed to Running Oracle Client Setup from IUware Online.

Back to top

Running Oracle Client Setup from CD

To install Oracle Client from CD:

Note: If you are using Windows NT or 2000, log in as 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, and then double-click setup.exe.

  2. You can now skip to the section Client installation process.

Back to top

Running Oracle Client Setup from IUware Online

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

  1. Visit IUware at: http://iuware.iu.edu/
  2. From the Software menu to the left, click Database.

  3. From the list of choices, click Oracle8i (8.1.7) Client Software and Documentation.

  4. Click Download. Enter your Network ID when prompted, and then click Save to save the file to your computer.

  5. After the download is complete, start the installation wizard by double-clicking the setup.exe file that was saved to your computer. A window will open showing where the files will be unpacked. Type C:\IUware Online\Oracle8.1.7 Client for the directory or click Browse to set the location, and then click Next.

    Note: When installation is complete, you can delete the C:\IUware Online\Oracle8.1.7 Client folder and its contents.

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

Back to top

Client installation process

Before continuing, you must have the following four pieces of information:

  • The name or SID of the database (e.g., oed1) and the full service name of the database that includes an SID followed by an extension (e.g., oed1.world or oed1.ucs.indiana.edu)

  • The version of the database to connect to (8 or 8i)

  • The name or IP address of the computer hosting the Oracle database

  • The port number (default is 1521)

Note: Confirm this information with the database administrator before proceeding.

  1. When installation has begun, a window will appear with three choices:

    • Install/Deinstall Products
    • Explore CD
    • Browse Documentation

  2. Choose Install/Deinstall Products.

  3. When the Oracle Universal Installer appears, choose Next.

  4. The default file locations are shown. Click Next if the default file locations are acceptable (recommended). Otherwise, enter a new path for the destination of your files and click Next. Oracle will load the product information.

  5. A window titled "Installation Types" will open. The selections are:

    • Administrator (356 MB): Includes management tools in addition to Net8, SQL*Plus, and the ODBC drivers.
    • Programmer (233 MB): Recommended for most setups. Includes Net8, SQL*Plus, and ODBC drivers.
    • Application User (157 MB): Does not include SQL*Plus. Installs very basic network software.
    • Custom: Installs whatever items are wanted. Space usage is variable.

    Choose Programmer unless your needs differ, and then select Next.

  6. Product information will load, and then the summary information will be displayed. (If there is a previous version of Oracle on your computer, it will be removed before installing.) Check the summary information and choose Install.

  7. Oracle will begin the installation. This will take some time.

    Note: If you receive an error "mfc42u.dll", you may need to work through the Preinstallation instructions at the beginning of this document.

  8. Once the software installation has completed, to configure the Oracle 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 of the installation, see ARCHIVED: How do I configure Net8 manually?

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

Back to top

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

  1. From the Net8 Configuration Assistant "Welcome" window, choose Next.

  2. The first window has two radio buttons. Selecting Yes will create a directory service, whereas selecting No will allow 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 to access. Choose the same database version as the one you are connecting to (i.e., 8 or 8i). Click Next.

  5. In the next window, you will be asked to enter either the service name (for 8i) or SID (for 8).

    • If you chose 8i as the database version, type the name of the database followed by an extension (usually .world, e.g., oed1.world). Click Next.

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

    • If you chose 8 as the database version, type the name of the database 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 the default port number as 1521.

  8. Choose Yes, perform test to make sure the configuration is successful, and then click Next.

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

  9. You will be prompted to choose Yes or No to configure another net service name. If you choose Yes, follow the instructions in this section again. If you choose No, the installation is complete, and you can proceed to the next step.

  10. Click Next, then Next again, then Finish, and then Exit. Click Yes when prompted to confirm exiting the program.

You are done configuring the Oracle Client. At this point, you may want to go the section Connecting to Oracle with SQL*Plus. Or, if you want to set up ODBC data sources for connecting to Oracle from applications such as Access or ER/Studio, go to the section Configuring and locating an ODBC data source.

Back to top

Adding new database services

To set up an Oracle Client connection to an Oracle database on another computer:

  1. Navigate to Start Oracle Network Administration Net8 Configuration Assistant.

  2. Choose Local Net Service Name Configuration, and click Next.

  3. Click Add, and then click Next.

  4. The next window will prompt you for the version of Oracle database or service to access. Choose the same version of database as the version of the database being connected to (either 8 or 8i). Click Next.

  5. In the next window, you will be asked to enter either the service name (if you chose an Oracle 8i database) or the SID (if you chose an Oracle 8 database).

    • If you chose 8i as the database version, type the name of the database followed by an extension, (usually .world, e.g., oed1.world). Click Next.
    • If you chose 8 as the database version, type the name of the database 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 configuration is successful. Click Next.

    Note: If the login test fails, click Change Login. Enter your correct user information, and click Next when the test is successful.

  9. Enter the net service name (use the same name you chose in step 5, e.g., oed1.world). Click Next.

  10. To configure another net service name, choose Yes, and repeat the instructions in this section. To exit, choose No, then click Next twice, and then Exit.

Back to top

Connecting to Oracle with SQL*Plus

To connect to Oracle with SQL*Plus:

  1. From the Start menu, select Programs, then Oracle, then Application Development, and then SQL Plus.

  2. In the spaces provided, enter your Oracle username and password. For "Host String", for example, if you are connecting to the Oed1 database, type oed if you chose an Oracle 8 database, and oed1.world if you chose an Oracle 8i database. Click OK.

  3. You should now be in the SQL*Plus command line interface environment. If you would like to change your password, see How do I change my Oracle password using SQL*Plus?

Back to top

Configuring and locating an ODBC data source

Programs that use ODBC to connect to remote databases must have a way to identify the type of database and the computer to which they wish to connect. This is accomplished through an ODBC data source, which associates a name with some database connection information. In the case of Oracle, the database connection information is simply the name of the Net8 Service you set up during the Oracle Client Configuration.

To configure and locate an ODBC data source:

  1. From the Start menu, select Settings, and then Control Panel.

  2. Double-click ODBC Data Sources (on some systems, this icon may be named ODBC or ODBC Data Sources (32-bit)). In Windows 2000, this is in a separate folder. If you are using Windows 2000, double-click the Administrative Tools folder. Within the Administrative Tools folder, click ODBC Data Sources.

  3. At the top of "ODBC Data Source Administrator" window, click the tab labeled System DSN. Click Add.

  4. In the list, select Oracle ODBC Driver, and then click Finish.

  5. Enter the following information in the Oracle ODBC for Oracle Setup window:

    Note: The examples listed will create an Oracle ODBC data source for the Oed1 database on dbserv.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 source appear in your System DSN list. Click OK to finish your ODBC configuration.

Back to top

This is document anjm in domain all.
Last modified on March 16, 2009.

Comments/Questions/Corrections

Use this form to offer suggestions, corrections, and additions to the Knowledge Base. We welcome your input!

If you are affiliated with Indiana University and would like assistance with a specific computing problem, please use the Ask a Consultant form, or contact your campus Support Center.

Contact Information

Note: We will reply to your comment at this address. If your message concerns a problem receiving email, please enter an alternate email address.