Error :
[oracle@xxxx-oem-01 emcli]$cd /u01/app/oracle/Middleware132c/bin/
[oracle@xxxx-oem-01 bin]$ emcli sync
Synchronized successfully
[oracle@xxxx-oem-01 bin]$ emcli get_targets
Internal Error: The EM CLI system has encountered an internal error. Details have been added to the OMS log files.
[oracle@xxxx-oem-01 bin]
Executing any Enterprise Manager (EM) 13c Cloud Control command (except sync) fails with the following error:
./emcli sync
Synchronized successfully
./emcli get_targets
Internal Error: The EM CLI system has encountered an internal error. Details have been added to the OMS log files.
Synchronized successfully
./emcli get_targets
Internal Error: The EM CLI system has encountered an internal error. Details have been added to the OMS log files.
- The <gc_inst>/em/EMGC_OMS1/sysman/log/emoms.trc reports the below errors for the emcli command:
2016-10-13 12:19:08,266 [EMUI_12_19_07_/console/cli] ERROR emCLI.CLIPageHandler render.671 - ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "SYSMAN.EM_CLI", line 303
ORA-06512: at "SYSMAN.EM_CLI", line 303
java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition ORA-06512: at "SYSMAN.EM_CLI", line 303
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.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
- The EM Diagkit (from Doc ID 1426973.1) reports:
verifyCORE
0002. Missing DBMS_SCHEDULER jobs: 36
0002. Missing DBMS_SCHEDULER jobs: 36
- All the DBMS Scheduler jobs related to the EM repository are shown to be down in the Setup -> Manage Cloud Control > Repository, page in the Console UI.
- Log in to EM 13c Cloud Control through a browser works without any errors.
CAUSE
None of the DBMS_scheduler jobs are running in the EM repository.
The ORA-14400 error indicates that the expected partitions are not present in the EM 13c repository for storage of the login-related data.
The dbms_scheduler jobs are responsible for creating the partitions.
The ORA-14400 error indicates that the expected partitions are not present in the EM 13c repository for storage of the login-related data.
The dbms_scheduler jobs are responsible for creating the partitions.
SOLUTION
Use the following steps to perform the partition maintenance and re-submit all mandatory DBMS scheduler jobs related to the EM repository:
SQL> connect / as sysdba
SQL> alter system set job_queue_processes = 0;
SQL> connect sysman/<password>
SQL> exec emd_maintenance.remove_em_dbms_jobs;
SQL>exec gc_interval_partition_mgr.partition_maintenance;
SQL> @<OMS_HOME>/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql SYSMAN
SQL> connect / as sysdba
SQL> alter system set job_queue_processes = 1000;
SQL> connect sysman/<password>
SQL> exec emd_maintenance.submit_em_dbms_jobs;
SQL> commit;
SQL> alter system set job_queue_processes = 0;
SQL> connect sysman/<password>
SQL> exec emd_maintenance.remove_em_dbms_jobs;
SQL>exec gc_interval_partition_mgr.partition_maintenance;
SQL> @<OMS_HOME>/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql SYSMAN
SQL> connect / as sysdba
SQL> alter system set job_queue_processes = 1000;
SQL> connect sysman/<password>
SQL> exec emd_maintenance.submit_em_dbms_jobs;
SQL> commit;
Execute the necessary emcli commands after the above.
[oracle@xxxx-oem-01 bin]$emcli login -username=sysman
Enter password :
Login successful
[oracle@xxxx-oem-01 bin]$
[oracle@xxxx-oem-01 bin]$emcli sync
Synchronized successfully
[oracle@fcias-oem-01 bin]$emcli get_targets
Status Status Target Type Target Name
ID
-9 N/A cloud Middleware and Database Cloud
.
.
..
No comments:
Post a Comment