No privilege to do a select query on the v_$session table

Products

• CA Automic Dollar Universe

Issue/Introduction

During migration UVMS to Oracle 19C with failover scenario the UVMS cannot be started and below error occurs:

| 2021-07-20 14:21:58 |ERROR| main | com.orsyp.central.server.CentralServer | A problem occurred while checking DB Conflicts.
java.lang.Exception: Can not check database conflicts. Oracle database user(uni_uvms) has no privilege to do a select query on the v_$session table. Please contact administrator or disable check of database conflicts.

Environment

Release : 6.10

Component : DOLLAR UNIVERSE

Cause

Lack of privilege to do a select query on the v_$session table for the database user.

Resolution

SQL script to give the right:

MS SQL SERVER: grant VIEW SERVER STATE to <user>;

ORACLE: grant select on v_$session to <user>;

 

Additional Information

Documentation:

https://docs.automic.com/documentation/webhelp/english/ALL/components/DU_AS/latest/%20%20Dollar%20Universe%20Guides/help.htm#UV_adm/Startup%20in%20failover%20cluster%20mode.htm?Highlight=v_$session