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

Oracle EM Cloud Control 12c - Change SYSMAN password

1. Stop OMS

[oracle@rac2 ~]$ cd /u02/app/oracle/middleware/oms/bin/
[oracle@rac2 bin]$ ./emctl stop oms
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
Oracle Management Server is Down
[oracle@rac2 bin]$

2. Change sysman password

[oracle@rac2 ~]$ cd /u02/app/oracle/middleware/oms/bin/
[oracle@rac2 bin]$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd manager -new_pwd tiger
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.

Changing passwords in backend ...
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
Successfully changed repository password.
[oracle@rac2 bin]$


3. Restart OMS

[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