Oracle error when installing ALM Octane

Question ID: 110025
2
0

We are getting this error when installing ALM octane, what could be the cause?

Failed to execute string query: SELECT USERNAME FROM DBA_USERS WHERE USERNAME=’TEMP’
2021/01/26 05:29:36 | java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Marked as spam
Posted by (Questions: 100, Answers: 4)
Asked on January 28, 2021 9:11 pm
4 views
Answers (1)
2
Private answer

This error is caused because Octane is trying to use the admin-user that you specified for the oracle database to create a new schema user, make sure that the admin-user that you setup for oracle has the following:

CREATE USER
CREATE SESSION WITHADMIN OPTION
CREATE TABLE WITHADMIN OPTION
CREATE SEQUENCE WITHADMIN OPTION
DROP USER (optional). If not provided, the DBA must take responsibility for cleaning up
unnecessary schemas

Marked as spam
Posted by (Questions: 0, Answers: 365)
Answered on January 28, 2021 9:35 pm