Installed the Harvest server, but starting the broker it returns an error:
[Oracle][ODBC][Ora]ORA-00942: table or view does not exist
HServer | 20180917 16:54:57 | ERROR: E03020003: Database error [Oracle][ODBC][Ora]ORA-00942: table or view does not exist
Harvest v13 64bit on Windows 2016 + Oracle client 11.2, 64bit
ORACLE DB 126.96.36.199.0 - running on remote server Linux Redhat 7.4
Harvest repository not moved/copied from a different server. Created from scratch
From HDBSetup.log we could see that ep i.e (Encrypting user details) part is missing, hence the "default" db credentials are considered to be encrypted as against to the "CR user details".
As a result, the access to specific tables doesn't exist for that corresponding user and it fails.
Could you please try to perform an "ep" or try running the following command:
svrenc -usr YOUR_USER -pw your_password -s
*-password it means the password which you have given during CR option while creating harvest user.
Then start the broker.