[opencms-dev] OpenCms 5.3.5 on Oracle : installationproblems

[Alexander Kandzior]

Hi,

regarding this Oracle open cursor issue:

Can anyone confirm that this is an issue with the setup only, or does your
systems require such a large number of cursors also for running OpenCms
after setup is finished. 

I'm pretty sure we try to close all connections we open. On the other hand
we use the DBCP connection pool. Maybe this is an issue there.

Any help in finding and resolving this issue is greatly appreciated. I
certainly want this fixed for a 6.0 release candidate status. 

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

> -----Original Message-----
> From: opencms-dev-admin at opencms.org 
> [mailto:opencms-dev-admin at opencms.org] On Behalf Of SIMON DUTIL
> Sent: Thursday, August 05, 2004 5:31 PM
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] OpenCms 5.3.5 on Oracle : 
> installationproblems
> 
> 
> Hi Tristan,
> 
> With version 5.3.5, we had to increase the maximum open 
> cursors to 3000 to fix the problem...but with version 5.3.6 
> its not enough !!! ( normally, we set maximum open cursor to 
> 300 )...there's for sure connection that arent close during 
> workspace importation...I will probably run out of memory soon!
> 
> Have you installed version 5.3.6 yet?
> If so, have you increased maximum open cursors value (to more than
> 2500) when you installed it?
> 
> Thanks,
> 
> Simon
> 
> >>> ttarrant at etnoteam.it 04/08/2004 11:58 >>>
> We had the same problem, and I'm afraid I don't have a real 
> solution for it. We increased the maximum open cursors for 
> Oracle to 2500 and it worked, but obviously this is just a cop-out.
> 
> Tristan
> 
> > Im having problems deploying opencms on our server.
> > 
> > I get this error, in the setup wizard, during import and publish :
> > 
> > 459:	ORA-06512: at line 1
> > 458:	ORA-06512: at "SYS.DBMS_LOB", line 521
> > 457:	ORA-01000: maximum open cursors exceeded
> > 
> > My server configuration :
> > 
> > JDK version:  	1.4.2_03  	 
> > Servlet engine: 	Oracle Application Server Containers for J2EE
> > 10g (9.0.4.0.0) 	 
> > Operating system: 	Windows XP 5.1 	 
> > XML Parser: 	Xerces-J 2.6.2 	 
> > Database:               Oracle 9i release 2
> > 
> > Any help would be greatly appreciated!
> > 
> > Simon
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please
> visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev>
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 
>