Hello Experts,
I have migrated our CBS data(around 2TB) from 11.2.0.3 on LINUX 3-node RAC to 11.2.0.4 AIX 2-node RAC. I have used TTS to migrate data. Migration is successful as I can see data and there are no invalid objects as well. Application team can insert, update, delete data from pl/sql developer also. All the package and procedures are there. Also I have set the parameter according to this note:
ORA-08177: Can't Serialize Access For This Transaction After Upgrading To 11.2 ( Doc ID 1285464.1 )
Now, The issue is in some application UI, when application users are trying to make financial transactions or check book/lot issue, when they click OK button this serialization error appears. I dont have any clue. Raised SR to MOS but they also not able to provide any solid solution.
Any one here faced this sort of issues before? If you have any possible work around requesting you to share. Waiting for comments.
Regards,
Zakir