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 AUGUST 19, 2022

Applies to:

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":

• NCNormalUser01 with the username User01 and the password "MyOldPwd"
• NCNormalUser02 with the username User02 and the password "MyOldPwd"
• NCNormalUser03 with the username User03 and the password "AnotherOldPwd"

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:

• the password of the Named Credentials NCNormalUser01 and NCNormalUser02 were changed to "MyNewPwd0"
• the password of the Named Credentials NCNormalUser03 remained unchanged.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.