FMW Upgrade Issues From 12.2.1.3 To 12.2.1.4 (Doc ID 2810746.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

Below error seen in ua.log

[2021-09-27T11:36:18.531+02:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 85] [ecid: c1dc3959-8e28-4e5d-8ed6-64fcad462f6d-00000002,0] [[
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:271)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:92)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:971)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3719)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1427)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3831)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1082)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1277)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:936)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:955)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:930)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:713)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1790)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1693)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1603)
at oracle.ias.update.plugin.UpgradeJDBCEngine.execute(UpgradeJDBCEngine.java:192)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:1902)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:1792)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra_one_patchset(SOAINFRAPlugin.java:649)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade_soainfra(SOAINFRAPlugin.java:518)
at oracle.ias.update.plugin.soa.SOAINFRAPlugin.upgrade(SOAINFRAPlugin.java:395)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:730)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:736)
at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:775)
at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:382)
at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1178)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 1031, Position : 20, Sql = GRANT SELECT ON sys.DBA_TABLESPACE_USAGE_METRICS to FMW2DEV_SOAINFRA
, OriginalSql = GRANT SELECT ON sys.DBA_TABLESPACE_USAGE_METRICS to FMW2DEV_SOAINFRA
, Error Msg = ORA-01031: insufficient privileges

Cause

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