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 |