If installing on a 64‐bit Administration client and using an Oracle database for Contenta data, before installing the Contenta software, configure the Oracle ODBC Data Source.
About this task
Note: You must configure the ODBC with 32‐bit Odbcad32.exe (Data Source Administrator tool) on a 64‐bit machine.
Procedure
Make sure that the Firewall is turned off or that the Oracle port is open.
Create a shortcut to “C:\Windows\SysWow64\odbcad32.exe” under Control Panel > Administrative Tools by copying the file odbcad32.exe and doing a paste shortcut under Control Panel > Administrative Tools.
Rename the shortcut to “32_Bit_Data_Source (ODBC)”.
Add the Contenta SID to the tnsnames.ora file.
Note: On the Contenta Server, ensure that Contenta SID is added to tnsnames.ora file under 32‐bit Oracle.
Execute “ODBC Data Source (32‐bit)” under Control Panel > Administrative Tools, double‐click on the entry in the list, which displays the ODBC interface.
Add the Oracle driver and add ContentaDSN data source and point to the CS/DB Server SID.