Oracle Data Access Components (ODAC) for Windows Installation Instructions
32-bit Release 11.1.0.7.20

September 2009


Download includes the following products:

a) Oracle Developer Tools for Visual Studio (11.1.0.7.20)
b) Oracle Data Provider for .NET 2.0 (11.1.0.7.20)
c) Oracle Providers for ASP.NET (11.1.0.7.20)
d) Oracle Database Extensions for .NET 2.0 (11.1.0.7.20) -- upgrade only
e) Oracle Services for Microsoft Transaction Server (11.1.0.7.20)
f) Oracle Provider for OLE DB (11.1.0.7.20)
g) Oracle Objects for OLE (11.1.0.7.20)
h) Oracle ODBC Driver (11.1.0.7.0)
i) Oracle SQL*Plus (11.1.0.7.0)
j) Oracle Client (11.1.0.7.0)
k) Oracle Universal Installer (11.1.0.7.0)

System Requirements
======================================================
The following items are required on a system to use this software:

  • Windows operating system
    • 32-bit Windows: Windows Server 2008, Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2003, Windows Server 2003 R2, Windows XP Professional, Windows 2000
    • Windows x64: Windows Server 2008 (all x64 editions, except HPC), Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2003, Windows Server 2003 R2, Windows XP
  • Microsoft .NET Framework 2.0 or higher ( msdn.microsoft.com/netframework)
    Note: Oracle Data Provider for .NET (ODP.NET) for .NET 2.0 and Oracle Database Extensions for .NET 2.0 can not be used in .NET Framework 1.x.
  • Access to an Oracle Database Server (Oracle 9i Release 2 or later)
  • Oracle Client (11.1), which is included.
  • Oracle Services for Microsoft Transaction Server, which is included. Required only for applications using distributed transactions.
    Note: Microsoft introduced changes to the Distributed Transaction Coordinator (DTC) with Windows Vista and Windows Server 2008. Oracle Services for MTS 10.2.0.4 and higher, with the exception of 11.1.0.6, support this new DTC when the minimum operating system level is Windows Vista with Service Pack 1 or Windows Server 2008.
  • Oracle Developer Tools for Visual Studio requires either Visual Studio 2008 or Visual Studio 2005.
    Note: Visual Studio Express Editions are not supported with the Oracle Developer Tools. However, ODP.NET is supported with Visual Studio Express Edition.
  • Oracle Providers for ASP.NET require ASP.NET 2.0 or higher.
  • Oracle Database Extensions for .NET, a database option of Oracle Database 10.2 and higher, can only be upgraded with this ODAC release. You must already have Oracle Database Extensions for .NET 11.1.0.7.0 installed and configured on the Oracle database server in the same Oracle Home where Oracle Database Extensions for .NET 11.1.0.7.20 will be installed.

Installation Instructions
======================================================
The instructions below apply to installing ODAC using Oracle Universal Installer. For instructions on xcopy ODAC installation, refer to the README included with that particular installation.

1. Download ODTwithODAC1110720.zip into a temporary directory. Please note: Do not download this file into the "Tmp" directory.
2. Unzip its contents to the directory.
3. Run Oracle Universal Installer (OUI) by launching the setup.exe that was unzipped in the same directory.
4. OUI will lead you through ODAC installation on your machine. After the installation, you may delete the zip file and the unzipped folders and files.
Note: Oracle ODBC Driver and SQL*Plus are not listed separately as individually installable items in the OUI tree view control. If you wish to install these two products, choose Oracle Instant Client in the tree view control.

Connection Setup Quick Start
======================================================
There are a number of methods to connect Oracle client to a database server. Two of the most common include EZCONNECT and TNSNAMES. EZCONNECT is the easiest to setup. TNSNAMES is much more maintainable in the long term. If you are new to Oracle, we recommend you use EZCONNECT. You only have to choose one or the other to connect.

These quick start instructions assume you have a valid username and password for the database server.

Note: In the setup instructions below, ORACLE_HOME represents the directory where the Oracle client Home was installed on your machine. A typical directory for an OUI Oracle client Home is:
C:\app\Administrator\product\11.1.0\client_1
You will need to know where this directory is before proceeding.

EZCONNECT Setup
1. Copy the sqlnet.ora file located in the following directory:
ORACLE_HOME\Network\Admin\Sample\
to this directory:
ORACLE_HOME\Network\Admin\
This file tells the Oracle client by what methods (e.g. EZCONNECT) Oracle client can connect to the Oracle database server.
2. The Oracle client must then specify a valid user name, password, and data source to connect to the database server. To specify a data source, you can use the EZCONNECT format. In the ODP.NET data source attribute, use the following format to define how the client connects to the database server:
[//]host[:port][/service_name]

  • host = the database server machine's host name
  • port = the database server machine's port on which it listens for incoming connection requests
  • service_name = the database's global name

"user id=hr;password=hr;data source=//sales-server:1521/sales.us.acme.com"
"user id=hr;password=hr;data source=//sales-server/sales.us.acme.com"
"user id=hr;password=hr;data source=sales-server/sales.us.acme.com"

TNSNAMES Setup



ORACLE_HOME\Network\Admin\Sample\

ORACLE_HOME\Network\Admin\

&ltdata source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = &lthostname or IP>)(PORT = &ltport>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = &ltdatabase service name>)
)
)

  • data source alias = the shortcut name given to identify the connect descriptor. In the ODP.NET connection string, developers set the "Data Source" attribute to the data source alias.
  • hostname or IP = the database server machine's host name or IP address
  • port = the database server machine's port on which it listens for incoming connection requests. In general, this value is set to port "1521".
  • database service name = the database's global name

SOFTWARE\ORACLE\&lthome key>

Common Install and Setup Issues
======================================================
1. Consult the release notes first for any known issues or limitations.
2. Check if the Oracle data access components were properly downloaded by comparing the download size to the one listed on the download page.
3. If you have more than one Oracle Home installed on the same machine (e.g. Oracle 10g Release 2 client and Oracle 11g Release 1 client), by installing the Oracle 11.1.0.7 client, OUI will establish this client as the Oracle Home all your existing applications will use. For more information on using Multiple Oracle Homes, consult the
ODP.NET documentation.
4. It's highly recommended that ODP.NET be installed to a new Oracle Home. Installing ODP.NET on top of an existing Oracle home may break existing Oracle applications. This installation contains ODP.NET 11.1.0.7.20 and Oracle Client 11.1.0.7. If you do install on top of an existing Oracle Home, make sure to stop all the Windows services for that Oracle Home (e.g. OracleMTSRecoveryService).
5. This installation provides policy configuration files that can redirect existing 10.2 and 11.1 ODP.NET applications to the current ODP.NET version. The policy files are located in the ORACLE_HOME\odp.net\PublisherPolicy\2.x directory. In addition, the installation of ODP.NET will place ODP.NET policy DLLs into the GAC so that existing applications can start using the newly installed ODP.NET version immediately. However, if this is not desired, be sure to remove the policy DLLs from the GAC.
6. Installing ODP.NET into a new Oracle Home means that you will not have access to any of the Oracle Data Source aliases from your previous installation. To be able to use these existing data source attributes, copy the tnsnames.ora file in the ORACLE_HOME\network\admin directory from your previous Oracle Home installation to the same directory in your new installation. Or you may create the connection aliases manually by following the Connection Setup Quick Start earlier.
7. If errors indicating that "MSVCR80.dll is not found" are observed, install the Visual C++ 2005 runtime libraries.

Viewing the ODP.NET Documentation
======================================================
The PDF documentation is installed in the ORACLE_HOME\odp.net\doc directory. To view the PDF documentation, open the documentation from the Start Menu --> Oracle - <Oracle Home> --> Application Development. The HTML documentation is installed in the ORACLE_HOME\odp.net\doc\html directory.

Additionally, the ODP.NET API documentation is installed as part of Visual Studio .NET Dynamic Help.

Support and Bug Reports
======================================================
For any bugs and issues, you may participate in on of the OTN discussion forums for ODAC.