EMCA Fails With ORA-24344, ORA-04063, PLS-00201 Errors While Creating DBConsole (Doc ID 333567.1)

Last updated on NOVEMBER 11, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Feb-2013***

Symptoms

When using the Enterprise Manager Configuration Assistant(EMCA) to create dbconsole, the creation can fail with the following errors:-

Fron emca.log.0 file

<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

and

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


OR

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"


OR

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


OR

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


OR

File 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

File 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

Changes

Missing execute privilege to public on utl_file and other objects.

Cause

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 hundreds of Community platforms