ORA-08177: Cannot serialize access for this transaction

ysweec · Post by **ysweec** » Thu Jul 08, 2004 3:29 am

Hi All,

I'm using ORAOCI8 stage(Transaction Isolation= Read-Only) to retrieve data from 2 tables and getting the following error msg:-
ORA-08177: Cannot serialize access for this transaction
Is it something to do with the Transaction Isolation setting?
Should I set it to 'Serializable' or 'Read Committed'?

Regards,
Swee Chin

chulett · Post by **chulett** » Thu Jul 08, 2004 6:14 am

Yes, this is a result of your Transaction Isolation setting. Change it back to the default of 'Read Commited'.

Going to a command line and issuing 'oerr ORA 08177' may help explain what's going on and then again it may not. Many of the error message descriptions there are blank, for some silly reason.

Google will turn up some hits for it I'm sure, or if you are really curious, have a chat with your DBA.

roy · Post by **roy** » Thu Jul 08, 2004 6:53 am

Hi,
welcome to this "amusing" error select membership

well this could be caused by a conflict of read/write on the same resource.
in addition it might be resolved by tuning oracel configuration (I can't recall the exact name of this elusive one

)
how ever the official oracel documentaion says that if this happens simply rerun your query

.

that is all I can remeber on this specific error.

IHTH,

chulett · Post by **chulett** » Thu Jul 08, 2004 6:59 am

There is an init.ora parameter that enables SERIALIZABLE transactions and which must be set before you have any hope of this option working correctly. Other than that... could be a number of things.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 08, 2004 4:56 pm

The Oracle error codes manual contains not only the meaning of each error code but also, in most cases, suggested remedial action. It's worth having nearby when you're working with Oracle.

ysweec · Post by **ysweec** » Thu Jul 08, 2004 9:10 pm

Thanks all for the guidance!