|For a simpler solution|
Most users will be able to simply run the MIT Oracle 11gR2 Installer
To determine whether the manual Oracle 11g install is needed, see: Oracle 11g Troubleshooting
- BrioQuery users on 32-bit or 64-bit machines should choose the 32-bit Oracle 11gR2 client
- The 64-bit installer is available for users who do not need BrioQuery.
|Log in as administrator|
You will need to be logged in as an administrator to complete these instructions.
- Select the 32-bit or 64-bit Oracle client and download the installer. See: Choose Oracle client version
Result: If you are using Internet Explorer, you may see a download warning
- Right click on the warning bar and select Download file.
- When prompted to Open or Save, choose Save.
- IMPORTANT: Right-click on the .zip file and choose Extract All.
Result: Oracle_11.2_32_bit_client_installer folder is created.
- Open the folder.
- Navigate on your hard drive to the Oracle installer (64-bit client will be named as such)
- Double-click setup.exe.
Result: A User Account Control window prompts: "Do you want to allow the following program to make changes to your computer?"
- Select Yes.
- Result: A black command window opens.
- Result: The command window closes automatically, and the Oracle Client Installer opens, displaying Step 1 of 6.
- Choose Administrator and press Next.
Result: Step 2 of 7 is displayed, prompting to Select Product Languages.
- Accept the default choice for English, and click Next.
Result: Step 3 of 7 is displayed, prompting to Select Installation Location.
- Change Oracle base to C:\oracle and click Next.
Result: Step 4 of 7, Performing Prerequisite Checks is displayed, with a Progress bar.
Result: Performing Prequisite Checks screen closes and Step 5 of 7, Summary screen is displayed.
- Press Finish.
Result: Step 6 of 7, Install Product screen is displayed. A Progress bar indicates that the Oracle 11gR2 client is being installed.
Result: Step 7 of 7 screen is displayed, indicating "installation of Oracle client was successful".
- Click Close.
- Follow the instructions below to install the MIT Oracle Configuration files.
- Click to download the MIT Oracle configuration files.
- When prompted to Open or Save, press Save.
- Choose to Save the file to the Desktop.
Result: Download Complete box prompts to Open, Open Folder, or Close.
- Press Open Folder.
- Right-click on oracle config files.zip and choose Extract All.
Result: Extract Compressed (Zipped) folders window prompts to Select a Destination and Extract Files.
- Accept the default location, and press Extract.
Result: oracle config files folder is created on the Desktop.
The MIT Data Warehouse requires an encrypted connection between your computer and the Data Warehouse. This is configured by a series of parameters included in the sqlnet.ora file. For security reasons, the SQLNET.CRYPTO_SEED should be unique for each computer accessing the Data Warehouse. Follow the instructions detailed below to create a unique crypto seed for your sqlnet.ora file.
- Right-click on sqlnet.ora and choose Open with...
- If Open with... is not available, choose Open, then choose Select a program from a list of installed programs and press OK.
- Browse the list of applications and choose.
- Choose Notepad and click OK.
- Locate the entry:
SQLNET.CRYPTO_SEED = "replace the text between these quotes with exactly 64 characters, using a upper and lower case letters, numbers and special characters"
- Replace the text between the quotes with exactly 64 characters, using upper and lower case letters, numbers and special characters. Leave the quotation marks in place.
- Follow the menu path File >> Save.
- Close the file.
- Right-click on ldap.ora and choose Copy.
- If there is a chance that there is more than one Oracle installation on the machine, you'll need to look in the Path variable to ascertain which Oracle installation appears first in the Path. This is the Oracle installation which will need the MIT configuration files.
- To find the Path variable, go to Start > Control Panel > System > Advanced > Environment Variables
- Look for Path.
- Copy and paste the path into a text editor such as Notepad. Look for the first time that Oracle appears. The entry will be for the Oracle bin directory.
- Navigate, on your hard drive, to the Oracle installation. If there is more than one Oracle installation, be sure to choose the one that appeared first in the Windows Path variable (see Step 1).
- Within the Oracle directory structure, navigate to c:\oracle\product\11.2.0\client\network\admin.
- Copy ldap.ora and sqlnet.ora to this location.
- When prompted, choose Copy and Replace, to replace the generic Oracle sqlnet.ora file.