Integrated System

Oracle Client 32-bit Installer Instructions

2/9/2017

This installer is intended for people who intend to access the Student Information System Reporting Database (CSRPT) or the Integrated System (iODS) from software on their PC. If you only plan to use Discoverer Plus, you do not need to run this installer.

This installer will install the 32-bit Oracle client and ODBC drivers on both a 32-bit machine and a 64-bit machine.

On a 32-bit machine, the files will be installed in the c:\Program Files\... folder with the only modification related to the TNS_ADMIN system variable (Step #5).

On a 64-bit machine, the files will be installed in the c:\Program Files (x86)\... folder. There are many modifications required for this installer to work on a 64-bit machine.

i.  The PATH system variable will need to be modified to reflect this difference (see screen shots below).

ii.  The ODBC Data Source Administrator run from the machine’s Control Panel will display the 64-bit drivers. The 32-bit drivers will not be visible using the Control Panel ODBC Data Source Administrator. To view, add or modify the 32-bit drivers, run the following program: C:\Windows\SysWOW64\odbcad32.exe .

iii.  The registry will need to be modified in the final step.

Do not use this installer if:

• you only use Discoverer Plus, or

• you already have Oracle applications that you use on your PC. This installer could cause those applications to stop working. Examples of such software are Oracle Discoverer Desktop.

We recommend that you shut down other applications before beginning installation to

prevent any conflicts with existing files. A re-boot is not required.

To install, select http://its.virginia.edu/integratedsystem/reports/sis/IS_Client_Setup_201210.exe

To manually download the current tnsnames.ora file save http://its.virginia.edu/integratedsystem/reports/sis/tnsnames.ora to your computer.

1.  If the location of the tnsnames.ora file is not known, use the computer’s search application to find all instances of the tnsnames.ora file. For each version of the file make a copy named tnsnames.ora.yyyymmdd, ex. Tnsnames.ora.20121101. Copy the new version to each of the folders that contain a tnsnames.ora file.

2.  The SIS client installers save the tnsnames.ora file in the c:\program files\integrated system\instant_client_11_2\Network\Admin folder. Go to this folder and rename the existing tnsnames.ora file to tnsnames.ora.yyyymmdd. Copy the new file to this location.

3.  If the location of the tnsnames.ora file is known, make a backup copy named tnsnames.ora.yyyymmdd. Place the new version into the same folder.

What you see should be similar to the following screenshots.

The file can be saved and run from any folder or location and there are no files to unzip.

Click Save File.

Once the file has been saved to your PC, go to the folder and double-click the file.

Click Run

Click Next

Wait while the installation proceeds . . .

Select Finish.

This program:

1. Installs the Oracle 11g Instant Client (Client Shared Library 32-bit - 11.2.0.1.0).

2. Installs Oracle ODBC driver release ODBC 11.2.0.1.0

3. Creates 3 ODBC connections…..

4. Copies an updated tnsnames.ora file with the SIS and Integrated System

connection strings to c:\program files\integrated

system\instant_client_11_2\Network\Admin folder.

5. Creates a TNS_ADMIN_IS System Environment Variable. If the user has a

current TNS_ADMIN variable set, the installer will not overwrite it. If you

encounter any of the following Oracle error messages, you can edit the

TNS_ADMIN_IS variable to be the TNS_ADMIN variable by going through

“Control Panel” and removing the “_IS” from the variable name.

a. ORA-12154 ``TNS:could not resolve service name"

b. ORA-12198 ``TNS:could not find path to destination"

c. ORA-12545 ``TNS:name lookup failure

6. Instructions related changing the PATH variable with screen shots for 32-bit drivers installed on a 64-bit machine.

a. Select ‘Control Panel’

b. Select ‘System’

c. Select ‘Advanced system settings’

d. Select ‘Environment Variables’

e. Under ‘System variables’, scroll down to the PATH variable. Highlight it and select ‘Edit…’

f. Move to the beginning of the string (the ‘Home’ key) and make the change:

Old


Edited

7. Registry Changes with screen shots for 32-bit drivers installed on a 64-bit machine.

a. Start REGEDIT.

b. Modify the keys listed below in the

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\.... folder and change C:\Program Files\... to C:\Program Files (x86)\...

The space in the path is important.

i.  \ODBC\ODBCINST.INI\Oracle in instantclient_11_2

Before:

After:

ii.  \ODBC\ODBC.INI\HrFin ODS Oracle 11g Client

Before:

After:

iii.  \ODBC\ODBC.INI\HrFin Prod Oracle 11g Client

Before:

After:

iv.  \ODBC\ODBC.INI\SIS Oracle 11g Client

Before:

After: