My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2020

Applies to:

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


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(
at oracle.jdbc.ttc7.TTIoer.processError(
at oracle.jdbc.ttc7.Oall7.receive(
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(
at oracle.jdbc.driver.OracleStatement.executeNonQuery(
at oracle.jdbc.driver.OracleStatement.doExecuteOther(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeUpdate(
at upgrade102020To102021MiniPack.main(


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

The repwizard was ran against the SYSTEM or MOBILEADMIN user.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.