My Oracle Support Banner

EM 13c: Can OEM Accepts DBSNMP/SYS Encrypted Password From SYS.USER$ Table Through EMCLI Command? (Doc ID 2736955.1)

Last updated on DECEMBER 29, 2020

Applies to:

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

Goal

The passwords of database user accounts such as DBSNMP, SYS etc are saved in SYS.USER$ table in encrypted form.
Is it possible to extract this encrypted password from sys.user$ table and pass it in below emcli command, using some scripting, to update the passwords in OEM? Does OEM supports this?

./emcli update_db_password -target_type="oracle_database" -target_name=<Target Name> -user_name="dbsnmp" -change_at_target=yes
-old_password="<Old Password>" -new_password="<New Password>" -retype_new_password="<New Password>"

 

Solution

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
Goal
Solution
References


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