Installing Oracle 11g client and setting up ODBC

These instructions explain how to set up the new (as of January 2025) Oracle client 11g on a computer that already has Oracle 8.1 installed as well as configuring ODBC connections.

Log in as an Administrator user or change current user type from Standard to Administrator.
Run ODBC Data Sources (32 bit) as Administrator and delete User DSN ptmn/pilt/test “Oracle ODBC Driver” and System DSN ptmn/pilt/test “Microsoft ODBC for Oracle”.
Deinstall Oracle 8i.
1. Use Universal Installer to uninstall.
2. Open RegEdit and delete folder.
  [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ORACLE]
3. Delete C:\Oracle\Ora81 folder.
4. Delete C:\MAPICS folder. If this folder doesn’t exist, skip steps 24-27 below.
Reboot computer.
Copy the folder “Software Installs” from “N:\Temporary Holding\Oracle 11.2\” to the Desktop.
Total free disk space must be less than 2 TB for the Oracle client to be installed. If necessary, create a temporary file to bring free disk space below 2 TB using the following commands in Command Prompt:

cd \users\<username>\desktop
fsutil file createnew temp.dat 2048000000000

This will create a 2TB file on the Desktop, which can be deleted after the Oracle client has been installed.
Navigate to the folder “.\Software Installs\Oracle Client\Oracle_11.2.0.1_32bits\client\” which was copied from Temporary Holding.
Right-click on setup.exe, select properties and set Compatibility mode to Windows XP SP3.
Run Setup. It takes about 30 seconds to open. If nothing seems to happen, check available disk space and refer to section 3 above.
1. Select Administrator and click Next.
2. Set language to English (should be selected by default) and click Next.
3. Specify Oracle Base: C:\oracle and click Next.
4. Summary will show up. Click Finish.
5. Install progress will be shown.
6. Click Cancel if presented with Java Firewall access.
7. Click Skip this installation if presented with .NET Framework install.
8. .NET Framework 3.5 should already be installed, but allow that to download and install if it prompts you to.
When Oracle Client has been installed, click Close to close window.
Copy TNSNAMES.ORA from “.\Software Installs\Oracle Client\” to “c:\oracle\product\11.2.0\client_1\network\admin\”.
Reboot computer.
Copy folder “instantclient_19_24” from N:\Temporary Holding\InstaClient242\ to C:\oracle\
Open Command Prompt as Administrator and run the following commands:
cd \oracle\instantclient_19_24
odbc_install.exe
Run ODBC Data Sources (32 bit) as Administrator.
1. Create User DSN for ptmn/pilt using “Oracle in instantclient_19_24”
  (enter values ptmn/ptmn/ptmn/prod or pilt/pilt/pilt/prod).
  
  Click “Test Connection” and use password “prod”. A “Connection successful” window should pop up.
2. Create System DSN for ptmn/pilt using Microsoft ODBC for Oracle
  (enter values ptmn/ptmn/prod/prod or pilt/pilt/prod/prod).
Reboot computer.
Run Registry Editor as Administrator.
Open Folder
[HKEY_USERS\S-1-5-21-2065476035-3373646151-2599118063-2986\Software\ODBC\ODBC.INI\ODBC Data Sources]

Change data value(s) “Oracle in instaclient_19_24” to “Oracle ODBC Driver”.

If the computer has more than one user, the correct one can be found by checking the values of the variables in the “Volatile Environment” folder for each user:
Open Folder [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers]

Rename name “Oracle in instantclient_19_24” to “Oracle ODBC Driver”.
Open Folder
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI]

Rename folder name “Oracle in instantclient_19_24” to “Oracle ODBC Driver”.
Reboot computer.
Copy folder MAPICS from N:\Temporary Holding\Mapics 9.0\ to C:
Create MAPICS shortcut for MENUCLS1.exe to Desktop.
Right-click shortcut and add “ -db” to Target location.
Rename shortcut to “MAPICS”.
If a dummy file was created in step 6, this one should be deleted.
Test:
1. MAPICS
2. Wyatt
3. Invoice (Finance and Terminal Server)
Delete folder “Software Installs” from Desktop.