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:
- Start sqlplus as the sysdba user.
sqlplus "sys/ehealth@$NH_DB_CONNECT_STRING as sysdba"
- 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
- Exit from sqlplus
You can now use nimmon in UIM to access the tables to monitor the Oracle database.