error ora-29879

User 369425e3ae

21-09-2010 18:22:31

I am trying to create and index a new db and finally got the cartridge installed.  Now I am geting this message.  I checked an there isn't column of type jc_idx in this table.  Any ideas?


 


Thank you,


Derek


SQL> CREATE INDEX jc_idx ON cbis.cheminfotable(molstructure) INDEXTYPE IS jchem.
jc_idxtype;
CREATE INDEX jc_idx ON cbis.cheminfotable(molstructure) INDEXTYPE IS jchem.jc_id
xtype
                                          *
ERROR at line 1:
ORA-29879: cannot create multiple domain indexes on a column list using same
indextype

User 369425e3ae

21-09-2010 20:28:45

It looks like in my previous attempt to index the table a jc_idx index was created, so I deleted it and now am getting:


ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20104: Default user not set
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 34
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 26


If I understand corretly the 29855 error means I am missing a permission.  Does that make sense?


Thanks,


Derek

ChemAxon aa7c50abf8

22-09-2010 11:06:11

Derek,


This is JChem Server wanting to connect back to Oracle and failing to find the suitable login and password. There are two (not mutually exclusive) mechanism for this. Please, see the 



User credentials and privileges for JChem Server section of the JChem Cartridge Administration Guide:



 http://www.chemaxon.com/jchem/doc/admin/cartridge.html#jcserver_dbaccess_credentials .


Peter

User 369425e3ae

22-09-2010 15:12:51

Peter,


Yes, I confirmed that the JCHEM account has those permissions and I added the oracle login and password parameters.


I found that with the ooracle login parameters set I get a different error:


call jchem_core_pkg.use_password('XYZ')
     *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.rmi.NoSuchObjectException: no such object in table
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 54
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 55


So progress.


Sincerely,


Derek


 

ChemAxon aa7c50abf8

22-09-2010 15:18:11

Derek,


java.rmi.NoSuchObjectException: no such object in table

You might be using a stale database session, which survived a JChem Server restart. I suggest trying the same in a freshly opened database session.


Regards,


Peter

User 369425e3ae

22-09-2010 15:28:49

Peter,


Thank you that was a good idea.  I closed SQL Plus and stoped and restarted the server.  Now I get:


call jchem_core_pkg.use_password('XXX')
     *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.rmi.ServerException: RemoteException occurred in server thread; nested
exception is:
java.rmi.RemoteException: Problem connecting to the followingJDBC URL:
jdbc:oracle:thin:@bimr-pipeline1.burnham.org:1521:demo1: ORA-28009: connection
as SYS should be as SYSDBA or SYSOPER
. Please, check the JDBC connection properties of the JChem Server.
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 54
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 55


Derek

ChemAxon aa7c50abf8

22-09-2010 15:35:58

Derek,


If you don't have any particular reason using SYS, I suggest to use SYSTEM instead as a privileged user to avoid the SYSDBA/SYSOPER qualification problems.


Let me know if this helps.


Regards,


Peter

User 369425e3ae

22-09-2010 16:03:00

Peter,


Thank you SYSTEM worked.  I guess something in the as SYSDBA bit wasn't working for SYS.


Sincerely,


Derek