Enterprise Manager 12c - Using emcli update_db_password to Change a DB User Password Updates the EM Credentials of All Users with the Same Password (Doc ID 1955424.1)

Last updated on FEBRUARY 02, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Named Credentials have been set up in Enterprise Manager to acces a Oracle Database. The Named Credentials are set with different usernames but the password is the same for some of them.

As an example, in Enterprise Manager there are three Named Credentials created to access the Oracle database "MyRacDb":

 

The following emcli is executed to change the password of both the Database User and the Enterprise Manager administrator:

After the emcli command completed successfully:

The database user User01 can connect successfully with the new password "MyNewPwd0".

The database user User02 can still connect successfully with the unchanged password "MyOldPwd".

The database user User03 can still connect successfully with the unchanged password "AnotherOldPwd".

The Enterprise Manager administrator User01 can connect to the database successfully from the Enterprise Manager console with the password "MyNewPwd0".

The Enterprise Manager administrator User02 can connect to the database successfully from the Enterprise Manager console with the password "MyOldPwd" .

The Enterprise Manager administrator User03 can connect to the database successfully from the Enterprise Manager console with the password "AnotherOldPwd" .

All Enterprise Manager tasks using the Named Credentials NCNormalUser01 or NCNormalUser03 complete successfully.

All Enterprise Manager tasks using the Named Credentials NCNormalUser02 fail with a authentication failure error type.

The command emcli update_db_password changes the password of all the Named Credentials for a database, regardless of the username value if the password is the same.

In this example:

 

 

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