Oracle Data Access Components (ODAC) Installation Instructions
ODAC 11g 11.1.0.6.21
December 2007
Updated: April 2008

Downloads can include the following software:

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

Whats New in ODAC 11.1.0.6.21
======================================================
The following changes have been made to ODAC 11.1.0.6.21 installation since ODAC 11.1.0.6.20. No changes have been made to individual ODAC components, such as ODP.NET.

  • On a machine without Visual Studio .NET 2003 installed, ODAC products now work if they are installed in a new Oracle Home.
  • ODAC installation correctly reports errors if any of the following system requirements are not met:
    • Operating system and service pack requirements
    • Memory requirements
    • No space in the directory where the ODAC products are being installed
  • ODP.NET and Oracle Providers for ASP.NET assemblies now appear in the Visual Studio 2008 "Add Reference" dialog box.


Oracle Data Provider for .NET (ODP.NET) System Requirements
======================================================
The following items are required on a system to use this software:

  • Windows operating system
    • 32-bit: Windows Vista (Business, Enterprise, Ultimate editions), Windows XP Professional, Windows Server 2003, Windows Server 2003 R2, or Windows 2000,
    • Windows x64: Windows Vista (Business, Enterprise, Ultimate editions), Windows XP, Windows Server 2003, or Windows Server 2003 R2
  • Microsoft .NET Framework 1.0 or higher ( msdn.microsoft.com/netframework)
  • Access to an Oracle Database Server (Oracle9i Release 2 or later)
  • Oracle Services for Microsoft Transaction Server (11.1.0.6.0 or higher), which is included. Required only for applications using distributed transactions.
    Note: Oracle Services for MTS is not supported on Windows Vista at this time.

Oracle Developer Tools for Visual Studio System Requirements
======================================================
The following items are required on a system to use this software:

  • 32-bit Windows operating system
  • Windows Vista (Business, Enterprise, Ultimate editions), Windows XP Professional, Windows Server 2003, Windows Server 2003 R2, or Windows 2000
  • Access to an Oracle Database Server (Oracle9i Release 2 or later)
  • Microsoft Visual Visual Studio 2008, Microsoft Visual Studio 2005, or Microsoft Visual Studio .NET 2003.
    Note: The Express Editions of Visual Studio 2005 and 2008 are not supported with the Oracle Developer Tools.

Oracle Providers for ASP.NET System Requirements
======================================================
The following items are required on a system to use this software:

  • Windows operating system
  • 32-bit : Windows Vista (Business, Enterprise, Ultimate editions), Windows XP Professional, Windows Server 2003, Windows Server 2003 R2, or Windows 2000
  • Windows x64: Windows Vista (Business, Enterprise, Ultimate editions), Windows XP, Windows Server 2003, or Windows Server 2003 R2
  • Microsoft ASP.NET 2.0 or higher
  • Access to an Oracle Database Server (Oracle9i Release 2 or later)
  • Oracle Services for Microsoft Transaction Server (11.1.0.6.0 or higher), which is included. Required only for applications using distributed transactions.
    Note: Oracle Services for MTS is not supported on Windows Vista.

Oracle Database Extensions for .NET Requirements
======================================================
The following items are required on a system to use this software:

  • 32-bit Windows operating system
  • Windows Vista (Business, Enterprise, Ultimate editions), Windows XP Professional, Windows Server 2003, Windows Server 2003 R2, or Windows 2000

Other ODAC Component System Requirements
======================================================
The following items are required on a system to use the remaining software:

  • Windows operating system
  • 32-bit: Windows Vista (Business, Enterprise, Ultimate editions), Windows XP Professional, Windows Server 2003, Windows Server 2003 R2, or Windows 2000
  • Windows x64: Windows Vista (Business, Enterprise, Ultimate editions), Windows XP, Windows Server 2003, or Windows Server 2003 R2
  • Access to an Oracle Database Server (Oracle9i Release 2 or later)
  • Oracle Services for Microsoft Transaction Server (11.1.0.6.0 or higher), which is included. Required only for applications using distributed transactions.
    Note: Oracle Services for MTS is not supported on Windows Vista.

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.


Please noteDo not



Please note

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 using 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.

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) it 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 data source attribute, use the following format to define how the client can conenct 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

For example, some valid connection strings follow:
"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"
If the port number is not specified, 1521 is used by default.

The Oracle 2 Day Plus .NET Developer Guide provides more in-depth information on Easy Connect in Chapter 3.

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
database service name = the database's global name

The data source alias, hostname/IP, port, and database service name in the tnsnames.ora should be modified appropriately. If the TNS entries in the ORACLE_HOME\network\admin\tnsnames.ora file are not recognized by the Oracle client, create a ORACLE_HOME\oracle.key file using any text editor and type in the following line:

SOFTWARE\ORACLE\&lthome key>




Install and Setup Tips



ggODP.NET FAQ



Consult Chapter 2 of the ODP.NET Developers Guide for further information on ODP.NET versioning.

Viewing the Documentation
======================================================
Oracle Data Provider for .NET, Oracle Providers for ASP.NET, and Oracle Developer Tools for Visual Studio .NET documentation are installed as part of Visual Studio Dynamic Help.

Oracle Data Provider for .NET PDF documentation is installed in the ORACLE_HOME\odp.net\doc directory. The HTML documentation is installed in the ORACLE_HOME\odp.net\doc\html directory.

Oracle Providers for ASP.NET PDF documentation is installed in the ORACLE_HOME\asp.net\doc directory. The HTML documentation is installed in the ORACLE_HOME\asp.net\doc\html directory.

Documentation for all ODAC components can be found from the Windows Start Menu. Select All Programs --> Oracle - &ltOracle Home> Application Development and choose the product documentation in this folder.

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