Another Upgrade to 5.5 problem

User 5d01fe091c

01-06-2011 13:21:16

Hi,


I'm upgrading from 5.3.8 to 5.5.0.1 on Oracle 10g and I am getting the following error:


You have entered the following parameters:
==========================================


The path to the home directory of the old JChem version: /apps/chemaxon/jchem/5.3.8.0/
Name of the Oracle host.: localhost
Oracle listener port: 1521
Name of the Oracle instance: dbtst
DBA login: SYS AS SYSDBA
Name of the cartridge owner: jchem
The host name of the JChem Server: localhost
The port at which the JChem Server accepts connections: 1098
maximum memory allocated to the JChem Server process: 1500m
Local TNS name of the Oracle instance.: dbtst
Do you want to use a role for basic JChem Cartridge user privileges? (This role will be granted to jchem WITH ADMIN OPTION. See http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9013.htm#sthref8967): y
The role for basic JChem Cartridge user privileges: jchem_role
Staging schema for the version: JCC_UPGR_STAGE
Rebuild jc_idxtype indexes: all


Proceed with the Upgrade? (y,n) [n]: y
INFO: Setting up staging schema...
INFO: Populating the staging schema with the objects of the new JChem Cartridge version...
INFO: Loading jar file /apps/chemaxon/jchem/5.5.0.1/cartridge/jcart.jar into JCC_UPGR_STAGE's schema...
INFO: Loading PL/SQL script /apps/chemaxon/jchem/5.5.0.1/cartridge/jchem_cart.sql_i into JCC_UPGR_STAGE's schema...
INFO: Loading PL/SQL script /apps/chemaxon/jchem/5.5.0.1/cartridge/jchem_util.sql into JCC_UPGR_STAGE's schema...
INFO: Loading PL/SQL script /apps/chemaxon/jchem/5.5.0.1/cartridge/jchem_opti.sql into JCC_UPGR_STAGE's schema...
INFO: Loading PL/SQL script /apps/chemaxon/jchem/5.5.0.1/cartridge/idx_analyse.sql into JCC_UPGR_STAGE's schema...
INFO: Loading PL/SQL script /apps/chemaxon/jchem/5.5.0.1/cartridge/privman.sql into JCC_UPGR_STAGE's schema...
INFO: Building schema model for JCC_UPGR_STAGE...
INFO: Building schema model for JCHEM...
INFO: Preparing upgrade of JChem Cartridge in JCHEM based on JCC_UPGR_STAGE...
INFO: Skipping dropping sequence JCHEMIDX_SEQ
INFO: Upgrade plan has been stored in /apps/chemaxon/jchem/5.5.0.1/cartridge/upgrade-plan.txt
INFO: Verifying schema objects...
INFO: Schema objects verified.
INFO: Loading jar file /apps/chemaxon/jchem/5.5.0.1/cartridge/jcart.jar into jchem's schema...
INFO: Dropping staging schema...
SEVERE: Sql failed: call jchem.privman_pkg.grants_on_jcobjs('jchem', 'SYS AS SYSDBA')
INFO: Using classpath: /apps/chemaxon/jchem/5.5.0.1/lib/jchem.jar
INFO: Connecting to localhost:1098
AdminImpl: shutdown called...
INFO: shutdown called
Exiting...
INFO: Server process stop-ed.
SEVERE: error
java.sql.SQLException: ORA-00933: SQL command not properly ended
ORA-06512: at "JCHEM.PRIVMAN_PKG", line 40
ORA-06512: at "JCHEM.PRIVMAN_PKG", line 77
ORA-06512: at "JCHEM.PRIVMAN_PKG", line 46


        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
        at chemaxon.jchem.cartridge.install.schema.Schema.executeSql(Schema.java:483)
        at chemaxon.jchem.cartridge.install.schema.Schema.executeSqls(Schema.java:452)
        at chemaxon.jchem.cartridge.install.Installer.grantBasicJccPrivilegesByJCartOwner(Installer.java:330)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.rebuildIndices(UpgradeCmdLine.java:475)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:338)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.interactiveUpgrade(UpgradeCmdLine.java:98)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.upgrade(UpgradeCmdLine.java:52)
        at chemaxon.jchem.cartridge.install.UpgradeCmdLine.main(UpgradeCmdLine.java:689)


not sure why its trying to grant on jcobjs to sys?


cheers Ian


 

ChemAxon aa7c50abf8

01-06-2011 17:30:17

Ian,


This looks like a bug in JChem Cartridge. It will be fixed ASAP.


The upgrade at this point is basically complete, only index rebuild/upgrade needs to be performed. You can either upgrade the indices manually ( ALTER INDEX <index-name> REBUILD PARAMETERS('upgradeOnly=y') ), or (probably the easiest) you can repeat the upgrade using SYSTEM instead of SYS (who has normally less privileges than SYS AS SYSDBA anyway).


not sure why its trying to grant on jcobjs to sys?

I am not sure either. :-) I've found (at least when testing with SYSTEM) that the DBA needs the same (? or similar) privileges as other JChem Cartridge users do. I will double check this, though -- perhaps only some privileges/permissions are required (perhaps only the SocketPermission for connecting to the JChem Cartridge server)...perhaps SYS doesn't require any.

User 5d01fe091c

01-06-2011 22:26:40

Thanks for the quick reply, Peter!  Using SYSTEM seems to have made it work.