We enabled Oracle tracing as we could not identify the cause of this problem.
At login, we got following errors.
SQL Error: 1031, SQLState: 42000 ORA-01031: insufficient privileges
We have multiple FMS' sharing the same Oracle instance but with different schema for each FMS. The issue is on only one of the FMS' which is pb-foglight-02, and it is using PB_FOGLIGHT_02 schema, but when we look at the trace file, it is trying to call update on PB_FOGLIGHT_04.sec_user which belongs to a different schema for a different FMS (pb-foglight-04), that explains why we are getting the insufficient privilege error becaues it is trying to update a table belongs to a different schema.
This issue required an Oracle software update to 11.1.0.7.10.
See attached Oracle bug report.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center