Before you proceed
If you do not have a "Q" drive on your computer, you must request access to the CMS data center through the Security Request Form before a "Q" drive will appear on your computer. If you have already submitted a Security Request form and that request has been completed, but still do not have the "Q" drive after rebooting your computer, please contact the Technology Support Desk.
Installing the client
The installer is at "Q:\Technical\Oracle\winx64_21300_client". It is the recommended installer and the instructions will use this as the example.
- Navigate to "\\csu-fs001-sta\CMS$\Technical\Oracle\winx64_21300_client\client" and double click the setup.exe file:
- Select "Custom" and click the "Next" button:
- Select "Use Windows Built-in Account" and click the "Next" button:
- The Oracle client can be installed anywhere, but the provided "Oracle base" is recommended. Remove any reference to username, and click the "Next" button:
- Select the "SQL*Plus", "Oracle Advanced Security", and "Oracle Net" components to install, then click the "Next" button:
- Make a note of the "Oracle home location" since this path will be needed for the last step of the installation, and then click the "Install" button:
- Close the installer after installation is complete.
- Copy the two files(sqlnet.ora and tnsnames.ora) found in "Q:\Technical\Oracle\Database\Copy the files in this subfolder to user computer" to the "Oracle home location" path outlined in the installation summary shown in step 6, in the network\admin subdirectory from there. For this example, we would copy the files in "Q:\Technical\Oracle\Database\Copy the files in this subfolder to user computer" to "C:\app\client\product\21.0.0\client_1\network\admin".