A change needs to be made in your Oracle instance.
ALTER SYSTEM SET open_cursors=500 SCOPE=BOTH
The value of 500 is a guess. You may need to vary this.
Andy Knight
Principal Engineer,
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road,
Camberley, Surrey GU17 9QG United Kingdom
Home office: +44 1494 462438
Mobile: +44 7775 583415
Skype: aprknight
Email: Andy.Knight_at_Sun.COM
Blog:
http://blogs.sun.com/andky
On 1 Oct 2009, at 19:50, Sigal Shaharabani wrote:
> Hello
>
> We are working with Glassfish v2ur2-b04.
>
> We are encountering a problem with Oracle JDBC connection pool – We
> receive the Oracle error ORA-01000
>
> Searching the web I noticed here http://dlc.sun.com/pdf/820-7667/820-7667.pdf
> that this is a known problem which was fixed for Liferay (search
> for [LPS-2428]
>
> Is this fix also available in any Glassfish release or patch? (or
> expected to be)
>
> Many thanks
>
> Sigal
>
>
>
> P please consider the environment - do you really need to print this
> email?
>
>