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.
- Preinstallation instructions
- Running Oracle Client Setup from CD
- Running Oracle Client Setup from IUware Online
- Client installation process
- Configuring Net8 for Windows 95, 98, NT, and 2000
- Adding new database services
- Connecting to Oracle with SQL*Plus
- Configuring and locating and ODBC data source
Preinstallation instructions
- From the menu, select , and then .
- 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 . - 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.
- Right-click , and in the column, choose .
- 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 tomfc42u.dllorig
, and pressEnter
. - 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.
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.
- Insert the Oracle Client CD and wait for the
Oracle8i Client - Autorun
window to open. If it doesn't auto-start, double-click , double-click the CD-ROM icon, and then double-click . - You can now skip to the section Client installation process.
Running Oracle Client Setup from IUware Online
Note: This method of installation is an alternative to using an Oracle Client Setup CD.
- Visit IUware at:
http://iuware.iu.edu/
- From the menu to the left, click .
- From the list of choices, click .
- Click Network ID when prompted, and then click to save the file to your computer. . Enter your
- After the download is complete, start the installation wizard by
double-clicking the
C:\IUware Online\Oracle8.1.7 Client
for the directory or click to set the location, and then click .Note: When installation is complete, you can delete the
C:\IUware Online\Oracle8.1.7 Client
folder and its contents. file that was saved to your
computer. A window will open showing where the files will be unpacked.
Type - The wizard will spend several minutes installing files to the
directory you specified. When it is complete, check the box next to
setup.exe
program directly from the folder in which you installed the installation files. , and then click
. If you would prefer not to start the Oracle Client
installation now, uncheck this box and click , and when
you are ready to install the Oracle Client, open the
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
oroed1.ucs.indiana.edu
) - The version of the database to connect to (
8
or8i
) - 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.
- When installation has begun, a window will appear with three
choices:
- Install/Deinstall Products
- Explore CD
- Browse Documentation
- Choose .
- When the Oracle Universal Installer appears, choose .
- The default file locations are shown. Click if the default file locations are acceptable (recommended). Otherwise, enter a new path for the destination of your files and click . Oracle will load the product information.
- 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
unless your needs differ, and then select . - 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 .
- 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.
- 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.
Configuring Net8 for Windows 95, 98, NT, and 2000
- From the Net8 Configuration Assistant "Welcome" window, choose .
- The first window has two radio buttons. Selecting will create a directory service, whereas selecting will allow you to create net service names manually. Choose (unless instructed otherwise), and then click .
- In the "Naming Methods" window, accept the default value (Local), and then click .
- 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 .
- 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 .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 .
- If you chose 8i as the database version, type the name of the
database followed by an extension (usually
- By default, should already be selected. If not, choose , and then click .
- Enter the hostname (e.g.,
dbserv.uits.indiana.edu
), and then click . Unless specified otherwise, leave the default port number as 1521. - Choose
Note: If the login test fails, click the
button. Type your correct user information and try again. When the test is successful, click . to make sure the configuration
is successful, and then click .
- You will be prompted to choose or to configure another net service name. If you choose , follow the instructions in this section again. If you choose , the installation is complete, and you can proceed to the next step.
- Click , then again, then , and then . Click 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.
Adding new database services
To set up an Oracle Client connection to an Oracle database on another computer:
- Navigate to .
- Choose , and click .
- Click , and then click .
- 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 .
- 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 . - If you chose 8 as the database version, type the name of the
database SID (e.g.,
oed1
), and then click .
- If you chose 8i as the database version, type the name of the
database followed by an extension, (usually
- By default, should already be selected. If not, choose , and then click .
- Enter the hostname (e.g.,
dbserv.uits.indiana.edu
). Unless specified otherwise, leave the default port number as 1521. Click . - Choose
Note: If the login test fails, click
. Enter your correct user information, and click when the test is successful. to make sure the configuration
is successful. Click .
- Enter the net service name (use the same name you chose in step
5, e.g.,
oed1.world
). Click . - To configure another net service name, choose , and repeat the instructions in this section. To exit, choose , then click twice, and then .
Connecting to Oracle with SQL*Plus
To connect to Oracle with SQL*Plus:
- From the menu, select , then , then , and then .
- 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, andoed1.world
if you chose an Oracle 8i database. Click . - You should now be in the SQL*Plus command line interface environment. 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 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:
- From the menu, select , and then .
- Double-click (on some systems, this icon may be named or ). In Windows 2000, this is in a separate folder. If you are using Windows 2000, double-click the folder. Within the folder, click .
- At the top of "ODBC Data Source Administrator" window, click the tab labeled . Click .
- In the list, select , and then click .
- 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 sourceoed1_ora
Description Not required; just a phrase reminding you why you created this ODBC data sourceOracle ODBC for Oed1 Database ondbserv.uits.indiana.edu
Service name The Net8 service name you created for the database to which you want to connectoed1.world
for an 8i database
oed1
for an 8 databaseUser name Usually left blank; you will be prompted for this later. - Click . You will see the oed1_ora ODBC data source appear in your System DSN list. Click to finish your ODBC configuration.
This is document anjm in the Knowledge Base.
Last modified on 2021-09-20 15:14:24.