ERROR emCLI.CLIPageHandler render.672 – ORA-14400: inserted partition key does not map to any partition
Posted by Mir Sayeed Hassan on March 9th, 2021
ERROR emCLI.CLIPageHandler render.672 – ORA-14400: inserted partition key does not map to any partition
This issue is occur while dropping the agent from OEM Server.
Login to OEM Server
[oracle@oemdb ~]$ cd /u01/oem13.4c/middleware/bin/
[oracle@oemdb bin]$ ./emcli login -username=SYSMAN Enter password : ******** Login successful
Issue the below command to delete the agent from OEM Server
[oracle@oemdb bin]$ ./emcli delete_target -name="10.107.0.101:3872" -type="oracle_emd" -delete_monitored_targets ERROR emCLI.CLIPageHandler render.672 - ORA-14400: inserted partition key does not map to any partition
Stop all processes of OMS from OEM Server
[oracle@oemdb bin]$ ./emctl stop oms -all Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... WebTier Successfully Stopped Oracle Management Server Successfully Stopped Oracle Management Server is Down JVMD Engine is Down BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command Stopping BI Publisher Server... BI Publisher Server Already Stopped BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command AdminServer Successfully Stopped BI Publisher Server is Down BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command
Login to the database & set the job_queue_processes initialization parameter to 100 as shown below
[oracle@oemdb bin]$ !sq sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 8 13:52:05 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> alter system set JOB_QUEUE_PROCESSES=100 scope = both; System altered.
Start the OMS & Delete the agent
[oracle@oemdb bin]$ ./emctl start oms Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Starting Oracle Management Server... WebTier Successfully Started Oracle Management Server Successfully Started Oracle Management Server is Up JVMD Engine is Up
Note: To drop any agent, first you need to login to the sysman
[oracle@oemdb bin]$ ./emcli login -username=SYSMAN Enter password : ******** Login successful
Delete the agent
[oracle@oemdb bin]$ ./emcli delete_target -name="10.107.0.101:3872" -type="oracle_emd" -delete_monitored_targets Target "10.107.0.101:3872:oracle_emd" deleted successfully