8 Installing Oracle Database Gateway for SQL Server
This section provides information about the hardware and software requirements and the installation procedure for Oracle Database Gateway for SQL Server.
To install the Oracle Database Gateway for SQL Server, follow these steps:
-
Ensure that the system meets all of the hardware and software requirements specified in System Requirements for Oracle Database Gateway for SQL Server section System Requirements for Oracle Database Gateway for SQL Server.
-
Run the Oracle Universal Installer.
See Step Through the Oracle Universal Installer section Step Through the Oracle Universal Installer for more information on running the Oracle Universal Installer.
Oracle Universal Installer is a menu-driven utility that guides you through the installation of the gateway by prompting you with action items. The action items and the sequence in which they appear depend on your platform.
See Table 8-2 for description of the installation procedure of Oracle Database Gateway for SQL Server.
System Requirements for Oracle Database Gateway for SQL Server
This section provides information about the hardware and software requirements for the gateway. It contains the following sections:
Refer to the Oracle Database Installation Guide for Microsoft Windows and to the certification matrix on My Oracle Support for the most up-to-date list of certified hardware platforms and operating system version requirements to operate the gateway for your system. The My Oracle Support Web site can be found at:
Hardware Requirements
Table 8-1 lists the minimum hardware requirements for Oracle Database Gateway for SQL Server.
Table 8-1 Hardware Requirements for Oracle Database Gateway for SQL Server
Requirement | For Microsoft Windows (64-bit) |
---|---|
Total disk space |
5 GB |
Physical Memory |
Minimum of 1 GB |
Virtual memory |
Double the amount of RAM |
Video adapter |
256 colors |
Processor |
AMD64, or Intel Extended memory (EM64T) |
Software Requirements
Oracle Database Gateway for SQL Server is supported on the following Microsoft Windows (64-bit) operating systems:
-
Microsoft Windows Server 2003 - all x64 editions
-
Microsoft Windows Server 2003 R2 - all x64 editions
-
Microsoft Windows XP Professional x64 Edition
-
Microsoft Windows Vista x64 - Business, Enterprise, and Ultimate editions
-
Microsoft Windows 2008 x64
Certified Configurations
The gateway supports SQL Server. For the latest versions supported refer to the OTN Web site:
http://www.oracle.com/technetwork/database/gateways/index.html
Step Through the Oracle Universal Installer
Step Through the Oracle Universal Installer
Table 8-2 describes the installation procedure for Oracle Database Gateway for SQL Server.
Table 8-2 The Oracle Universal Installer: Steps for Installing Oracle Database Gateway for SQL Server
Screen | Response |
---|---|
Oracle Universal Installer: Welcome |
Click Next. |
Oracle Universal Installer: Specify Home Details |
Specify a name for the installation in the Name field. You can also choose not to edit the default setting of the Name field of the Specify Home Details screen. The Path field in the Specify Home Details screen is where you specify the destination for your installation. You need not edit the path specification in the Path field. The default setting for this field points to |
Oracle Database Gateway for SQL Server |
SQL Server Database Server Host Name - Specify the host name of the machine hosting the SQL Server database. SQL Server Database Server Port number - Specify the port number of the SQL Server database server SQL Server Database Name - Specify the SQL Server database name Click Next to continue. |
Oracle Universal Installer: Summary |
The Installation Summary screen enables you to review a tree list of options and components for this installation. Click Install to start installation. |
Oracle Net Configuration Assistant: Welcome |
Click Cancel. |
Oracle Net Configuration Assistant: |
Click Yes. |
Oracle Universal Installer: Configuration Tools |
Click Exit. |
Exit |
The final screen of the Oracle Universal Installer is the End of Installation screen. Click Exit to exit the installer. |
The gateway is now installed.
When the Oracle Universal Installer confirms that the installation is complete, verify that the installation procedure was successful. To do this, read the contents of the installation log file, which is located in the C:\Program Files\Oracle\Inventory\logs directory.
The default file name is InstallActions
YYYY-MM-DD_HH-mm-SS-AM/
PM
.log
, where:
YYYY
is yearMM
is monthDD
is dayHH
is hourmm
is minuteSS
is secondsAM/PM
is daytime or evening
Each of these variables in the log file name represents the date and time the product was installed.