EM Cloud Control Not Able To Implement SQL Profiles with "400 Bad Request"
(Doc ID 2220526.1)
Last updated on FEBRUARY 21, 2019
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
- For a 18.104.22.168 Instance Target and Enterprise Manager Cloud Control 13c (Version 22.214.171.124.0, DB Plugin 126.96.36.199.0), it is not possible to implement any recommended SQL Profiles
- Error is dumped, when using sql profile from OEM (Instance Target -> Advisor Central -> SQL Tuning Summary: <Any Tuning Task> -> SQL Tuning Details:<Tuning Task> -> <Implement recommended SQL Profile>):
There is a firewall installed between OMS server and Target Instance and the OMS property use_pooled_target_connections is set true
(i.e. see output of emctl list properties -module emoms).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Symptoms Changes Cause Solution References
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.