There is a necessity to import information/data from a Oracle Database inside the ITMS Console.
This connection type should be already configured by the person responsible for the Oracle Environment.
ITMS 7.x and 8.x
An error occurred loading page. The 'OraOLEDB.Oracle' provider is not registered on the local machine.
Oracle Database configuration was not done properly.
All the following steps MUST be validated and guided by your Oracle Team. Symantec will not give support if the following steps does not work, as it is a third-party software installation.
Install the ODAC 220.127.116.11 x64. It should be installed in the "C:\Oracle\" directory
Download and Install the "Oracle Instant Client" in the same folder structure as the ODAC was installed.
Ex: ODAC installed in "C:\Oracle\product\12.2.0\client_1\", install the Instant Client in "C:\Oracle\product\".
If you found only the .zip file of the "Oracle Instant Client", follow the next few steps:
Unzip all .ZIP inside "C:\Oracle\product\instantclient_12_2"
Create the folders NETWORK and ADMIN in the following path structure: "C:\Oracle\product\instantclient_12_2\Network\Admin". In this folder is necessary to put the files "sqlnet.ora" and "tnsnames.ora" being previously configured (Talk to your Oracle Team).
Create and Configure the environment variable ORACLE_HOME that needs to point to the directory where the "Instant Client" is installed.
Configure the PATH environment variable with the address where the ODAC binaries and DLLs are also the directory where the "Instant Client" is installed (keeping the last one as a first choice).