I configured the conexion between harvest and Oracle 12, but when i tried to test the conexion ir fails.
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:
- 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.
I can do that select.
when I configured the CO (configure odbc DSN) it says "Connection test succeeded" but when i try to test the connection it shows the error ORA-00942.
and when i tried to start the service it can't start and show this message in the logs
I'm reading that maybe is an error of permissions, do you know what permissions the user of harvest DB are required??
I did a quick search of KB articles and previous cases and found a few other things you might check:
You might also check to make sure enough disk space is available for your SCM database-error/kb000032909
In a few previous cases, the problem was resolved by granting view access to v$session for the harvest schema owner userid
Here is another KB article on this topic with a few suggestions:
Can you check on these things to see if any of the suggestions might solve the problem?
Let me know what you find out.