We are upgrading from Oracle 11g to 12c. On a new VM machine in Microsoft Azure.
Some apps might stop Chrome from working properly. On your computer, open Chrome. At the top right, click More Settings.; At the bottom, click Advanced.; Under 'Reset and clean up,' click Update or remove incompatible applications. If you don’t see this option, there isn’t a problem application. Please remember to mark the replies as answers if they help and un-mark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact [email protected].
On a specific call on our Website C#, visually nothing seems to happen, but we are expecting a PDF to be generate. We got no error on the screen, but all our sessions variables are lost. So I suspected a IIS Pool Crash that restart itself.
In the EventViewer we have 4 entries:
After a lot of tuning and testing I activated the Oracle Tracing. Where I suspect a Wrong Connection Close before a DataReader Dispose.
JudgeProphet
JudgeProphetJudgeProphet
1 Answer
Finally, we add a problem with the way we were closing our DB Connection.
![]()
For some reason Oracle 11 doesn't care but 12c ask for more.
It's seem that somewhere we were mishandling the connection, so we revised our entire source for refactoring our code. We use 'Using Clause', Try/Catch/Finally, add Close() and Dispose() instruction if necessary (and remove some when not needed).
We also add Pool parameters on our connectionString for better pool management.
All of that fix our problem.
JudgeProphetJudgeProphet
Not the answer you're looking for? Browse other questions tagged c#databaseoracleoracle12c or ask your own question.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |