Download includes the following products:
The following items are required for ODAC:
Additional Notes on Requirements:
Note: Visual Studio Express Editions are not supported with the Oracle Developer Tools. However, ODP.NET is supported with Visual Studio Express Edition.
The instructions below apply to installing ODAC using Oracle Universal Installer. Xcopy installation instructions are included with the download itself.
Note: If another ODAC beta is installed, uninstall it before installing this ODAC release.
The instructions below apply to deinstalling ODAC using Oracle Universal Installer. Xcopy deinstallation instructions are included with the download itself.
Automatic Setup -- New in ODAC 12c
When installing ODAC in a new Oracle Home, OUI automatically copies the Oracle local naming (tnsnames.ora), profile (sqlnet.ora), and directory (ldap.ora) parameter files and settings from an existing Oracle Home into the newly installed ODAC home.
Alternatively, existing *.ora files can be copied over from another existing Oracle Home, besides the last active one, to the new ODAC Oracle Home. OUI provides location information for these files from up to three other existing Oracle Homes if they exist. The *.ora files can be customized if the new Oracle Home uses a different configuration from the previous Oracle Home from which the files were copied over.
If installing into an existing ODAC or RDBMS Oracle Home, no new *.ora files will be copied or created.
If installing onto a machine without any previous Oracle Homes present, OUI will ask the user for the database connection alias information. OUI will then automatically create the tnsnames.ora file. If no alias information is provided, no tnsnames.ora file will be created. Even if the user doesn't have all the database connection information readily available, Oracle recommends inserting placeholder values during the install process, then modifying the tnsnames.ora file later with actual values to replace the placeholders later.
Install Changes to Machine.config for ODP.NET, Managed Driver
If installing ODP.NET, Managed Driver, OUI automatically copies TNS_ADMIN and LDAP_ADMIN entries into the .NET maching.config file if present in pre-existing Oracle Homes and machine-wide configuration is selected .
Two of the most common methods for connecting an Oracle client to a database are 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:
You will need to know where this directory is before proceeding.
to this directory:
This file tells the Oracle client by what methods (e.g. EZCONNECT) Oracle client can connect to the Oracle database server.
For example, some syntactically 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.
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. The following instructions assume you will have to create a new tnsnames.ora file.
to this directory:
<data source alias>= (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=<hostname or IP>)(PORT=<port>)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME=<database service 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:
<home key> is the registry key for the ODAC 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:
ODAC now offers machine-wide and non-machine-wide configuration for managed and unmanaged ODP.NET. The machine-wide configuration includes placing the provider assembly into the GAC and updating the machine.config with configuration section handler and DbProviderFactory information. If non-machine-wide configuration is selected, none of these changes are made. By default, ODAC install uses machine-wide configuration for a new Oracle Home install and re-installs. ODAC install defaults to the same configuration setting chosen for that Oracle Home from the previous installation.
If you plan to install ODAC 12c Release 3 and the NuGet install for ODP.NET 220.127.116.11 on the same machine, ODP.NET should be configured non-machine-wide.
Users can reconfigure ODP.NET from machine-wide configuration to non-machine-wide configuration by re-installing ODP.NET to the same Oracle Home where ODP.NET of the same version is already installed. For example, if you have already configured ODP.NET machine-wide, you can re-configure it by re- installing ODP.NET onto the same Oracle Home AND selecting the non-machine-wide configuration option.
For applications that depend on a version of ODP.NET that was not configured machine-wide, it's important to note that A) ODP.NET asssembly/assemblies that the application depends on will need to be copied over to the application directory and B) proper app.config settings will be required to use Provider Factory and/or Provider-specific configuration. See Chapter 2 of the ODP.NET Developer's Guide for more details.
Check whether oci.dll in the existing ORACLE_HOME directory has been removed during the uninstall process. If oci.dll was not removed, follow these steps to remove the DLL.
a) Rename oci.dll to oci.dll.delete.
b) Reboot your machine.
c) Delete oci.dll.delete, which should no longer be in use after rebooting.
d) Install the new ODAC.
ORACLE_HOME\odp.net\PublisherPolicy\4directories. The installation of ODP.NET will NOT place ODP.NET policy DLLs into the GAC, which means existing applications will continue to use the same ODP.NET version they were using before.
ORACLE_HOME\network\admindirectory 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.
The PDF and HTML documentation can be viewed from the
ORACLE_HOME\ODACDoc\DocumentationLibrary\welcome.html page. To view this page, go to
Start Menu --> Oracle - <Oracle Home> --> Application Development --> Oracle Data Access Components Documentation.
Additionally, the Oracle documentation is installed as part of Visual Studio Dynamic Help.
For any bugs and issues, you may participate in one of the OTN discussion forums for ODAC.