ORA-29532 during JChem cartridge installation

User 46924c5277

16-07-2012 19:06:39

I'm trying to install the JChem cartridge on a new server, and running into a problem running the install.bat script.


Here's the last section of the output from the script:



You have entered the following parameters:


==========================================


Connection type: sid


Name of the Oracle host: localhost


Oracle listener port: 1521


Name of the Oracle database (sid): KDB


The host name of the JChem Server: localhost


The port at which the JChem Server accepts connections: 1099


maximum memory allocated to the JChem Server process: 700m


The structure cache id of this JChem Server instance: JCC1


DBA login: SYSTEM


Name of the cartridge owner: jchem


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


The role for basic JChem Cartridge user privileges: JCC_BASIC_ROLE


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


INFO: Setting up schema jchem


java.sql.SQLException: ORA-29532: Java call terminated by uncaught Java exception: java.lang.SecurityException: policy table update SYS:java.net.SocketPermission, localhost:1099


        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)


        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:590)


        at chemaxon.jchem.cartridge.install.schema.Schema.executeSqls(Schema.java:559)


        at chemaxon.jchem.cartridge.install.Installer.setupConnectJCartOwnerSchema (installer.java:221)


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


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


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


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



 


Has anyone seen this before, and if so could you make some suggestions?  I've looked in the forums and while it does seem other people are getting this same error, they appear to be getting it after the cartridge is already installed, not during the setup of the schema itself.


Thanks in advance,


Bob

ChemAxon aa7c50abf8

16-07-2012 19:33:39

Hi Bob,


I saw this error several times when users tried granting Java permissions (SocketPermissions) as regular ("unprivileged") users.


In your case, it looks like SYSTEM is trying to grant permissions. As SYSTEM normally has the required privileges, I can't think of anything else than an Oracle configuration issue.


Which Oracle version is it? Was this instance created using the default configuration? Does, in particular, SYSTEM have the JAVA_ADMIN role? (Please, see http://docs.oracle.com/cd/B19306_01/java.102/b14187/chnine.htm#BABBGAEC)


Peter