ORA-06598 obtained during install process of JchemCartridge

Hi,

i'm trying to install JchemCartridge 14.11.3.0 with oracle 12.1.0.

 

I have this following error : 

 

Proceed with the Install? (y, n) [n]: y

INFO: Setting up schema SYSADMIN

INFO: create role JCC_BASIC_ROLE

INFO: call dbms_java.grant_permission('JCC_BASIC_ROLE', 'SYS:java.net.SocketPermission', 'localhost:1099', 'resolve,connect')

INFO: grant JCC_BASIC_ROLE to SYSADMIN with admin option

INFO: Checking JChem Server at localhost:1099...

INFO: Loading jar file /usr/jchem/lib/com.chemaxon-jchem-cartridge-oraresident.jar into SYSADMIN's schema...

INFO: Loading jar file /usr/jchem/lib/com.chemaxon-jchem-cartridge-shared.jar into SYSADMIN's schema...

INFO: Loading jar file /usr/jchem/lib/com.chemaxon-jchem-cachereg-common.jar into SYSADMIN's schema...

INFO: Loading jar file /usr/jchem/lib/com.chemaxon-jchem-persist-common.jar into SYSADMIN's schema...

INFO: Building schema model for SYSADMIN...

INFO: Verifying schema objects...

INFO: Schema objects verified.

INFO: Testing with user SYSADMIN...

INFO: Using chemaxon.jchem.cartridge.util.cpool.Oracle10gDataSource

INFO: JDBC driver version: 11.2.0.3.0

INFO: Test OK!

SEVERE: error

java.sql.SQLException: ORA-06598: privilège INHERIT PRIVILEGES insuffisant

ORA-06512: Ã  "SYSADMIN.PRIVMAN_PKG", ligne 1

 

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)

        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)

        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)

        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)

        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)

        at chemaxon.jchem.cartridge.install.schema.Schema.executeSql(Schema.java:654)

        at chemaxon.jchem.cartridge.install.Installer.createPublicSynonyms(Installer.java:458)

        at chemaxon.jchem.cartridge.install.Installer.install(Installer.java:93)

        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLine.java:153)

        at chemaxon.jchem.cartridge.install.InstallCmdLine.install(InstallCmdLine.java:136)

        at chemaxon.jchem.cartridge.install.InstallCmdLine.main(InstallCmdLine.java:589)

java.io.IOException: Stream closed

+ set +x

Hi,

 

Generally this error means that there is a missing privilege for granting the JCC_BASIC_ROLE to SYSADMIN (the JChem owner).

 

In case of using install.sh/install.bat:

This error shows that the DB admin provided during install does not have the privilege to grant roles to the jchem owner (SYSADMIN) given by you. Please make sure, you have provided a dba user/password that has the right to grant roles.

 

If you are running the install in non-DBA mode (see: https://docs.chemaxon.com/display/jchemcartridge/Installation+and+administration+of+JChem+Cartridge+for+Oracle#InstallationandadministrationofJChemCartridgeforOracle-install_wo_dba ), please check that you have succeed with all the Pre-installation tasks (especially step 4).

 

Best regards,

Norbert

Hi Nobert,

 

I run before the installation of Jchemcartridge : ./config-util.sh list-dba-sqls

SQL>  connect sys/[email protected] as sysdba

Connected.

SQL> create user SYSADMIN identified by mdp;

 

User created.

 

SQL> GRANT unlimited tablespace to SYSADMIN;

 

Grant succeeded.

 

SQL>  GRANT create session to SYSADMIN;

 

Grant succeeded.

 

SQL> GRANT create table to SYSADMIN;

 

Grant succeeded.

 

SQL>  GRANT create sequence to SYSADMIN;

 

Grant succeeded.

 

SQL>  GRANT create procedure to SYSADMIN;

 

Grant succeeded.

 

SQL> GRANT create trigger to SYSADMIN;

 

Grant succeeded.

 

SQL> GRANT create type to SYSADMIN;

 

Grant succeeded.

 

SQL> GRANT create operator to SYSADMIN;

 

Grant succeeded.

 

SQL>  GRANT create indextype to SYSADMIN;

 

Grant succeeded.

 

SQL>  call dbms_java.grant_permission('SYSADMIN', 'SYS:java.net.SocketPermission', '195.220.11.171:1099', 'resolve,connect');

 

Call completed.

 

SQL> create role JCC_BASIC_ROLE;

 

Role created.

 

SQL> call dbms_java.grant_permission('JCC_BASIC_ROLE', 'SYS:java.net.SocketPermission', '195.220.11.171:1099', 'resolve,connect');

 

Call completed

 

SQL> grant JCC_BASIC_ROLE to SYSADMIN with admin option;

 

Grant succeeded.

 

SQL> exit

Hi, 

could you reproduce the same error? I try with the last release 11.11.10.0 and i have the same error

this error line is strange : INFO: Using chemaxon.jchem.cartridge.util.cpool.Oracle10gDataSource

whereas the release of my oracle database is 12.1.

 

 

error obtained : 

 

 

Do you want a role for basic JChem Cartridge user privileges to be created? (This role will be granted to SYSADMIN WITH ADMIN OPTION. DataVault users, please, answer with "n"): y

The role for basic JChem Cartridge user privileges: JCC_BASIC_ROLE

Do you want public synonyms to be created?: y

 

Proceed with the Install? (y, n) [n]: y

INFO: Using chemaxon.jchem.cartridge.util.cpool.Oracle10gDataSource

INFO: JDBC driver version: 11.2.0.3.0

java.sql.SQLException: ORA-06598: privilège INHERIT PRIVILEGES insuffisant

ORA-06512: Ã  "SYSADMIN.PRIVMAN_PKG", ligne 1

Hi Kiet,

 

Thanks for the news!

Regarding the issue, I wrote to your registered e-mail offering you a TC as it would be much faster than discussing it in writing.

 

What is your feeling on this?

 

Berst regards,

Norbert.

the last release i tried is 14.11.10.0

what is TC?

 

Hi Kiet,

 

I am terribly sorry for the slang, TC stands for teleconference. We can have it using GoToMeeting or skype or hangout, or other software alike; let me know your preference.

 

Al the bests,

Norbert

I will try skype tonight and will contact you tomorrow if skype runs correctly.

If yes, we can plan a skype talk tomorrow afternoon?

 

Best regards, 

 

Kiet

hi Norbert,

on my laptop, skype is running well.

could you give me your skype name?

Hi Kiet,

 

I've sent it to your registered mail address.

Talk to you soon.

Norbert

Hi Kiet,

 

I am closing this thread as we solved the problem during our skype call (thank you for being so open on it).

The lesson learned is that only the DBA user name should be inserted in line:

DBA login [SYSTEM]:

 

Norbert