print Printer View e-mail E-mail this page Bookmark Bookmark

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
  • Microsoft .NET Framework 1.0 or higher (msdn.microsoft.com/netframework)
  • Oracle Database Server (Oracle Database 11g)

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.

1. Download ODTwithODAC1110620.zip or ODAC1110620.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.
Please 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, you must choose to install 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 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
An Oracle Net service name allows the Oracle client to use a simple alias to connect to the database server. The alias definition contains all the information needed to create a connection to the database server. Alias information is stored in the tnsnames.ora file typically located in the ORACLE_HOME\Network\Admin directory. This alias is used as the data source value in your connection string. ODAC installations do not create a tnsnames.ora file so you need to create one. Alternatively, you can copy an existing tnsnames.ora file from an existing Oracle client installation to your new ODAC installation. The following instructions assume you will have to create a new tnsnames.ora file.

1. Copy the tnsnames.ora file located in the following directory:
ORACLE_HOME\Network\Admin\Sample\
to this directory:
ORACLE_HOME\Network\Admin\
2. Open this file in a text editor and modify the existing entry for your database server connection information.

<data source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname or IP>)(PORT = <port>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database 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\<home key>

where <home key> is the registry key for the Oracle 11g ODAC 11.1.0.6.20 Oracle Home. For example, if the default Oracle Home location was used during the install, the proper entry for the oracle.key file would be the following: SOFTWARE\ORACLE\KEY_OraODAC11g_home1


Install and Setup Tips
======================================================
1. Consult the release notes first for any known issues or limitations.
2. Check to see 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 client), by installing the Oracle 11.1 client last, OUI will establish this client as the Oracle Home that all your existing applications will use. For more information on using Multiple Oracle Homes on Windows and changing homes, consult the ODP.NET FAQ.
4. It's highly recommended that ODP.NET be installed in a new Oracle Home. Installing ODP.NET on top of an existing Oracle home may break existing Oracle applications. 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. Installing ODAC or any one of its components into a non-Oracle 11g home is not supported. By default, the Oracle installer will create a new Oracle home.
6. This installation copies policy configuration files that can redirect existing 9.2, 10.1, 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\1.x or 2.x directories. These policy files will not be placed in the Global Assembly Cache (GAC) by the Oracle installer. Application developers can decide whether to GAC them or not.

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 - <Oracle 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.
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy