After migration of application server from 10g AS R2 to Forms Fusion Middleware 11.1.2 and database from 10.2.0.3 to 220.127.116.11 .
Forms are 10g forms compiled on the 11against the 11g database
Running on X64 Windows server 2008r2
Application is rinning fine but we are randomly getting QMS-00100 and ORA-06508 errors.
Despite of compiling library’s and packages repeatedly.
All forms and packages compiled in following order:
No compilation errors are detected.
There are no invalid objects.
While using the application we receive at random QMS-00100 and ORA-06508 errors. After closing the form and reopening the form the errors disappear mostly.
Different users providing the same actions, one gets errors, another user has no problems.
Oracle support suggested Note 1170133.1 : "ORA-06508 Error Raised When Closing Called Form with Attached Libraries" could be a simular problem.
In Note 1170133.1 is advised to install patch 11741170.
The most recent replacement for this patch is 13354162.
In the patch 13354162 readme I read:
Ensure that your Oracle Database installation is the same release for which you are applying this patch. In other words, only apply the Release 18.104.22.168 Bundle patch to an Oracle Database Release 22.214.171.124
We are running 11.1.2.
Is this patch compatible with our version?
Could this solve the problem
Headstart is a Designer product. there was a seperate forum but that forum has been moved to the archived forums? So I think this is the correct forum to ask the question.
When I ran into an ORA-06508 error message, it came across the message when is something wrong with the order of my attached library. Everything compiled fine, everything was valid but somehow I had to move the order of the attached library inside my form.
Also check when you recompile the forms that everything inisde the form is recompile. I had to add an option (compile_all=yes) to the frmcmp statement to be sure the form was completely recompiled.