Index rebuild on 5.3.0

I have recently installed 5.3.0 (not 5.3.0.1) on Oracle 10.2.0.4 on Linux.

I am now having problems rebuilding my indexes, I have 13 jchem indexes split across varying schemas. Before the upgrade the jcserver.maxmem was set to 4000. Since the upgrade I have increased this to 10000. Everytime I build one index I have to then stop the jchem server and restart it, the next index rebuild then works.

Any ideas of what could be causing this?

Error:

SQL> select jchem_core_pkg.getenvironment from dual;

GETENVIRONMENT
--------------------------------------------------------------------------
Oracle environment:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_14
Java VM version: 14.0-b16

GETENVIRONMENT
--------------------------------------------------------------------------
JChem version: 5.3.0
JChem Index version: 5030002
JDBC driver version: 11.1.0.7.0-Production

SQL> alter index IJC_ACD_MAIN_JC_IDX1 REBUILD PARAMETERS('upgradeOnly=y');
alter index IJC_ACD_MAIN_JC_IDX1 REBUILD PARAMETERS('upgradeOnly=y')
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20101: java.lang.OutOfMemoryError: GC overhead limit exceeded
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 31
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 48

SQL>

 

 

Regards,

Rachel

Rachel,

Are you sure you set the property to 10000m as opposed to 10000? (Notice the 'm' for mega at the end.)

Thanks

Peter

That's fixed it - working fine now - thanks.