EM Cloud Control Not Able To Implement SQL Profiles with "400 Bad Request"
Last updated on JANUARY 11, 2017
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
- For a 220.127.116.11 Instance Target and Enterprise Manager Cloud Control 13c (Version 18.104.22.168.0, DB Plugin 22.214.171.124.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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms