Notifications

39 views

Symptoms


When running discovery for Oracle Management pack the following error occurs:

 

ERROR at line 1:
ORA-00942: table or view does not exist

Release


Kingston Patch 9 and above

 

Cause


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.

Resolution


 

Grant access for V$PARAMETER to resolve this issue.

Article Information

Last Updated:2018-11-16 12:16:57
Published:2018-11-16