Saturday, February 28, 2015

EM Cloud Control 12c - ORA-14400: inserted partition key does not map to any partition

When connecting to EM Cloud Control 12c Console using SYSMAN user:

Authentication failed. If problem persists, contact your system administrator.

Can connect to OMR with user SYSMAN and password

Errors in /u02/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log

ORA-14400: inserted partition key does not map to any partition

Failed to login using repository authentication for user: SYSMAN

Ensure that the value of job_queue_processes parameter is set to 1000.

Execute the following queries in repository DB:
SQL> exec mgmt_audit_admin.add_audit_partition;


[oracle@rac2 ~]$ cd $OMS_HOME
[oracle@rac2 oms]$ cd bin
[oracle@rac2 bin]$ ./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down
[oracle@rac2 bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

No comments:

Post a Comment