There are a couple of possible causes for this problem:
1. Your tnsnames.ora file is providing the wrong hostname and port number, and so you are connecting to the wrong Oracle instance
2. You have provided a valid Oracle login id and password, but not the login id for the schema owner to the Harvest database.
During this "Test Repository" step, Harvest will login to the Oracle database it finds at the hostname and port number in tnsnames.ora, and under the schema owner's userid it will look for a table named "HARTABLEINFO". If it doesn't find that table either it's got the wrong schema owner, or it's got the wrong database.
You can verify the settings with SQL*Plus. Try this command from a command prompt:
sqlplus userid@servicename/password
Where:
- userid = the harvest database schema owner userid
- servicename = the tns service name from your tnsnames.ora file
-password = the harvest database schema owner password
After logging in, execute this statement to verify the database is there:
select * from hartableinfo;
Let me know if this helps.