This document describes the 32bit and 64bit Oracle 19C Client Software Installation process distributed by MMB for connection to the EPM Data Warehouse. The installation adds Oracle Client Networking Software including updated 32bit and 64bit Oracle ODBC Drivers.
Go to C:\TEMP, or the folder where you have downloaded the zip file, and right click the file that you downloaded. Select '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. It is recommended to unpack the files in C:\TEMP or some folder where you can easily find the extracted files.
The Oracle 19C client package is installed with a PowerShell script. On the Windows 10 / 11 Start Menu, search for ‘Windows PowerShell ISE’ and launch as Administrator. If the PowerShell ISE is not launched as Administrator, the installation process will run but may not be able to complete all the necessary installation and configuration steps.
This installation package will deliver both the 32bit and 64bit Oracle 19C client software. A DOS screen (Oracle Universal Installer) pops up and shows the installation process and closes when finished. This will take several minutes as it is launched once for the 32bit client and once for the 64bit client installation.
Note: The Oracle Password Changer program is automatically installed with this package. Look for the shortcut on the Start Menu. Start / Information Access / Oracle Password Changer.
Agency staff may test connectivity through the 32bit or 64bit ODBC Data Source Administrator.
Launch the 32bit ODBC Data Source Administrator (C:\Windows\SysWOW64\odbcad32.exe) or the 64bit ODBC Data Source Administrator (C:\Windows\System32\odbcad32.exe).
Once an ODBC Data Source Administrator is opened, pay attention to the Platform field. Although either the 32bit or 64bit ODBC Data Source Administrator can display all ODBC connections, only the 32bit ODBC Data Source Administrator can Modify / Configure 32bit connections. If you launch the 64bit ODBC Data Source Administrator, you can only Modify / Configure 64bit connections. Otherwise, the Remove and Configure buttons are grayed out and unavailable.
Click on the System DSN tab. Select an ODBC connection of your choice, preferable one that you have login credentials for. Click the Configure button. In the Oracle ODBC Driver Configuration box, click the Test Connection button and the Oracle ODBC Driver Connect login box will appear where you can enter login credentials and test connectivity. If the login box takes a while to display, the Oracle client may be having difficulty locating the tnsnames.ora file.
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 EPM and IA Data Warehouses require that traffic be allowed through port 1521.
If you need to make changes to your ODBC connections or tnsnames.ora file, you may need to contact your local application support team for assistance.
For application or technical support, please contact the SWIFT Help Desk and request a support ticket be created.
