University of Oregon

Oracle 11gR2 Client Installation

Audience
Faculty/Staff
Researcher
Student
GTF

Oracle 11gR2 Client Installation - Data Warehouse (DWHS) and Resource 25 (R25)

You may need to login to Active Directory during this installation:
During this installation you may be prompted to login onto Active Directory in order to access certain installation files.  When you are prompted to login, enter your duckid username prefixed with 'ad\', then enter your Duckid password as you normally do, as shown here:

 

Step One: Download and Rename the Oracle 11gR2 Client Installer

Important Information
  • You will need to configure the Oracle Client after you have run the installer. See the instructions below on how to configure Oracle after you have installed it.

 

  • Map a network drive to \\public.uoregon.edu\windows\ccsetup as follows:
    • Run Windows Explorer from your start menu.
    • Chose tools > Map Network Drive:

    • Map any available drive to: \\public.uoregon.edu\windows\ccsetup 
    • When you are prompted to login, enter your duckid username prefixed with 'ad\', then enter your Duckid password as you normally do:

    • Your Network Drive mapping should now be complete.

 

  • Navigate to the following webpage, then download the Oracle Client Installation by right clicking on it and choosing Save Link As..., or Save Target As... and saving it to your desktop:

    UO Data Warehouse Tools
  • You may have to rename the saved file to Oracle 11gR2 32 bit Client.bat, as the file was likely renamed to Oracle 11gR2 32 bit Client.bat.txt during the download process for safety reasons.
  • To rename the file, single-click on it then press the [F2] key and rename it to Oracle 11gR2 32 bit Client.bat and press the [enter] key to complete the renaming.
     

Step Two: Run the Oracle 11gR2 Client Installer

  • After you have downloaded the program, run the shortcut by right-clicking on it and selecting run as administrator:

  • Please be patient as the Oracle installation program begins, it may take several minutes to even appear on your screen...

  • and completes...


Step Three: Copy the tnsnames.ora and sqlnet.ora files to your hard drive

  • In order to use the Oracle 11g Client it is critical that you download and save the UO provided tnsnames.ora and sqlnet.ora files to the Oracle Client now installed on your machine.
  • From the following link: UO Data Warehouse Tools  right click on both the Tnsnames.ora and Sqlnet.ora files in turn, then choose Save Link As..., or Save Target As..., and select the following location to save them to:

C:\ORACLE_UOIS\ORACLE_11g_R2_CLIENT\network\admin\

Windows 7 and Vista Users
Windows 7 and Vista may not allow you to save files directly to this directory. If this is the case, you will need to save the files to the temporary directory provided, and then copy and paste the files into the directory listed above using Administrator privileges.


Step Four: Setup ODBC
(Required for R25 Crystal Reports, or non-BiQuery DWHS access; Optional for others)

  • Follows these directions if you need to use ODBC to run R25/Crystal Reports, or connect an external application to the DWHS.  (This step is not required if you are only using BI Query to access the Data Warehouse.)
  • Run the appropriate Windows ODBC Data Source Administrator, (Windows 7 64 bit users see below.)  From the Control Panel Administrative tools menu run the ODBC Data Source Administrator as shown in the following screenshot:

Windows 7 64 bit users only
Windows 7 64 bit uses only the Oracle 32 bit ODBC driver we supply.  To configure it you will need to run the 32 bit ODBC manager, rather than the 64 bit ODBC manager.  To run the 32 bit ODBC manager you must start a cmd window by typing cmd into the windows start menu.  Then navigate to the c:\windows\syswow64 directory and run the odbcad32.exe from there, as shown in the following screenshot.  Once this program is running you can proceed as indicated in the standard instructions below.
 

  • In the System DSN tab click on the Add button:

  • Choose the Oracle in OraClient 11g_home1 selection:


DWHS Users

  • DWHS users should add and configure an Oracle ODBC Driver as shown below, (but use your own username.)  Click on the Test Connection button to test your configuration.

  • Once you have completed the DWHS ODBC configuration click OK.  You should see the following entry in your ODBC Data Source Administrator:

 

 

Resource 25 (R25) Users

  • Resource 25 users should add and configure an Oracle ODBC Driver exactly as shown below, with the following parameters (which you can copy and paste in:)
    • r25p
    • R25 Prod ODBC for Oracle 11g
    • R25P
    • UID
  •   Click on the Test Connection button to test your configuration.

  • Once you have completed the R25 ODBC configuration click OK.  You should see the following entry in your ODBC Data Source Administrator:

 

 

Resource 25 (R25) TEST Users

  • Resource 25 TEST users should add and configure an additional Oracle ODBC Driver exactly as shown below, with the following parameters, (which you can copy and paste in:)
    • r25t
    • R25 Test ODBC for Oracle 11g
    • R25T
    • UID
  •   Click on the Test Connection button to test your configuration.

  • Once you have completed the R25 Test ODBC configuration click OK.  You should see the following entry in your ODBC Data Source Administrator:

 

This should complete your Oracle 11g R2 Client setup.