Visual Web Ripper only supports Oracle databases through the Oracle OleDb provider. Oracle client software must be installed in order for the OleDb provider to work.
The OleDb provider provided by Microsoft only supports Oracle up to version 8i, so you should use the OleDB provider provided by Oracle.
Use an Oracle OleDb connection string such as this one:
Provider=OraOLEDB.Oracle;Data Source=//localhost:1521/OracleTest;User Id=test;Password=test;
The Data Source parameter in the connection string can be set to a TNS, but only if you have configured the TNS configuration file properly.