ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "from$_subquery$_006"."PARENT": invalid identifier
Changes
Applied PSU2 Patch 9162498 on top of the 10.2.0.5 Agent.
Cause
The problem is caused by the fact that the associated query used to gather the metric "GRANT ANY/SELECT
PRIVILEGES " only works on 10g or 11g databases and it fails on 9i.
There's an internal bug not visible that corresponds to the issue :
BUG 9169817 UPGRFUNC:METRIC COLLECTION RECEIVED FOR 9I DATABASE
Solution
Note: Solutions are listed in order of strength of recommendation
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=1632723052892222&type=DOCUMENT&id=1065410.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=gyfjvkxqn_271
ORA-00904: "from$_subquery$_006"."PARENT": invalid identifier
Changes
Applied PSU2 Patch 9162498 on top of the 10.2.0.5 Agent.
Cause
The problem is caused by the fact that the associated query used to gather the metric "GRANT ANY/SELECT
PRIVILEGES " only works on 10g or 11g databases and it fails on 9i.
There's an internal bug not visible that corresponds to the issue :
BUG 9169817 UPGRFUNC:METRIC COLLECTION RECEIVED FOR 9I DATABASE
Solution
Note: Solutions are listed in order of strength of recommendation
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=1632723052892222&type=DOCUMENT&id=1065410.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=gyfjvkxqn_271
No comments:
Post a Comment