How to Monitor eHealth Database using UIM

Products

• CA eHealth

Issue/Introduction

When using UIM to monitor the eHealth Oracle database, the error "You need to have SELECT rights on TS$(tablespaces) to run the probe properly" is generated.

Environment

UIM any version

eHealth any version

Cause

The error occurs due to insufficient privileges for the user (eHealth) that you are using in the probe to connect to the database.

Resolution

A database user needs to be created in eHealth Oracle that is used to configure monitoring via UIM.

Connect to the eHealth server and follow these instructions:

1. Start sqlplus as the sysdba user.
   sqlplus "sys/[email protected]$NH_DB_CONNECT_STRING as sysdba"
2. Enter the following commands to create a user named nimmon.
   create user nimmon identified by nimmon;
   grant connect to nimmon;
   grant select_catalog_role to nimmon;
   grant select on gv_$sort_segment to nimmon;
   grant select on sys.ts$ to nimmon;
   select * from all_users; - to show all the users with username nimmon
   ALTER USER nimmon IDENTIFIED BY nimmon; - to change the password of nimmon to nimmo
3. Exit from sqlplus
   exit

You can now use nimmon in UIM to access the tables to monitor the Oracle database.