The SYSDBA user set in Enterprise Manager Preferred Credentials is Not Used to Access the Database (logon prompt is given instead). (Doc ID 1606106.1)

Last updated on MARCH 01, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.1 to 12.1.0.5.0 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

When the SYSDBA user is set in the Enterprise Manager 12c Cloud Control preferred credentials for "SYSDBA database credentials", a "database login" dialogue box is presented to the user when clicking on any of the database operations which require logging into the database (for example choose an option from Performance,Availability,Security,Schema and Administration).  When the 'normal database credentials' are set, automatic login to the database takes place (when choosing an option from Performance/Availability/Security or Schema) and no "database login" box is shown.

Question: Why doesn't Enterprise Manager use the credentials set for the SYSDBA user to automatically log into the database?

 

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