My Oracle Support Banner

Automate Non-DBSNMP Password Management Including Sys User (Doc ID 2819538.1)

Last updated on NOVEMBER 04, 2021

Applies to:

Enterprise Manager Base Platform - Version 13.5.0.0.0 to 13.5.1.0.0 [Release 13c]
Information in this document applies to any platform.

Goal

Attempting to use the new feature to automate non-dbsnmp user password

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emadm/automate-non-dbsnmp-password-management.html
Automate Non-DBSNMP Password Management

For users that are not the default monitoring user for DB targets (not the user that was configured during target discovery and hence, is not used for monitoring and metric collection), you can use the Change the Password for a Database User job type to automate password management.

When using a normal user including system, the job runs fine and the password is updated. However, if this is tried using sys as sysdba or any account with sysdba role, the following error is found in the job log

Error :
Not updating password for user with unsupported role 'sysdba' for user: SYS on target <db target>:<db type>

 

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


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