Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-08177 in oracle 11gr2

772017Aug 1 2012 — edited Aug 2 2012

Dear All,

Recently we have migrated one of our database from 10gr2 to 11gr2(11.2.0.3) to a new server.We did the migration using oracle datapump full backup.Our Application is running on Oracle Application Server 10g. And it's a core banking solution.

But the issue is, when the users do transaction concurrently it gives the error "ORA-08177 can't serialize access for this transaction" in our application code. According to metalink note (metalink id ID 1285464.1) we have changed the parameter deferred_segment_creation=FALSE. But the problem is not solved.

The same application was running very fine at 10g without any concurrency issue.If you have faced any problem like this and if you have any opinion on this,please help me. It's very urgent for us.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2012

Added on Aug 1 2012

#11gr2, #general-database-discussions, #in, #of, #parameter

8 comments

2,461 views