|Applies To||RSA Product Set: Identity Management and Governance|
RSA Version/Condition: 6.8.x,6.9.x,7.0.x
Product Description: Access Request Manager
|Issue||Here is an example of the ORA-60 as you will see it in /home/oracle/wildfly-8.2.0.Final/standalone/log/aveksaServer.log (V7 path) of an ACM installation:|
10/17/2016 09:12:16.452 ERROR (Worker_jobq#JobQ1#WPDS_94) [com.aveksa.server.workflow.scripts.nodes.BaseWorkflowNode] Exception :
The ORA-60 usually points to an application design issue, where locking of objects is not fine grained enough..
However, it may also be caused by some other id in the database blocking one ACM session, not allowing it to finish, and thus impeding another session needing the same locks to issue the ORA-60.
The trace files issued by Oracle in /u01/app/oracle/diag/rdbms/avdb/AVDB/trace will tell you the statements that collided, but not if another process had its hand in the incident.
|Resolution||In order to know if there was some sort of hang situation involved to create the ORA-60, you can enable an event in the database that will produce more information to analyze.|
This will only produce a trace file if and when when the ORA-60 happens and does not have any other effect on the database.
This setting will disappear when you restart the database.
sqlplus / as sysdba
When you do
you should see the event enabled:
Wed Oct 19 19:07:16 2016
When it triggers, you would see something similar to this in the alert log:
Wed Oct 19 19:12:11 2016
RSA Support needs that trace file that is listed in the alert_AVDB.log ( it will have a different name on each customer system).
The hanganalyze will show if there was another condition that led to the ORA-60.