java.rmi.RemoteException: ORA-00955: name is already used by

We are getting this error when trying rebuild domain index which uses jchem in another database on the same machine. This works perfectly fine in other database on the same machine.





The question here is how JchemServer handles multiple oracle instances on the same server?








CREATE INDEX CCDIII.IXJC_SALT_SMILES ON CCDIII.SALT_SOLVATE_DICTIONARY


(SALT_SOLVATE_SMILES)


INDEXTYPE IS JCHEM.JC_IDXTYPE


PARAMETERS('TABLESPACE=Indx_CCDIII')





ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine


ORA-29532: Java call terminated by uncaught Java exception: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:


java.rmi.RemoteException: ORA-00955: name is already used by an existing object


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 64


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 17

One JChem Server instance handles one Oracle instance. For a second Oracle instance, setup a second JChem Server instance:





1. Create a copy of the JChem package in a different directory


2. Configure JChem Server in this second JChem directory for the second Oracle instance


==> Change the jchem.server.port property so that it be different from the first JChem Server instance.


3. Setup JChem Cartridge in the second Oracle instance making sure that the jchem.server.port for the second JChem Server is configured.





Peter

Thanks. It is working.





There are some invalid objects in JCHEM schema (see the attachment)

Those are Java classes which are not used in Oracle anyway. Their being invalid should cause no problem in itself.





Peter