Last updated on APRIL 07, 2017
Applies to:Enterprise Manager Base Platform - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 13.1 to 13.2]
Enterprise Manager for Oracle Database - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 13.1 to 13.2]
Information in this document applies to any platform.
Run a SQL statement on multiple selected targets from Enterprise Manager (EM) 13.2 Cloud Control by navigating:
Targets > Databases > Performance > Run SQL
Multi-Target Command Execution
SQL: select sysdate from dual; (as an example of sql statement)
Add Target: select all database targets
Select Host Credentials: Preferred host credentials
Select Database Credentials: Preferred Normal Database Credentials
click on RUN
The SQL execution fails on all database targets with a "Credentials Missing" error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms