Primary navigation

    Oracle Software Installation - updated

    This document describes the 32bit Oracle 11g 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 32bit Oracle ODBC Driver.

    Obtain 32bit Oracle 11g client 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)

    Installation Instructions

    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 Start Menu 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) 


    Verify Connectivity

    Agency staff may test connectivity through the 32bit ODBC Data Source Administrator. 

    Launch C:\Windows\SysWOW64\odbcad32.exe, the 32bit ODBC Data Source Administrator.  Click on the System DSN tab, double click IA_Warehouse.  In the Oracle ODBC Driver Configuration box, click the Test Connection button and a login box will appear.

    Enter your login id and password. Click Ok.

    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. 

    Application Support

    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 and request a support ticket be created. 

    Updated 08/23/2019

    back to top