error ora-29879

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

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

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

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

 

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

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

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

Peter,

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

Sincerely,

Derek