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 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.

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

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
Symptoms
Changes
Cause
Solution

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