My Oracle Support Banner

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

Last updated on JANUARY 29, 2022

Applies to:

Oracle Lite - Version to [Release 10.0 to 10.3]
Information in this document applies to any platform.


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.