PROCEDURE When installing a New VM for Adstra’s production environment with OCI dependencies or when a developer with approval from client POC requests a local install.

REQUIREMENTS

PWS > Domain\Service Accounts > Active Directory ALC

STEPS

1. On the target system, use the ctac credentials to connect to \\172.20.1.2\Helpdesk\Oracle Client\Oracle 12.2\Full Client
2. Copy the appropriate installer zip (32 or 64bit) to \Downloads
3. win32_12201_client
4. winx64_12201_client
5. Open zip and extract client folder to \Downloads
6. Create necessary app folders & path:
7. 64-Bit: c:\oracle\product\12.2.0\client_x64
8. 32-Bit: c:\oracle\product\12.2.0\client_32
9. Open the client folder in \Downloads
10. Right-Click and run setup.exe as an Administrator
11. Select InstantClient from the Oracle Database Install Wizard
12. Click Next
13. Click Browse…
14. Navigate to the path created in step 4.a or 4.b
15. Click Select
16. Click Next
17. Take defaults, click Install
18. After the install, navigate to the path created in step 4.a or 4.b and create two more folders:
19. **eg c:\oracle\product\12.2.0\client_x64\**network\admin **or c:\oracle\product\12.2.0\client_32\**network\admin
20. Copy the tnsnames.ora file to the \admin folder above attached to this KB
22. Now we need to configure the Oracle ODBC Configuration, navigate to C:\WINDOWS\System32
23. Open odbcad32.exe as an Admin
25. Click Add
26. Select Oracle in OraClient12Home
27. Click Finish
29. Configuration:
30. Data Source Name: ALC_Oracle_Data_Warehouse
31. Description: ALC_Oracle_Data_Warehouse
32. TNS Service Name: DWP
33. User ID: [User Specific]
34. User should contact their Manager or client POC for credentialing
35. Take all other defaults and click Test Connection to verify configuration and user credentials are accurate.

SUCCESS:

• Test Connection is successful

FAILURE:

• Contact vITM

REFERENCES

NA