## Installation The installation of the Oracle client can be done following the next steps: - The Oracle client is available via www.invantive.com. - Unzip the download. - Navigate to the folder containing the ‘setup’ program. - The Oracle installation program appears. - It is recommended to install the most comprehensive version within the license agreement, so that all devices are readily available if they should be needed later. - Select the required languages via ‘Product Languages’. - Select ‘OK’ and then ‘Next’. Recommended installation location is `c:\oracle`. - Subsequently a number of checks will be performed. If problems are found, solve them first. - Check the settings. - Check if ODP.Net is listed between the products to be installed. - Execute the installation by choosing 'Install'. - The progress is displayed. - Afterwards a configuration program for the network configuration is started. Choose ‘Cancel’, we advise you to use the configuration file `tnsnames.ora` as described in the next part of the instructions. - Select ‘Next’: - Close the error message about the failure of the Oracle Net Configuration Assistant. - Select ‘Exit’: ## Configuration Follow these steps to configure the Oracle client for use with Invantive Web Service: - Construct (if not available yet) a `tnsnames.ora` configuration file. - In a `tnsnames.ora file` (‘tns’ is the abbreviation for ‘Transparant Network Substrate’) all Oracle based databases (‘services’) and the route via the network to get there, are described. - Full instructions on creating `tnsnames.ora` can be found in the Oracle documentation. - Make sure that the `tnsnames.ora` file is located on the same place on all PC's, preferably in way to make it easy to add services from a central location. - Open the register with `regedit` and go to the key `HKLM\SOFTWARE\Oracle\KEY_OraClient11g_home1`. - Add a string with the name `TNS_ADMIN` and make it point to the network location. - Change also the `NLS_LANG` to `DUTCH_THE NETHERLANDS.AL32UTF8` to make sure that messages appear in dutch and the Unicode character set is used. - If you use Oracle Instant Client, then there is no `NLS_LANG` in the Windows registry; that's why you need to define the `NLS_LANG` environment variable in Windows. - Test the connection from a command prompt with `tnsping`. - It is still not certain if the user/password are correct, but it is certain that a network connection to the Oracle service can be built. - Finally, check the connection by logging in with SQL\*Plus.