User With "read-only" Oracle Enterprise Manager (OEM) Role Can't Use Sql Tune When Connecting To DB With "dbsnmp" Credentials
(Doc ID 2054495.1)
Last updated on MAY 03, 2021
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.4.0 to 12.1.0.8.0 [Release 12.1] Information in this document applies to any platform.
Symptoms
When an attempt is made to tune SQL from the Oracle Enterprise Manager (OEM) 12c console, a "There was a problem tuning the SQL statement: Enterprise Manager has blocked you from performing this task as you are performing this operation using a READONLY connection" message is received as follows:
The user is logged in as "dbsnmp (read-only):
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!