When running discovery for Oracle Management pack the following error occurs:
ERROR at line 1:
ORA-00942: table or view does not exist
Kingston Patch 9 and above
This issue was introduce by PRB1298553. When you have SAMP(software Asset Management Professional) and Discovery plugins are both installed. Running discovery on non-RAC device that have oracle options, may fail to get all the oracle options (management option) in step "Select management options for oracle DB"
So the step was changed:
"export TNS_ADMIN=" + $oracle_home + "/network/admin;export ORACLE_HOME=" + $oracle_home + "; echo \"select value FROM GV$PARAMETER WHERE name LIKE ''%CONTROL_MANAGEMENT_PACK_ACCESS%';" + "|" + "\"" + $oracle_home + "/bin/sqlplus\" -s " + "$$username$$/'$$password$$'@" + $computer_system.primaryHostname + ":" + $tcp_port + "/" + $servicename
The above query is using the view/table "GV$PARAMETER ". This table/view does not exist on any Oracle instance except for rare cases of RAC databases instead V$PARAMETER would be the view for non RAC databases.
Grant access for V$PARAMETER to resolve this issue.