| Note | ||
|---|---|---|
| ||
This topic is for customer who are using Oracle unmanaged drivers. Generally, this topic will be relevant to customers who are using an Oracle database where the original version of ET installed was 4.7 or early.
New Installations of Enterprise Tester Enterprise Tester 4.8 and above supports managed ODP.Net drivers. No separate installation is required for managed ODP.Net drivers. We recommended using the managed drivers by all new Enterprise Tester customers who wish to connect to an Oracle database. For details on configuration settings required to be set in the web.config for the Oracle managed drivers please consult the "Database Configuration" topic. |
Introduction
...
Oracle Database Configuration when using Windows Server 2008 R2 - Unmanaged Oracle Driver
These instructions only apply when using the unmanaged Oracle driver, we strongly recommend for new customers to use the managed oracle driver, which does not require installation of additional software (ODAC) on their ET server.
Enterprise Tester no longer ships with Oracle drivers. To use Enterprise Tester with an Oracle database you must download and install the Oracle ODP.Net drivers from the Oracle website (part of ODAC). You can install either:
32bit: http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html or
64bit: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html.
We suggest using the XCopy deployment release. Once the XCopy release is downloaded, you can unzip the xcopy file into a folder, then run the following command: install.bat odp.net2 c:\oracle odac
Which will install the ODP.Net drivers into the GAC (Global Assembly Cache) see the readme.txt in the root of the ODAC xcopy zip file for further details. At this point you will be able to configure Enterprise Tester to connect to an Oracle database.
Because Oracle Drivers are specific to 32bit and 64bit operating systems - you need to ensure that Enterprise Tester's application pool is configured with an identical setting.
To confirm this:
- Go to Control Panel -> Administrative Tools -> Internet Information Services (IIS) Manager.
- On the left hand side select Application Pools.
- Click on the Application Pool being used by Enterprise Tester (this will normally be "DefaultAppPool" or "EnterpriseTester").
- Select on the right-hand side "Actions" panel "Advanced Settings...".
If you have installed the 32bit Oracle drivers, you must have "Enable 32-Bit Applications" set to True on the advanced settings screen of the application pool. If you have installed the 64bit Oracle drivers, you must have "Enabled 32-Bit Applications" set to False on the advanced settings screen of the application pool.
Preparation
Enterprise Tester is a .Net Framework application and makes use of ODP.Net to connect to Oracle databases.
...
ODP.Net comes as part of ODAC (Oracle Data Access Components) - which can be downloaded from the Oracle website. In most organisations it's normally advised that you have your Oracle DBA install these drivers and configure the settings for Enterprise Tester to connect to Oracle, as they will be better equipped to troubleshoot connectivity issues.
...
Prior to installation you need to determine if you are going to use the 64bit or 32bit version of ODAC - here is how you can determine which you should use.
...