Java.sql.SQLException: ORA-01031 When Upgrading The Oracle Lite Repository (Doc ID 561245.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Lite - Version 10.0.0.1.0 to 10.3.0.3.0 [Release 10.0 to 10.3]
Information in this document applies to any platform.
***Checked for relevance on 19-July-2013***


Symptoms

When upgrading the mobile server repository via Repwizard, received the following error 

"User SYSTEM does not have required privileges"

Exception in thread "main" java.sql.SQLException: ORA-01031: insufficient privileges

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1839)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1764)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2354)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:858)
at upgrade102020To102021MiniPack.main(upgrade102020To102021MiniPack.java:46)

Changes

The error can be reproduced by running Repwizard.sh  (or Repwizard.bat on MS Windows) located  in $OH/Mobile/Server/Admin.

The repwizard was ran against the SYSTEM or MOBILEADMIN user.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms