My Oracle Support Banner

EM 13c: Enterprise Manager 13c Cloud Control Template Synchronize Fails: ORA-20403: Not a valid Corrective action (Doc ID 2521718.1)

Last updated on OCTOBER 25, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 13.2 Cloud Control
Admin sync operation fails with the following error:

ORA-20403: Not a valid Corrective action <CA ID>
ORA-06512: at "SYSMAN.EM_TEMPLATE", line 5090 ORA-06512: at line 1

 

The system error log had the following errors for this operation:

select * from MGMT_SYSTEM_ERROR_LOG where MODULE_NAME='EM_TEMPLATE' and occur_date >= sysdate-2;

EM_TEMPLATE 12-02-19 -20403 ERROR "GEN_TC_AGG_TEMPLATE: Generation of Aggregate Template Failed. Template Target Type= [oracle_database] Aggregate
Template Name = [<TC_ID>] : ORA-20403: Not a valid Corrective action <CA ID>
ORA-06512: at ""SYSMAN.EM_TEMPLATE"", line 4629
ORA-06512: at ""SYSMAN.EM_TEMPLATE"", line 4768
" MGMT 12-02-19 11:27:48.591451000 PM -08:00
EM_TEMPLATE 12-02-19 -20403 ERROR "APPLY_TC_AGGREGATE_TEMPLATE: Submit of Apply Aggregate Template Operation failed Template Target Type= [oracle_database] Aggregate Template Name = [] : ORA-20403: Not a valid Corrective action <CA ID>
ORA-06512: at ""SYSMAN.EM_TEMPLATE"", line 4859
ORA-06512: at ""SYSMAN.EM_TEMPLATE"", line 5021
" MGMT 12-02-19 11:27:48.593038000 PM -08:00
EM_TEMPLATE 13-02-19 -20233 ERROR "create_base_template_clone: Create Aggregate Template failed Template Name = [Prod_Agent_V2] l_current_user= [<USER>] : ORA-20233: Invalid corrective action job_id <JOB_ID> provided to copy_ca_id
ORA-06512: at ""SYSMAN.EM_POLICY"", line 2752
ORA-06512: at ""SYSMAN.EM_TEMPLATE"", line 951
" MGMT 13-02-19 06:01:54.463786000 AM -08:00

 

The error stack observed from <EM_INSTANCE_BASE>/gc_inst/em/EMGC_OMS*/sysman/log/emoms.trc file:

2019-02-14 06:02:32,909 [RJob Step 2490365330] ERROR uimodel.TCMonitoringTemplateSync logp.251 - TCMonitoringTemplateSync:SQLException occurred java.sql.SQLException: ORA-20403: Not a valid Corrective action <CA_ID>
ORA-06512: at "SYSMAN.EM_TEMPLATE", line 5090
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)

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.