Oracle Software Installation - updated
This document describes the Oracle Client Software Installation program distributed by Information Access for connection to the IA Warehouse. The installation adds and configures Oracle Client Networking Software including an updated Oracle ODBC Driver.
Obtain Oracle 11g Software via SFTP:
- SFTP (Secure File Transfer Protocol) like FileZilla
- Host Name: sftp://sftp.mnit.mn.gov
- User ID: Please contact the SWIFT Help Desk to request a user ID at SWIFTHelpDesk.MMB@state.mn.us
- Password: Please contact the SWIFT Help Desk to request a password at SWIFTHelpDesk.MMB@state.mn.us
- Once connected navigate to the “/data” directory:
- Download iaw.zip in a BINARY format to a temporary location within your environment (recommended: C:\TEMP)
Go to C:\temp and right click the zip file that you downloaded, iaw.zip, then click 'Extract All' to unpack the installation files.
If you don't have a zip tool Microsoft may open a zip file Extraction Wizard to assist in unpacking the installation files. Follow the prompts in the extraction wizard. *You should be unzipping to C:\temp only.
If you have a third party zip tool it may place a folder at the end of C:\temp named: iaw (i.e.: C:\temp\iaw) as the folder to unzip to. Remove the portion after C:\temp.
Open that folder and double click on Setup.exe
The readme file displays on screen then automatically minimizes after a short delay. This file can be saved for review in more detail at a later time.
A DOS screen (Oracle Universal Installer Working) shows the installation process and closes when finished. This may take a few minutes.
A series of message boxes shows both the SQLNET and TNSNAMES configuration files that are being built as well as the StartMenu shortcuts.
Click OK when completed.
Note: The IA Password Change application is automatically installed with this package. (Start All Programs Information Access IA Password Change)
Agency staff may test connectivity through the ODBC Data Source Administrator.
Launch C:\Windows\SysWOW64\odbcad32.exe, the ODBC Data Source Administrator (ODBC) click on System DSN tab double click IA-Warehouse in Oracle ODBC Driver Configuration box click Test Connection a login box appears.
Enter your login id and password.
Connection successful box should appear if all is correct.
If you are implementing a new firewall or making changes to an existing firewall be aware that the IA Data Warehouse requires that traffic be allowed through port 1521.
The README file contains more detailed information on products installed with this package. If you need to make additional changes to your tnsnames.ora file and are running Windows 7 you may need to contact your LAN administrator for assistance.
For application or technical support, please contact the SWIFT Help Desk at SWIFTHelpDesk.MMB@state.mn.us and request a support ticket be created.