We have upgraded from 8.1.02 to 9.1.03 (RHEL 7, Oracle), Install failed at post install activities since the server couldn't come up in a timely manner. Yet, the "select dbversion from control" suggests that DB is upgraded to 9.1.03. I needed to fix ar.conf (with few custom changes) and tried to bring up the server, server and monitor comes up (but not fork) and fails shuts down with
Error creating bean with name 'serverInitializer' defined in URL [bundleentry://162.fwk66233253/spring-context/application/domain/init_context.xml]: Invocation of init method failed; nested exception is ERROR (8552): Message not in catalog; Message number = 8552. Tried looking up, but i couldn't find what 8552 means.
Going by the debug logs, import of few system forms failed with Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ARADMIN.SYS_C00226042) violated. That seems to be about overlays and we don't use overlays in our system.
SQL> SELECT column_name, position FROM all_cons_columns WHERE constraint_name = 'SYS_C00226042';
Above error appears multiple times for all the system form imports.
We encountered this error earlier as well and BMC support couldn't suggest what might have caused this and suggested to re-run the install in 'Pause' mode which didn't work for us ( we are using silent mode). To get through this error, we tried creating overlays (though we don't use them) and re-run the install, and ended up in the same scenario. Just the unique_constraint number varied, but about the same columns. Have You see ever seen this kind of error before? Any pointers are highly appreciated.
Attaching few excerpts from the logs.