11.5.10.2 : Invalid object FG_RESPONSETIME_PCHART found under sys schema after we ran utlu112i.sql
Hi,
We found an object(FG_RESPONSETIME_PCHART) invalid under sys schema in the log which was generated by Pre-Upgrade Information Tool(utlu112i.sql),while we are upgrading from 11.2.0.2 to 11.2.0.3.When we tried compiling,it throws an error saying that table or view doesn't exist.
Please find the error in error codes.
Error Codes
---------------------------------------------------
21/3 PL/SQL: SQL Statement ignored,22/163 PL/SQL: ORA-00942: table or view does not exist
object SYS.FG_RESPONSETIME_PCHART in invalid state,Upon checking its found that table sys.oraconf_fg_events is missing that caused procedure SYS.FG_RESPONSETIME_PCHART to go invalid.
We found an object(FG_RESPONSETIME_PCHART) invalid under sys schema in the log which was generated by Pre-Upgrade Information Tool(utlu112i.sql),while we are upgrading from 11.2.0.2 to 11.2.0.3.When we tried compiling,it throws an error saying that table or view doesn't exist.
Please find the error in error codes.
Error Codes
---------------------------------------------------
21/3 PL/SQL: SQL Statement ignored,22/163 PL/SQL: ORA-00942: table or view does not exist
object SYS.FG_RESPONSETIME_PCHART in invalid state,Upon checking its found that table sys.oraconf_fg_events is missing that caused procedure SYS.FG_RESPONSETIME_PCHART to go invalid.
Tagged:
0