EM 13c: Error in the Enterprise Manager 13c Cloud Control Run SQL Page: Credentials Missing (Doc ID 2250357.1)

Last updated on APRIL 07, 2017

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 to 13.2.0.0.0 [Release 13.1 to 13.2]
Enterprise Manager for Oracle Database - Version 13.1.1.0.0 to 13.2.2.0.0 [Release 13.1 to 13.2]
Information in this document applies to any platform.

Symptoms

Run a SQL statement on multiple selected targets from Enterprise Manager (EM) 13.2 Cloud Control by navigating:

Targets > Databases > Performance > Run SQL

Select:

Multi-Target Command Execution
Run SQL

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.

 

 

Changes

 N/A

Cause

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