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
ORA-08177: Cannot serialize access for this transaction
Moderators: chulett, rschirm, roy
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.
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.
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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,
welcome to this "amusing" error select membership
![Sad :(](./images/smilies/icon_sad.gif)
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
![Sad :(](./images/smilies/icon_sad.gif)
how ever the official oracel documentaion says that if this happens simply rerun your query
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
that is all I can remeber on this specific error.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Idea :idea:](./images/smilies/icon_idea.gif)
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.