My Oracle Support Banner

DBConsole を構成時、EMCA が ORA-24344, ORA-04063, PLS-00201 エラーで失敗する (Doc ID 2435870.1)

Last updated on AUGUST 16, 2018

適用範囲:

Enterprise Manager for Oracle Database - バージョン 10.2.0.1 から 11.2.0.3 [リリース 10.2 から 11.2]
この文書の内容はすべてのプラットフォームに適用されます。
本文書利用上のご注意
  本文書は英語の文書 <Document 333567.1> (最終メジャー更新日: 2018年01月13日) の日本語翻訳版です。
  英語の文書のメジャー更新に応じて本文書を随時更新いたします。

現象

Enterprise Manager Configuration Assistant(EMCA) を使用して Database Control を構成時、以下のエラーで失敗します:

emca.log.0 ファイルからは

<attempted creation date> oracle.sysman.emcp.EMConfig createRepository
CONFIG: ORA-24344: success with compilation error
ORA-06512: at line 38

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-24344: success with compilation error
ORA-06512: at line 38
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1418)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:792)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:306)
at oracle.sysman.emcp.EMConfig.createRepository(EMConfig.java:803)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:342)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:692)
at oracle.sysman.emcp.EMConfigAssistant.performSetup(EMConfigAssistant.java:641)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:340)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:180)
<attempted creation date> oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository. Repository creation could not be completed successfully



SEVERE: Error creating the repository. Repository creation could not be completed successfully
oracle.sysman.emcp.EMConfig perform
INFO: Make sure that following requirements are met before running it again
INFO: Block size for SYSAUX is greater than or equal to 8K
oracle.sysman.emcp.EMConfig perform
INFO: Job queue size is greater than or equal to 10
Could not complete the configuration. Refer to the log file for details
...
...
error creating emd_notification
PLS-201: identifier 'UTL_SMTP' must be declared


又は

BEGIN SYSMAN.setEMUserContext('SYSMAN',1); END;

*
ERROR at line 1:
ORA-04063: package body "SYSMAN.MGMT_GLOBAL" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYSMAN.MGMT_GLOBAL"


又は

Errors for PACKAGE BODY MGMT_GLOBAL:
167/3 PL/SQL: Statement ignored
167/10 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared
Errors for PACKAGE BODY MGMT_GLOBAL:
167/3 PL/SQL: Statement ignored
167/10 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared
No errors.
No errors.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY EMD_SCHEMA:
54/3 PL/SQL: Statement ignored
54/20 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared
127/3 PL/SQL: Statement ignored
127/20 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared
Errors for PACKAGE BODY EMD_SCHEMA:
54/3 PL/SQL: Statement ignored
54/20 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be declared
127/3 PL/SQL: Statement ignored
127/20 PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT' must be


又は

CONFIG FAILS: ORA-04063: PACKAGE BODY "SYSMAN.MGMT_TARGET" HAS ERRORS


又は

emca_<timestamp>.log より

Mar 24, 2008 10:26:24 AM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: Spooling to <path_to_oracle_home>/cfgtoollogs/emca/<oracle_sid>/emca_repos_create_2008_03_24_10_26_24.log
Mar 24, 2008 10:26:24 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 24, 2008 10:39:51 AM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: ORA-04063: package body "SYSMAN.MGMT_AUDIT_LOG" has errors
ORA-06508: PL/SQL: could not find program unit being called:

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-04063: package body "SYSMAN.MGMT_AUDIT_LOG" has errors

emca_repos_create_<timestamp>.log より

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY MGMT_AUDIT_LOG:

303/29 PL/SQL: Item ignored
303/29 PLS-00201: identifier 'UTL_FILE' must be declared
312/9 PL/SQL: Statement ignored
.
.
.
No errors.
EXCEPTION for create emrep target -6508
BEGIN
*
ERROR at line 1:
ORA-04063: package body "SYSMAN.MGMT_AUDIT_LOG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYSMAN.MGMT_AUDIT_LOG

変更点

utl_file 及び他のオブジェクトに対する実行権限が欠落しています。

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.