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