My Oracle Support Banner

EM 13.5 - Delete Named Credential is used by one or more active Jobs or Corrective Actions (Doc ID 2904173.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

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

Symptoms

In Enterprise Manager (EM) 13.5, we would like to delete a Named Credential which is no longer used. When we try to delete this NC, we receive the following Error:

Named Credential is used by one or more active Jobs or Corrective Actions.

 

Since there are no more references listed, we don't know where this NC is still used.
We assume that the NC is used by some Corrective Action on databases.

Seeing the following errors about 'NC_ABC' in the emoms.log file which got generated during the deletion of the name credential:

2022-10-17 15:20:10,037 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil getCredentialReference.2837 - Exit: referenceGuid:9B9E6296E24C5A40E053C277880A3A12
2022-10-17 15:20:10,038 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil getCredentialReference.3294 - Entry: guid:null searchType:2 owner:SYSMAN name:NC_ABC shallowFetch:true targetNamenull targetTypenull audittrue
2022-10-17 15:20:10,038 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil getCredentialReference.3334 - SQL =BEGIN ? := EM_CREDENTIAL.get_nc_cred(?, ?); END; guid=null owner=SYSMAN name=NC_ABC
2022-10-17 15:20:10,042 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute HostPassword
2022-10-17 15:20:10,042 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredTypeMetaData validateParam.267 - Validating Attribute HostUserName
2022-10-17 15:20:10,042 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil getCredentialReference.3397 - credname=NC_ABC
2022-10-17 15:20:10,043 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil getCredentialReference.3426 - credowner=SYSMAN
......
2022-10-17 15:20:10,045 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditCacheManager getAuditSwitch.157 - AuditCacheManager.getAuditSwitch() returns true
2022-10-17 15:20:10,045 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditCacheManager isOperationAuditable.201 - AuditCacheManager.isOperationAuditable() returns true for operation GET_NAMED_CREDENTIAL
2022-10-17 15:20:10,045 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditLogHandler auditLog.141 - auditLog: auditSessionGuid: EB35AFCB429305D5E0539977880A70D0 txnType: 1
2022-10-17 15:20:10,052 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditLogHandler auditLog.391 - auditLog: success
2022-10-17 15:20:10,052 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil getCredentialReference.3550 - Exit: success: guid:null
2022-10-17 15:20:10,052 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditCacheManager getAuditSwitch.157 - AuditCacheManager.getAuditSwitch() returns true
2022-10-17 15:20:10,052 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditCacheManager isOperationAuditable.201 - AuditCacheManager.isOperationAuditable() returns true for operation GET_NAMED_CREDENTIAL
2022-10-17 15:20:10,101 [Symptom-Diagnosis:Symptom-Diagnosis Admin] DEBUG workmanager.Work logp.251 - Work:Starting work for BackGround Work Instance :Symptom-Diagnosis Admin
2022-10-17 15:20:10,120 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG credstore.EMCredentialUtil deleteCredential.3107 - Exit: fail: guid:9B9E6296E24C5A40E053C277880A3A12
2022-10-17 15:20:10,120 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditCacheManager getAuditSwitch.157 - AuditCacheManager.getAuditSwitch() returns true
2022-10-17 15:20:10,120 [2430::[ACTIVE] ExecuteThread: '49' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG audit.AuditCacheManager isOperationAuditable.201 - AuditCacheManager.isOperationAuditable() returns false for operation DELETE_NAMED_CREDENTIAL

To verify, run the following query on the repository database, as SYSMAN user:

Note: replace 'NC_ABC' with your correct named credential name.

Cause

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
Symptoms
Cause
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.