Oracle Data Provider for .NET is part of Oracle Data Access Components (ODAC), which can be downloaded from OTN. Beginning with ODAC 11.1.0.6.20, Oracle Data Provider for .NET can be installed through XCopy or Oracle Universal Installer.
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.Inner Exception: Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize at Oracle.DataAccess.Client.OracleConnection.cctorStatckTrace. Below are two paths and the files present in the installation of Oracle client 32 bit (win3211gR2client.zip) for.NET 2.X and 4.X. When I installed the Oracle client, I chose not to take the def.
Note:
This section describes installation using the Oracle Universal Installer. For installation and configuration using the XCopy install, refer to the README.TXT file that is part of the XCopy installation.
Additionally, Oracle Data Provider for .NET Dynamic Help is registered with Visual Studio, providing context-sensitive online help that is seamlessly integrated with Visual Studio Dynamic Help. With Dynamic Help, the user can access ODP.NET documentation within the Visual Studio IDE by placing the cursor on an ODP.NET keyword and pressing the F1 function key.
Oracle Data Provider for .NET creates an entry in the
machine.config file of the computer on which it is installed, for applications using ADO.NET 2.0 and OracleClientFactory class. This enables the DbProviderFactories class to recognize ODP.NET.
See Also:
Oracle Database Installation Guide for Windows for installation instructions
File Locations After Installation
The
Oracle.DataAccess.dll assembly is installed to the following locations:
.NET Framework 2.0:
ORACLE_BASE
ORACLE_HOME
odp.netbin2.x directory
.NET Framework 4:
ORACLE_BASE
ORACLE_HOME
odp.netbin4 directory
Note:
If the machine has the corresponding .NET Framework installed, then the Oracle.DataAccess.dll assembly is added to the Global Assembly Cache (GAC) as well. This is to ensure 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.
Documentation and the
readme.txt file are installed in the ORACLE_BASE
ORACLE_HOME
ODP.NET
doc directory.
Samples are provided in the
ORACLE_BASE
ORACLE_HOME
ODP.NET
Samples directory.
Search Order for Unmanaged DLLs
ODP.NET consists of managed and unmanaged binaries. Through the use of the
DllPath configuration parameter, each application can specify the ORACLE_BASEORACLE_HOME bin location that the dependent unmanaged Oracle Client binaries are loaded from. However, the ORACLE_BASEORACLE_HOME must have the same ODP.NET version installed as the version that the application uses. Otherwise, a version mismatch exception is thrown.
The
Oracle.DataAccess.dll searches for dependent unmanaged DLLs (such as Oracle Client) based on the following order:
Upon installation of ODP.NET, Oracle Universal Installer sets the
DllPath Windows Registry value to the ORACLE_BASEORACLE_HOME bin directory where the corresponding dependent DLLs are installed. Developers must provide this configuration information on an application-by-application basis.
When a new ODP.NET version is installed, default values are set in the Windows Registry for the new version. Because the policy DLLs redirect all ODP.NET references to this new ODP.NET version, applications use the default values. Developers can provide a config or
web.config file specific to the application to prevent this redirection. The configuration file settings always apply to the application, regardless of whether or not patches or new versions are installed later.
ODP.NET Configuration File Support is only available for version 10.2.0.4 and later.
Note:
Both Oracle.DataAccess.dll for .NET Framework 2.0 and Oracle.DataAccess.dll for .NET Framework 4 use the same unmanaged DLL, OraOps11w.dll .
ODP.NET and Dependent Unmanaged DLL Mismatch
To enforce the usage of
Oracle.DataAccess.dll assembly with the correct version of its unmanaged DLLs, an exception is raised if Oracle.DataAccess.dll notices it has loaded a mismatched version of a dependent unmanaged DLL.
You can use 32-Bit media for installing Oracle Database Client on all supported operating systems. You can use 64-Bit media for installing Oracle Database Client on all supported 64-bit x64 operating systems. This guide is for both Windows 32-Bit and Windows x64. This chapter covers the following topics:
3.1 Preinstallation Considerations Before Installing Oracle Database Client
The Oracle Database Client software is available on the Oracle Technology Network (OTN) Web site. In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install the software. However, you can also use Oracle Universal Installer to complete silent-mode installations using response files, without using the GUI. Ben 10 omniverse all episodes.
Review the information in Chapter 1, 'Oracle Database Client Installation Overview' and complete the tasks listed in Chapter 2, 'Oracle Database Client Preinstallation Requirements' before beginning the installation.
Next, consider the following issues:
3.1.1 Installation Consideration on Windows Vista and Later
On Windows Vista, Windows Server 2008, Windows Server 2008 R2, Windows 7, Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2, command prompts should be opened with Administrator privileges.
See Also:
'Managing User Accounts with User Account Control'
3.1.2 Installing Oracle Database Client Installations in Silent or Response File Mode
If you need to perform multiple installations of Oracle Database Client, you may want to use silent or response file mode, with response files. In these modes, at each computer, you run Oracle Universal Installer from the command line using a response file. The response file is a text file containing the settings you normally enter in the Oracle Universal Installer GUI dialog boxes. This method lets you quickly perform multiple installations using similar settings for each computer.
See Also:
Appendix B, 'Installing Oracle Database Client Using Response Files' for instructions on performing silent or response file mode installations
3.1.3 Creating the Oracle Base Directory
If you install Oracle Database Client on a computer with no other Oracle software installed, Oracle Universal Installer creates an Oracle base directory for you. If Oracle software is already installed, one or more Oracle base directories already exist. In the latter case, Oracle Universal Installer offers you a choice of Oracle base directories into which you can install Oracle Database Client.
You are not required to create an Oracle base directory before installation, but you can do so if you want.
Note:
You can choose to create a new Oracle base directory, even if other Oracle base directories exist on the system.
3.1.4 Installing Oracle Database Client into Multiple Oracle Homes
You can install all Oracle components in multiple Oracle homes on the same computer. However, some components can only support one active instance at a time. This means that the current (latest) installation renders the previous one inactive. These components are:
Note:
Oracle Objects for OLE is not supported on Windows x64.
3.1.5 Installing Oracle Database Client on a System with an Existing Oracle Software
Oracle Database Client can be installed in the same Oracle Database home if both products are at the same release level. For example, you can install Oracle Database Client 10g Release 2 (10.2) into an existing Oracle Database 10g Release 2 (10.2) home. If you apply a patch set before installing the client, then you must apply the patch set again. Oracle Universal Installer will prompt you for an Oracle home directory, whether you have other Oracle software installed on the computer or not. You cannot install products from one release of Oracle Database Client into an Oracle home directory of a different release. For example, you cannot install Oracle Database 11g release 1 (11.1) software into an existing Oracle9i Oracle home directory.
You can install this release more than once on the same system as long as each installation is installed in a separate Oracle home directory.
3.1.6 Updating the Existing Software with the Current Version
Use the In-Place Upgrade feature to upgrade an existing client installation to the latest release by installing the new client software into an existing client home with the same installation type. For example, if release 11.2.0.1 is installed, then use Oracle Universal Installer to upgrade to release 11.2.0.2.
Consider the following before selecting this option:
This functionality is available starting with Oracle Database 11g Release 2 (11.2.0.2).
See Also:
'Performing an In-place Oracle Database Client Upgrade'
3.2 Accessing the Installation Software
The Oracle Database Client software is available on installation media or you can download it from the Oracle Technology Network (OTN) Web site, or Oracle Software Delivery Cloud Web site. To install the software from the hard disk, you must either download it and unpack it, or copy it from the installation media, if you have it.
You can access and install Oracle Database Client by using the following scenarios:
3.2.1 Installing from a Remote DVD Drive
If the computer where you want to install Oracle Database Client does not have a DVD drive, you can perform the installation from a remote DVD drive. You must complete the following steps:
3.2.1.1 Step 1: On the Remote Computer, Share the DVD Drive
The remote DVD drive that you want to use must allow shared access. To set this up, perform these steps on the remote computer that has the DVD drive:
3.2.1.2 Step 2: On the Local Computer, Map the DVD Drive
Perform these steps on the local computer to map a remote DVD drive and to run Oracle Universal Installer from the mapped drive:
3.2.2 Installing on Remote Computers Through Remote Access Software
If you want to install and run Oracle Database Client on a remote computer (that is, the remote computer has the hard drive and will run Oracle Database Client components), but you do not have physical access to the computer, you still can perform the installation on the remote computer if it is running remote access software such as VNC or Symantec pcAnywhere. You also need the remote access software running on your local computer.
You can install Oracle Database Client on the remote computer in one of two ways:
3.2.2.1 Installing on Remote Computers from a Hard Drive
If you have copied the contents of the Oracle Database Client DVD to a hard drive, you can install from the hard drive.
The steps that must complete are:
3.2.2.2 Installing on Remote Computers from a Remote DVD DriveOracle Dataaccess Client Download Windows 7
You can insert the DVD into a drive on your local computer, and install from the DVD.
The steps that you need to complete are:
3.2.3 Downloading Oracle Software
You can download the trial version of the installation files from the Oracle Technology Network (OTN) or Oracle Software Delivery Cloud Web site and extract them on your hard disk. Make sure that you completely review and understand the terms of the license. Most downloads include the Development License. This section contains the following topics:
3.2.3.1 Downloading the Installation Archive Files from OTNOracle.dataaccess.client.oracleconnection Download
To download the installation archive files from Oracle Technology Network:
3.2.3.2 Downloading the Software from Oracle Software Delivery Cloud
You can download the software from Oracle Software Delivery Cloud as Media Packs. A Media Pack is an electronic version of the software that is also available to Oracle customers on CD-ROM or DVD. To download the Media Pack:
See Also:
3.2.3.3 Extracting the Installation Files
To extract the installation archive files, perform the following steps:
3.2.4 Copying the Oracle Database Client Software to a Hard Disk
To copy the contents of the media to a hard disk:
Oracle Dataaccess Client Download Windows 10
When you have copied the required installation files, see the 'Installing the Oracle Database Client Software' section.
3.3 Installing the Oracle Database Client Software
This section covers the following topics:
3.3.1 Guidelines for Installing Oracle Database ClientOracle Managed Data Access Client Download
In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install Oracle Database Client. However, you can also use Oracle Universal Installer to complete silent installations using a response file, without using the GUI. This method is particularly useful if you need to perform multiple installations of Oracle Database Client.
As you install Oracle Database Client, follow these guidelines:
See Also:
Appendix B, 'Installing Oracle Database Client Using Response Files' for information about silent or response file mode installations
3.3.2 Procedure for Installing Oracle Database Client
Use Oracle Universal Installer to install the Oracle Database Client software.
To install Oracle Database Client perform the following steps:
Using Oracle Net Configuration Assistant
During a Custom Oracle Database Client installation, if you select Oracle Net Listener from the list of components to install in step 10, then Oracle Universal Installer automatically starts Oracle Net Configuration Assistant as part of the Oracle Database Client installation. Perform the following to configure the listener and naming methods using Oracle Net Configuration Assistant:
You can also run Oracle Net Configuration Assistant after the installation in standalone mode to configure the listener, naming methods, net service names, and directory server usage.
To start Oracle Net Configuration Assistant in standalone mode, select Programs from the Start menu, and then select Oracle -
HOME_NAME . Next, select Configuration and Migration Tools, and then Oracle Net Configuration Assistant.
See Also:
'Using Oracle Net Configuration Assistant to Configure Network Components' in Oracle Database Net Services Administrator's Guide
3.3.3 Performing an In-place Oracle Database Client Upgrade
Starting with Oracle Database 11g Release 2 (11.2.0.2) you can perform an in-place upgrade of Oracle Database Client 11g Release 2 (11.2) using the following instructions:
Note:
You can perform an in-place Oracle Database Client upgrade only if you have an existing Oracle Database Client 11g Release 2 (11.2.0.1) or later client home installed on your system.
See Also:
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |