cancel
Showing results for 
Search instead for 
Did you mean: 

error in writing clob

attilio_1
Frequent Advisor

error in writing clob

Hello,

there is a problem on a java application when it try to insert a clob data.
The error is
java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:292)
at oracle.sql.CLOB.createTemporary(CLOB.java:525)
...
This problem didn't happen until yesterday.
What is changed is the creation of a new instance of OC4J and after a shutdown ad a restart of oracle.
Any idea ?
Thanks in advance
Attilio
13 REPLIES
Eric Antunes
Honored Contributor

Re: error in writing clob

Hi Attilio,

This error is with the OC4J instance or with another?

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: error in writing clob

hi,

your environment has most probably changed.

can you check your CLASSPATH?

regards
yogeeraj




No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
attilio_1
Frequent Advisor

Re: error in writing clob

Hi Eric

Yes is with the OC4J instance on unix.
If I use tomcat (from the PC ), with the same oracle db on unix, it works.

Is possible that use a port of another service ?

Attilio
attilio_1
Frequent Advisor

Re: error in writing clob

Hi,

The classpath in OC4J profile is
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip, but is not changed. I have installed another instance of OC4j and a ldap iplanet.
Perhaps some service use the same port ?
I have read that clob use oci driver.
wont other library ?

Thanks
Attilio
Eric Antunes
Honored Contributor

Re: error in writing clob

Hi Attilio,

OC4J is the diminutive of OracleAS Containers for J2EE.

If I understood you ADDED another instance and, because of that, you may be facing bug 3009532 (MEMORY LEAK):

https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=4232279

What is your RDBMS version??

Best Regards,

Eric
Each and every day is a good day to learn.
attilio_1
Frequent Advisor

Re: error in writing clob

Hello Eric,

yes I added another instance of OC4J, setting with different port, and a iplanet ldap. I don't know if this is the reason of the failure.
The version of oracle is 8.1.7.2

best regards
Attilio
Eric Antunes
Honored Contributor

Re: error in writing clob

Hi Attilio,

What is the server's physical memory and Oracle init.ora parameters shared_pool_size and db_block_buffers?

Please attach the vmstat.log resulting from:

#vmstat -n 6 33 > vmstat.log

Best Regards,

Eric
Each and every day is a good day to learn.
attilio_1
Frequent Advisor

Re: error in writing clob

Hi Eric

shared_pool_size = 52428800
db_block_buffers = 2048

in the server there are 4 gb of ram.
but there are also other two instance of oracle, clearcase server, lpdap server that use it.

in attach there is the output of vmstat command;

best regards
Attilio
Eric Antunes
Honored Contributor

Re: error in writing clob

Hi Atillio,

As a test, reduce all instances shared_pool_size to 256M (stop & restart them) and check if this issue continues to happen...

Regards,

Eric Antunes
Each and every day is a good day to learn.
attilio_1
Frequent Advisor

Re: error in writing clob

Hi Eric,

I have done this test, increasing the shared_pool_size of the instance in which there is the problem to 256M (before was 52M ), and stopping the others, but the result was the same.

But the same application run from a pc with tomcat installed, that go to the same oracle db on unix. So the problem seem to be in oc4j configuration, do you agree ?

best regards
Attilio
Eric Antunes
Honored Contributor

Re: error in writing clob

Attilio,

Yes, I agree, specially if this happens all the time. Is it reproducible EVERY TIME or you just can reproduce it SOMETIMES?

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
attilio_1
Frequent Advisor

Re: error in writing clob

Hi Eric,

It happens every time, but only since two days ago.The developers said that it runs before two days ago. Two days ago, after the installation of the other instance of oc4j and of ldap server I made a restart of all instances of oracle. But it seems that nothing has changed in the old oc4j.


best regards
Attilio
attilio_1
Frequent Advisor

Re: error in writing clob

Hi

the problem is resolved.
It was needed change classes12dms.jar library in oc4j/jdbc/lib/ .

Thanks
Attilio