Initially, the DB configuration (for both Oracle DB 11g/12c) worked after fiddling around with server v.4.2.1 (Tomcat).
I restarted from fresh, in order:
(1) stop and remove 4.2.1,
(2) reinstall 4.3.0,
(3) drop all (39) tables in the DB,
(4) start 4.3.0,
(5) add license
(6) configure DB (Oracle), validate and save
(7) shutdown and start 4.3.0
(8) server web interface shows:
CloverETL Server initialization has failed
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Check the DB, there are only 20 tables (usually 39), including one new table (GRAPH_EVENt_LISTENER) which does not exist among the 39 tables.
Repeat the procedure with 4.2.1 (instead of 4.3.0 above), and fails in the same way as above.
I cannot remember how I got the DB working in the first place -- it was not straight forward.
Any idea what caused the problem?