ODAC 1. 1. 2. 0. 1. Installation Instructions. August 2. 01. 0Download includes the following products: a) Oracle Developer Tools for Visual Studio (1. Oracle Data Provider for . NET 2. 0 and 4 (1. Oracle Providers for ASP. NET 2. 0 and 4 (1. Oracle Database Extensions for . NET 2. 0 and 4 (1. Oracle Services for Microsoft Transaction Server (1. Oracle Provider for OLE DB (1. Oracle Objects for OLE (1. Oracle ODBC Driver (1. Oracle SQL*Plus (1. Oracle Instant Client (1. Oracle Universal Installer (1. This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2007. 2 Oracle Database Preinstallation Requirements. This chapter describes the tasks that you must complete before you start Oracle Universal Installer. Please rate your online support experience with Esri's Support website. Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and. Oracle VM VirtualBox (formerly Sun VirtualBox, Sun xVM VirtualBox and Innotek VirtualBox) is a free and open-source hypervisor for x86 computers currently being. System Requirements. The following items are required for ODAC: Windows operating system. Windows 7 (Professional, Enterprise, Ultimate editions), Windows Server 2. Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2. Original posted at http:// Upgradation or degradation of. Windows Server 2. R2, Windows XP Professionalx. Windows 7 (Professional, Enterprise, Ultimate editions), Windows Server 2. R2 and Windows Server 2. HPC), Windows Vista (Business, Enterprise, Ultimate editions), Windows Server 2. Windows Server 2. R2, Windows XPMicrosoft . NET Framework 2. 0, 3. Note: . NET Framework 1. Access to an Oracle Database Server (Oracle 9i Release 2 or later) Additional Notes on Requirements: If you use . NET Framework 2. 0, 3. ODAC . NET components are supported. ODP. NET for . NET 2. Oracle Providers for ASP. NET for . NET 2. 0. Oracle Database Extensions for . NET 2. 0. If you use . NET Framework 4 or . NET Framework 4 Client Profile, then only the following ODAC . NET components are supported. ODP. NET for . NET 4. Oracle Providers for ASP. NET for . NET 4 - - not supported with . NET Framework 4 Client Profile. Oracle Database Extensions for . NET 2. 0. Oracle Database Extensions for . NET 4. 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 2. Oracle Services for MTS support this new DTC when the minimum operating system level is Windows Vista with Service Pack 1 or Windows Server 2. Oracle Developer Tools for Visual Studio requires either Visual Studio 2. Visual Studio 2. 00. Visual Studio 2. 00. Note: Visual Studio Express Editions are not supported with the Oracle Developer Tools. However, ODP. NET is supported with Visual Studio Express Edition. Oracle Database Extensions for . NET, a server feature of Oracle Database 1. ODAC release. You must already have Oracle Database Extensions for . NET 1. 1. 2. 0. 1. Oracle database server in the same Oracle Home where Oracle Database Extensions for . NET 1. 1. 2. 0. 1. 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. Download ODAC 1. 1. Please note: Do not download this file into the . Unzip its contents to the directory. Run Oracle Universal Installer (OUI) by launching the setup. 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. A typical directory for an OUI Oracle client Home is: C: \app\< user> \product\1. Copy the sqlnet. ora file located in the following directory: ORACLE. EZCONNECT) Oracle client can connect to the Oracle database server. 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: . The alias definition contains all the information needed to create a connection to the database server. Alias information is stored in the tnsnames. ORACLE. This alias is used as the data source value in your connection string. ODAC installations do not create a tnsnames. Alternatively, you can copy an existing tnsnames. Oracle client installation to your new ODAC installation. The following instructions assume you will have to create a new tnsnames. Copy the tnsnames. ORACLE. In the ODP. NET connection string, developers set the . In general, this value is set to port . If the TNS entries in the ORACLE. For example, if the default Oracle Home location was used during the install, the proper entry for the oracle. SOFTWARE\ORACLE\KEY. Consult the release notes first for any known issues or limitations. Check if the Oracle data access components were properly downloaded by comparing the download size to the one listed on the download page. If you have more than one Oracle Home installed on the same machine (e. Oracle 1. 0g Release 2 client and Oracle 1. Release 2 client), by installing the Oracle 1. 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. 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 1. 1. 2. 0. 1. Oracle Client 1. 1. If you do install on top of an existing Oracle Home, make sure to stop all the Windows services for that Oracle Home (e. Oracle. MTSRecovery. Service). This installation provides policy configuration files that can redirect existing 1. ODP. NET applications to the current ODP. NET version. The policy files are located in the ORACLE. 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. 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. ORACLE. Or you may create the connection aliases manually by following the Connection Setup Quick Start earlier. If errors indicating that . Viewing the ODP. NET Documentation======================================================. The PDF and HTML documentation can be viewed from the ORACLE. 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. Support and Bug Reports====================================================== For any bugs and issues, you may participate in one of the OTN discussion forums for ODAC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2017
Categories |