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 SEPTEMBER 17, 2018
Applies to:Enterprise Manager Base Platform - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 12.1]
Information in this document applies to any platform.
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:
$ emcli update_db_password -target_name="MyRacDb" -user_name="User01" -target_type="oracle_database" -change_at_target="yes" -change_all_references="no" -old_password="MyOldPwd" -new_password="MyNewPwd01" -retype_new_password="MyNewPwd0"
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document