Wondering if anybody else has seen this issue with the GIMR -MGMTDB database after
installing 12.2 Clusterware.
From the -MGMTDB alert log:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_641"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47207
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: at "SYS.DBMS_STATS", line 47197
The fix is pretty simple from support doc id 2127675.1
I just have a gut feeling I should know more about why the database was not created properly beyond
what the document tells me. I also have an SR open on this but so far I can only get referenced to
the support document. I have not been able to see anything in DBCA logs that would help me
find why the dbms_stats.init_package() did not run successfully.
Thanks
Alan