Tuesday, November 4, 2014

OIM Upgrade: Database MDS Upgrade Issue:

Error:
[2014-11-04T18:37:57.138-05:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine] SQLException: ORA-20005: object statistics are locked (stattype = ALL)[[
ORA-06512: at "SYS.DBMS_STATS", line 3683
ORA-06512: at "SYS.DBMS_STATS", line 4516
ORA-06512: at "SYS.DBMS_STATS", line 11564
ORA-06512: at line 10

]]
[2014-11-04T18:37:57.138-05:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine] [[
java.sql.SQLException: ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 3683
ORA-06512: at "SYS.DBMS_STATS", line 4516
ORA-06512: at "SYS.DBMS_STATS", line 11564
ORA-06512: at line 10

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
                at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
                at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
                at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
                at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
                at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)


Solution: 

exec dbms_stats.unlock_schema_stats('QA_MDS'); 
exec dbms_stats.unlock_schema_stats('SYS'); 
exec dbms_stats.unlock_table_stats('QA_MDS','MDS_TXN_LOCKS');

commit; 

No comments:

Post a Comment

Other Posts