Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

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

Therefore the agent is deleted successfully.

=====Hence tested & verified in our test env=====