error in writing clob

[attilio_1]

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

[Eric Antunes]

Hi Attilio,

This error is with the OC4J instance or with another?

Best Regards,

Eric Antunes

[Yogeeraj_1]

hi,

your environment has most probably changed.

can you check your CLASSPATH?

regards
yogeeraj

[attilio_1]

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]

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]

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

[attilio_1]

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]

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

[attilio_1]

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]

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