Oracle probe - ORA-00942: table or view does not exist

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Oracle probe - ORA-00942: table or view does not exist

Environment

UIM 20.x

Oracle probe 5.45

Remote Oracle DB 19c

Cause

This is related to a lack of DB permissions for the user configured in the probe

Resolution

Need to provide this access o the user:

 

GRANT "CONNECT" TO "CAUIMORACLEDC";
GRANT "SELECT_CATALOG_ROLE" TO "user";

GRANT SELECT ON "SYS"."TS$" TO "user";
GRANT SELECT ON "SYS"."GV_$SORT_SEGMENT" TO "user";

GRANT SELECT ON ANY DICTIONARY TO "user";