Error starting server

Document ID : KB000115840
Last Modified Date : 26/09/2018
Show Technical Document Details
Issue:
Installed the Harvest server, but starting the broker it returns an error:

[Oracle][ODBC][Ora]ORA-00942: table or view does not exist 
SQLSTATE=S0002 
HServer | 20180917 16:54:57 | ERROR: E03020003: Database error [Oracle][ODBC][Ora]ORA-00942: table or view does not exist 
SQLSTATE=S0002 . 
************************ 
Environment:
Harvest v13 64bit on Windows 2016 + Oracle client 11.2, 64bit 
ORACLE DB 11.2.0.4.0 - running on remote server Linux Redhat 7.4 
Harvest repository not moved/copied from a different server. Created from scratch
Resolution:
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.