At IU, how do I install the Oracle 10g client release 2 for Windows Vista?

Username:
Password:

Note: This document explains how to install the Oracle 10g client release 2 for Windows Vista. For other Windows platforms, see At IU, how do I install the Oracle 10g client release 2?

For instructions on how to install and configure the Oracle 10g client release 2 for Windows Vista, see the appropriate section below.

On this page:

Running the Oracle client setup by downloading directly from Oracle's web site

Note: This method requires a valid OTN (Oracle Technology Network) username and password. If you do not have a valid OTN username and password:

Visit the Oracle Technology Network web page.
Click Register for a free Oracle Web account in the upper right.
Follow the on-screen instructions.

If you do have a valid OTN username and password:

Visit the Oracle web page.
Before continuing, you must read and accept the OTN License Agreement.
Read the OTN License Agreement by clicking OTN License Agreement. When finished, close the OTN License Agreement window.
Select Accept License Agreement. You will see a notification thanking you for accepting the OTN License Agreement and permitting you to download the software.
Click Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4) for Microsoft Windows Vista and Windows 2008. Click to accept the License Agreement, and then scroll down to Oracle Database 10g Release 2. Click 10203_vista_w2k8_x86_production_client.zip to download.
Note: You will need 604MB of free space on your hard drive before downloading this file.

Before continuing, you might be prompted to enter a valid OTN username and password. Once you have done so, you will see the File Download dialog box.
Save the file 10203_vista_w2k8_x86_production_client.zip to a location you will remember on your local hard drive.
Navigate to the file 10203_vista_w2k8_x86_production_client.zip on your hard drive, right-click the file, and then scroll to and click Extract all.
Select or create a folder location (e.g., C:\Oracle 10g Client R2) for the extracted files.
Once all zipped files have been extracted, navigate to the folder you created.
Navigate to the \client\Disk1 directory and double-click the file setup.exe to launch the Oracle Universal Installer. You will be prompted for a Windows administrator username and password before proceeding.
If you do not see the installer, minimize application windows to see the installer window. It might take a minute for the installer window to appear.

Running the Oracle client setup from IUware Online

Visit: http://iuware.iu.edu/
On the left, choose Database.
From the list of choices, select Oracle 10g R2 Client for Windows Vista.
Next to "Available for Download", click Login. If prompted, enter your IU Network ID, and then click Download to save the file to your computer.
Once the download is complete, double-click the Oracle10gR2ClientVista.exe file saved to your computer. When the installer finishes loading, click Next.
By default, the installer will install the necessary files to C:\IUware Online\Oracle 10g R2 Client Vista. If you would like to change to a different folder, click Browse... . To continue, click Install.
The installation program will extract the necessary files to the directory you specified. When it is complete, the installation automatically begins as the Oracle Universal Installer runs. (If not, go to C:\IUware Online\Oracle 10g R2 Client Vista\client and double-click setup.exe.) This will take a few minutes.
Continue with the next section when you are ready to install the Oracle client.

Note: You may need to move the installer window to see the configuration window.

Client installation process

Note: To continue, you will need the following pieces of information:

Information needed	Example
Name or System Identifier (SID) of the database	SID = oed1
Full service name of the database	Service name = `oed1.world`
Port number	Default port = 1521
Name of host computer where database is located	`dbserv.uits.indiana.edu`

If you use the IU Data Warehouse, for configuration information, see Oracle client configuration information for the IU Data Warehouse.

After you have verified the information above with the database administrator:

In the Oracle Universal Installer dialog box, click Next.
The installer will load product information and present you with the Installation Types dialog box. Unless you know you want another type of installation, select Custom, and then click Next.
The installer will provide default file locations for you, but you can enter an alternate path in the available box or click Browse... to navigate to an alternate location. When you are ready to continue, click Next.
In the Available Product Components dialog box, check Show all components, including required dependencies.
In the Available Product Components dialog box, use the checkboxes to select, in the following order, the components listed:
- Oracle Net 10.2.0.3.0
- SQL *Plus 10.2.0.3.0
- Oracle JDBC/THIN Interfaces 10.2.0.1.0
- Oracle Call Interface (OCI) 10.2.0.3.0
- Oracle Windows Interfaces 10.2.0.1.0
- Enterprise Manager 10g Java Console 10.2.0.3.0
In the Available Product Components dialog box, uncheck Oracle Services For Microsoft Transaction Server 10.2.0.3.0, and then click Next.
In the Product-Specific Prerequisite Checks dialog box, the installer verifies that your environment meets all of the minimum requirements for installing and configuring the products you have chosen to install. You must manually verify and confirm the items that are flagged with warnings and items that require manual checks.
Once you verify that all checks have passed, click Next.
Verify the installation information in the Summary dialog box, and then click Install.
To finish the installation, you must configure Oracle Net. If you want to do this now, proceed to the next section. If you want to configure the Oracle Net client at a later time, follow the instructions in Adding new database services.

Configuring Oracle Net

If you cannot see the Oracle Net Configuration Assistant: Welcome dialog box, move the Configuration Assistants dialog box.
In the Oracle Net Configuration Assistant: Welcome dialog box, make sure that Perform typical configuration is not selected, and then click Next.
In the Oracle Net Configuration Assistant dialog box, make sure "Local Naming" is displayed in the "Selected Naming Methods" box, and then click Next.
Enter the Service Name, which is the database SID followed by an extension (e.g., oed1.world), and then click Next. If you do not know the Service Name, check with the database administrator.
Select TCP, and then click Next.
Enter your hostname; for oed1, the hostname is dbserv.uits.indiana.edu . Unless otherwise specified, leave 1521 as the port number, and then click Next.
Click the radio button next to Yes, perform test, and then click Next.
Note: If the login test fails, select Change Login, enter your correct user information, and try again. Choose Next when the test is successful.
UITS recommends using the same name that you supplied in Step 4 (e.g., oed1.world) as the name for the new net service. Enter the name, and then click Next.
Note: Leaving just a name without a domain (e.g., oed1 rather than oed1.world) can cause connection problems.
If you would like to configure another net service name, select Yes, and then follow steps 4 through 8 above. Otherwise, select No, and then click Next.
Once you have configured all of your net service names, click Next twice, and then click Finish.
In the End of Installation dialog box, click Exit. When asked if you really want to exit, click Yes.

After following the steps above, you are finished setting up the Oracle client. You may want to continue to one of the following sections:

Adding new database services

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

From the Start menu, select All Programs, then Oracle - OraClient10g_home, and then Configuration and Migration Tools. Then, click Net Configuration Assistant.
Click the radio button next to Local Net Service Name Configuration, and then click Next.
Click the radio button next to Add, and then click Next.
Enter the Service Name, which is the database SID followed by an extension (e.g., oed1.world), and then click Next. If you do not know the Service Name, check with the database administrator.
Select TCP, and then click Next.
Enter your hostname; for oed1 , the hostname is dbserv.uits.indiana.edu . Unless otherwise specified, leave 1521 as the port number, and then click Next.
Click the radio button next to Yes, perform test, and then click Next.
Note: If the login test fails, select Change Login, enter your correct user information, and try again. Choose Next when the test is successful.
UITS recommends using the same name that you supplied in Step 4 (e.g., oed1.world) as the name for the new net service. Enter the name, and then click Next.
Note: Leaving just a name without a domain (e.g., oed1 rather than oed1.world) can cause connection problems.
If you would like to configure another net service name, select Yes, and then follow steps 4 through 8 above. Otherwise, select No, and then click Next.
Once you have configured all of your net service names, click Next twice, and then click Finish.

Connecting to Oracle with SQL*Plus

To connect to Oracle with SQL*Plus:

From the Start menu, select All Programs, then Oracle - OraClient10g_home, and then Application Development. Then, click SQL Plus.
Enter your Oracle username and password in the spaces provided.
In the box labeled "Host String:", enter the name you specified when configuring Oracle Net (e.g., oed1.world), and then click OK.

After completing the steps above, you will 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?

Obtaining and applying Oracle Patch 5699495

Visit: http://iuware.iu.edu/
On the left, choose Database.
From the list of choices, select Oracle 10g R2 Client for Windows Vista (Patch 5699495).
Next to "Available for Download", click Login. If prompted, enter your IU Network ID, and then click Download to save the file to your computer.
Once the download is complete, double-click the ORA10203.exe file saved to your computer. When the installer finishes loading, click Next.
By default, the installer will install the necessary files to C:\ORA10203. If you would like to change to a different folder, click Browse... . To continue, click Install.
The installation program will extract the necessary files to the directory you specified for subsequent copying.

The directory structure and the location to which you should copy the files are shown below. Replace <ORACLE_HOME> with the directory of your 10.2 Oracle Home (e.g., c:\Oracle10.2.0):

File:	Copy to:
`ORA10203\bin\sqora32.dll`	`<ORACLE_HOME>\bin`
`ORA10203\bin\sqoras32.dll`	`<ORACLE_HOME>\bin`
`ORA10203\bin\sqresus.dll`	`<ORACLE_HOME>\bin`
`ORA10203\ODBC\html\ODBCRelnotesUS.htm`	`<ORACLE_HOME>\ODBC\html\`
`ORA10203\ODBC\readme.txt`	`<ORACLE_HOME>\ODBC\html\`
`ORA10203\ODBC\mesg\oraodbus.msb`	`<ORACLE_HOME>\ODBC\mesg\`

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 are connecting. 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 Oracle Net service you set up when configuring the Oracle client. Prior to configuring and locating an ODBC data source for this version of the Oracle client, you need to download and install patch 5699495 from IUware. Once you have done this:

From the Start menu, click All Programs, then Oracle - OraClient10g - home, then Configuration and Migration Tools, and then Microsoft ODBC Administrator.
Provide a Windows administrator username and password.
At the top of the ODBC Data Source Administrator window, select the tab labeled System DSN, and then click Add... .
From the list, select Oracle in OraClient10g_home1, and then click Finish.

Enter your information in the window that appears, and then click OK.

The following example 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`
TNS Service name	The Oracle Net Service Name you created for the database to which you want to connect	`oed1.world`
User name	This is usually left blank; you will be prompted for this later when you make an ODBC connection to the database.

The ODBC data source you added will now appear in your System DSN list. Click OK to finish your ODBC configuration.

Oracle client configuration information for the IU Data Warehouse

Note: The following information is only for IU Data Warehouse users.

You can use the following configuration information when configuring Oracle Net to connect to the IU Data Warehouse:

For Development (dss1dev)

Database service name: dss1dev.ucs.indiana.edu
Host computer: iedssdev.uits.indiana.edu
Port number: 1521 (default)
Net service name: dss1dev.ucs.indiana.edu (This is also the service name when you create an ODBC data source.)

For Test (dss1tst)

Database service name: dss1tst.ucs.indiana.edu
Host computer: iedsstst.uits.indiana.edu
Port number: 1521 (default)
Net service name: dss1tst.ucs.indiana.edu (This is also the service name when you create an ODBC data source.)

For Production (dss1prd)

Database service name: dss1prd.ucs.indiana.edu
Host computer: iedss.uits.indiana.edu
Port number: 1521 (default)
Net service name: dss1prd.ucs.indiana.edu (This is also the service name when you create an ODBC data source.)

This is document axju in domain all.
Last modified on June 19, 2009.