|Oracle Database on Windows and .NET FAQ|
| Windows, COM, and .NET Integration
A: The Oracle RDBMS on Windows web site describes how the Oracle database operates on Windows, as well as provides tips on performance tuning.
A: Oracle offers a variety of data access methods for COM-based, .NET-based, and Win32/64-based programming languages. Oracle developers can use any one of the following data access drivers based on the Windows programming language employed:
These data access drivers have been engineered to provide superior performance with Oracle and expose the database's advanced features which may not be available in third-party drivers.
A: The Oracle database provides optimum .NET data access support through the Oracle Data Provider for .NET, allowing .NET applications to access advanced Oracle features.
The Oracle Developer Tools for Visual Studio .NET help streamline the development of Oracle database applications right from within Visual Studio. It enables developers to browse and modify their Oracle schemas, leverage powerful wizards and designers, automatically generate code, and view and edit Oracle data. These and other features, including stored procedure editing with Intellisense, syntax coloring, and an integrated help system, are designed to speed development and make it easy to learn how to develop Oracle applications for Windows.
Oracle Application Server allows programmers to easily and quickly build web services via SOAP, WSDL, UDDI, and XML. SOAP and XML support has been available since Oracle9iAS. By their very definition, web services are intended to be cross-platform. As such, Oracle web services support .NET web services.
A: Oracle supports the maximum amount of memory and maximum number of processors allowable under Windows 2000, XP, and Server 2003. Oracle supports fail over using Microsoft Cluster Server with Oracle Fail Safe for up to eight nodes on Windows 2003 Datacenter. Oracle Real Application Clusters on Windows is supported beyond four nodes. Visit the High Availability home page for more information.
A: Oracle is committed to provide open solutions for our customers. This allows customers to choose the software technologies that best fit their needs. Oracle is integrated closely with popular Windows-based languages and servers to make development and deployment of Oracle products on Windows simple and seamless.
A: Oracle's integration with Windows benefits all areas of IT infrastructure: client, middle-tier, and data tier. At each of these levels, Oracle allows developers, software architects, and database administrators to take advantage of native Windows servers and technologies. This integration ensures Oracle is scalable, fault-tolerant, high-performing, and easy to develop and deploy on Windows. Whether your applications using the native Windows services, .NET, COM, or Java, Oracle offers strong support for Windows technologies.
Oracle is committed to providing the best database on Windows. Below is a brief description of the integration features:
Oracle Data Provider for .NET (ODP.NET)
Oracle Services for Microsoft Transaction Server (MTS)
Oracle Objects for OLE (OO4O)
Oracle Open Database Connectvity (ODBC)
COM Automation Feature
Very Large Memroy (VLM)
Directory & Security
Oracle Fail Safe
A: Visit the Windows Technology Center on OTN for more information.
A: Visit the .NET Developer Center on OTN for more information.
Q: Which versions of the Oracle database are supported on which versions of Windows?
A: In general, Oracle will end support of its products on a Windows operating system at the same time the operating system enters Microsoft's Non-Supported Phase or equivalent thereof. Currently, Oracle and Microsoft have desupported Windows NT and Windows 98. Consult Oracle Metalink for more details.
A: Yes, Oracle supports using different versions of the Oracle client with the Oracle Database. In general, a database server version supports the two major database client releases prior to its release and the two major releases after its release. For example, Oracle8i server supports the major client releases prior to it (Oracle7 and Oracle8) and the major releases after it (Oracle9i and Oracle10g). A database client version also supports two major server releases prior to its release and two major release after. Consult Oracle Metalink for more details on specific releases.
A: Terminal Server/Services and Remote Desktop Connection are supported. Some Oracle components will be exceptions to this support. Please check the Oracle Database release notes for your specific version for more details.
A: Oracle certifies against the specific Microsoft operating system and, if applicable, service packs (SPs) stated in the Oracle product documentation. Oracle will support the use of our products on any later SP as soon as that SP becomes generally available. Depending upon the severity, quantity and impact of the SP-related issues found, Oracle may recommend that customers wait until relevant Oracle patches have been released before upgrading to a particular SP. Oracle may recommend or discourage the installation of specific SPs if the SPs will significantly affect the operation of Oracle software, either positively or negatively. If such a statement is deemed necessary, then Oracle Development will disseminate this statement in as timely a fashion as possible after the release of an SP.
A: Yes, the Oracle database supports 64-bit Windows Server 2003 and XP 2003 and can be downloaded from OTN. Oracle was the first vendor to make database software publicly available for the 64-bit Windows Itanium platform in December, 2000. Oracle9i Database Release 2 was the first production database supported on 64-bit Windows.
For multi-core "Montecito" Itanium processors with Windows Server 2003 Service Pack 1 or higher, Oracle Database 10g Release 2 (10.2.0.2 or higher), Oracle Database 10g Release 1 (10.1.0.5 or higher), and Oracle9i Release 2 (22.214.171.124 or higher) are supported. Consult Metalink note: 400227.1 for more information on installation.
A: Consult the following matrix for certification information.
32-bit Windows consists of the family of 32-bit Windows operating systems using AMD64 and EM64T.
Windows x64 consists of the following operating systems: Windows Server 2003 x64 Edition and Windows Server 2003 R2 x64 Edition (Standard, Enterprise, Datacenter) and Windows XP Professional x64 Edition.
Consult Oracle Metalink for updated operating support information.
Oracle was the first to make a 64-bit database developer release publicly available for AMD64 and Intel EM64T chipsets.
A: Yes, EFS is supported and is transparent to Oracle. However, there is a tradeoff in using it. EFS will slow database peformance as it constantly encrypts and decrypts data, so it's not encouraged for high performance applications.
A: The Oracle Migration technology web site provides tools and documentation on moving your database to Oracle.
A: Oracle provides two connectivity solutions to address the needs of disparate data access: Oracle Transparent Gateways and Oracle Generic Connectivity. Oracle Transparent Gateways provides access to many non-Oracle data stores, including Microsoft SQL Server, Informix, Ingres, and Sybase from an Oracle environment. Oracle Generic Connectivity provides access to many data stores for which Oracle does not have a gateway solution. This feature enables transparent connectivity using ODBC and OLE DB.