maximum open cursors in oracle required for running ofbiz

[sudheer baddam]

Hi,
    I working on an older version of OFBiz released in 2006. Everytime I start  the server I am getting the below error message. I tried increasing maximum open_cursors in my oracle database to 1000. Even then I have this error.
   Can anyone please suggest what is the minimum open_cursors required for ofbiz to operate?

[java] 2008-07-08 10:03:19,926 (main) [       DatabaseUtil.java:1194:ERROR] Error getting column meta data for Error was:java.sql.SQLException: ORA-01000: maximum open cursors exceeded
     [java] . Not checking columns.
     [java] 2008-07-08 10:03:19,926 (main) [       DatabaseUtil.java:345:WARN ] Entity [CaHostingDetails] has no table in the database
     [java] 2008-07-08 10:03:19,926 (main) [       DatabaseUtil.java:353:ERROR] Could not create table [OFBIZ_PROD.CA_HOSTING_DETAILS]: SQL Exception while executing the following:
     [java] CREATE TABLE OFBIZ_PROD.CA_HOSTING_DETAILS (COMPANY_ACCOUNT_ID VARCHAR2(20) NOT NULL, DOMAIN_ID VARCHAR2(255), USER_LOGIN_URL VARCHAR2(255), COMPANY_NAME VARCHAR2(255), DELIVERY_METHOD VARCHAR2(255), LAST_UPDATED_USER_LOGIN_ID VARCHAR2(255), LAST_UPDATED_STAMP TIMESTAMP, LAST_UPDATED_TX_STAMP TIMESTAMP, CREATED_STAMP TIMESTAMP, CREATED_TX_STAMP TIMESTAMP, CONSTRAINT PK_CA_HOSTING_DETAILS PRIMARY KEY (COMPANY_ACCOUNT_ID))
     [java] Error was: java.sql.SQLException: ORA-01000: maximum open cursors exceeded


Thanks,
Sudheer

[Vince Clark]

This is an Oracle issue, not OfBiz.

Increasing max open cursors to 1000 is the right move. But I believe there is another parameter you need to change as well. I cannot remember it off hand, but I think it is related to the number of connections allowed. I believe changing these parms requires restarting the db to take effect. Do a web search on the error message. I'm sure you will find plenty of answers.

----- Original Message -----
From: "sudheer baddam" <[hidden email]>
To: [hidden email]
Sent: Tuesday, July 8, 2008 8:24:22 AM (GMT-0700) America/Denver
Subject: maximum open cursors in oracle required for running ofbiz

Hi,
I working on an older version of OFBiz released in 2006. Everytime I start the server I am getting the below error message. I tried increasing maximum open_cursors in my oracle database to 1000. Even then I have this error.
Can anyone please suggest what is the minimum open_cursors required for ofbiz to operate?

[java] 2008-07-08 10:03:19,926 (main) [ DatabaseUtil.java:1194:ERROR] Error getting column meta data for Error was:java.sql.SQLException: ORA-01000: maximum open cursors exceeded
[java] . Not checking columns.
[java] 2008-07-08 10:03:19,926 (main) [ DatabaseUtil.java:345:WARN ] Entity [CaHostingDetails] has no table in the database
[java] 2008-07-08 10:03:19,926 (main) [ DatabaseUtil.java:353:ERROR] Could not create table [OFBIZ_PROD.CA_HOSTING_DETAILS]: SQL Exception while executing the following:
[java] CREATE TABLE OFBIZ_PROD.CA_HOSTING_DETAILS (COMPANY_ACCOUNT_ID VARCHAR2(20) NOT NULL, DOMAIN_ID VARCHAR2(255), USER_LOGIN_URL VARCHAR2(255), COMPANY_NAME VARCHAR2(255), DELIVERY_METHOD VARCHAR2(255), LAST_UPDATED_USER_LOGIN_ID VARCHAR2(255), LAST_UPDATED_STAMP TIMESTAMP, LAST_UPDATED_TX_STAMP TIMESTAMP, CREATED_STAMP TIMESTAMP, CREATED_TX_STAMP TIMESTAMP, CONSTRAINT PK_CA_HOSTING_DETAILS PRIMARY KEY (COMPANY_ACCOUNT_ID))
[java] Error was: java.sql.SQLException: ORA-01000: maximum open cursors exceeded


Thanks,
Sudheer

[Ashish Vijaywargiya]

Google is the best place to search this kind of error but if you would like
to see the
discussion on Ofbiz Mailing list on something similar topic then Nabble and
Markmail will be your friend.

Please give a try on following two links :-
http://www.nabble.com/OFBiz-f2740.html

&

http://ofbiz.markmail.org/

--
Ashish

On Tue, Jul 8, 2008 at 9:57 AM, Vince M. Clark <[hidden email]> wrote:

> This is an Oracle issue, not OfBiz.
>
> Increasing max open cursors to 1000 is the right move. But I believe there
> is another parameter you need to change as well. I cannot remember it off
> hand, but I think it is related to the number of connections allowed. I
> believe changing these parms requires restarting the db to take effect. Do a
> web search on the error message. I'm sure you will find plenty of answers.
>
> ----- Original Message -----
> From: "sudheer baddam" <[hidden email]>
> To: [hidden email]
> Sent: Tuesday, July 8, 2008 8:24:22 AM (GMT-0700) America/Denver
> Subject: maximum open cursors in oracle required for running ofbiz
>
> Hi,
> I working on an older version of OFBiz released in 2006. Everytime I start
> the server I am getting the below error message. I tried increasing maximum
> open_cursors in my oracle database to 1000. Even then I have this error.
> Can anyone please suggest what is the minimum open_cursors required for
> ofbiz to operate?
>
> [java] 2008-07-08 10:03:19,926 (main) [ DatabaseUtil.java:1194:ERROR] Error
> getting column meta data for Error was:java.sql.SQLException: ORA-01000:
> maximum open cursors exceeded
> [java] . Not checking columns.
> [java] 2008-07-08 10:03:19,926 (main) [ DatabaseUtil.java:345:WARN ] Entity
> [CaHostingDetails] has no table in the database
> [java] 2008-07-08 10:03:19,926 (main) [ DatabaseUtil.java:353:ERROR] Could
> not create table [OFBIZ_PROD.CA_HOSTING_DETAILS]: SQL Exception while
> executing the following:
> [java] CREATE TABLE OFBIZ_PROD.CA_HOSTING_DETAILS (COMPANY_ACCOUNT_ID
> VARCHAR2(20) NOT NULL, DOMAIN_ID VARCHAR2(255), USER_LOGIN_URL
> VARCHAR2(255), COMPANY_NAME VARCHAR2(255), DELIVERY_METHOD VARCHAR2(255),
> LAST_UPDATED_USER_LOGIN_ID VARCHAR2(255), LAST_UPDATED_STAMP TIMESTAMP,
> LAST_UPDATED_TX_STAMP TIMESTAMP, CREATED_STAMP TIMESTAMP, CREATED_TX_STAMP
> TIMESTAMP, CONSTRAINT PK_CA_HOSTING_DETAILS PRIMARY KEY
> (COMPANY_ACCOUNT_ID))
> [java] Error was: java.sql.SQLException: ORA-01000: maximum open cursors
> exceeded
>
>
> Thanks,
> Sudheer
>
>
>
>