MRCA 10g Process Exited Abnormally When Loading Repository for OracleAS Portal - SSO Log Shows PLS-00201 (Doc ID 413331.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.6 to 10.2.0.3 - Release: 9.2 to 10.2
Oracle Fusion Middleware - Version: 10.1.2.0.2 to 10.1.4.0.1   [Release: AS10gR2 to AS10gR2]
Information in this document applies to any platform.
Checked for relevance on 21-May-2009

Symptoms

The Metadata Repository Creation Assistant ( MRCA / RepCA / runRepCA ) hangs and then eventually errors at the stage of 'Loading Repository for OracleAS Portal'.

The repca log file shows:

[SQLPlusAction] Error :
<None>
Repository Loader actionFinished
Repository Loader ActionQueueFinished
Loading Repository for OracleAS Portal using the specification file /data/u00/app/oracle10/product/oidrca/portal/repca/ptlload.xml
Repository Loader actionStarting
[CustomExternalProcessAction] Command line: /data/u00/app/oracle10/product/oidrca/jdk/bin/java -cp /data/u00/app/oracle10/product/oidrca/assistants/opca/jlib/opca.jar:/data/u00/app/oracle10/product/oidrca/portal/jlib/ptlshare.jar:/u00/app/oracle10/product/oidrca/jdbc/lib/classes12.jar:/u00/app/oracle10/product/oidrca/jdbc/lib/nls_charset12.jar oracle.webdb.config.PortalConfigAssistant
[CustomExternalProcessAction] Process exited abnormally
[CustomExternalProcessAction] Action failed due to: oracle.ias.repca.ifs.utils.action.ActionFailedException: Some of the operations have failed during this OracleAS RepCA session. Please see the log file at /u00/app/oracle10/product/oidrca/assistants/repca/log/repca_2008-02-12_03-59-16_PM.log for further details.
ERROR - Some of the operations have failed during this OracleAS RepCA session. Please see the log file at /u00/app/oracle10/product/oidrca/assistants/repca/log/repca_2008-02-12_03-59-16_PM.log for further details.
oracle.ias.repca.ifs.utils.action.ActionFailedException: Some of the operations have failed during this OracleAS RepCA session. Please see the log file at /u00/app/oracle10/product/oidrca/assistants/repca/log/repca_2008-02-12_03-59-16_PM.log for further details.
at oracle.ias.repca.actions.CustomExternalProcessAction.perform(CustomExternalProcessAction.java:155)
at oracle.ias.repca.ifs.utils.action.ActionQueue.performActions(ActionQueue.java:319)
at oracle.ias.repca.ifs.utils.action.ActionQueue.run(ActionQueue.java:245)
at java.lang.Thread.run(Thread.java:534)

There may also be errors found in accompanying log files. By way of example:

SSO.log file shows:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1123/5 PL/SQL: Item ignored
1146/13 PL/SQL: Statement ignored
1146/26 PLS-00201: identifier 'UTL_HTTP' must be declared
1152/13 PL/SQL: Statement ignored
1152/26 PLS-00201: identifier 'UTL_HTTP' must be declared
1162/14 PLS-00201: identifier 'UTL_HTTP' must be declared

LINE/COL ERROR
-------- -----------------------------------------------------------------
138/5 PL/SQL: Item ignored
145/16 PL/SQL: Item ignored
145/16 PLS-00201: identifier 'UTL_FILE' must be declared
171/9 PLS-00320: the declaration of the type of this expression is incomplete or malformed
171/9 PL/SQL: Statement ignored
179/9 PL/SQL: Statement ignored
179/33 PLS-00320: the declaration of the type of this expression is incomplete or malformed
191/14 PLS-00201: identifier 'UTL_FILE' must be declared

LINE/COL ERROR
-------- -----------------------------------------------------------------
55/22 PL/SQL: Item ignored
55/22 PLS-00201: identifier 'UTL_SMTP' must be declared
70/7 PL/SQL: Statement ignored
70/7 PLS-00320: the declaration of the type of this expression is incomplete or malformed
71/7 PL/SQL: Statement ignored
71/21 PLS-00320: the declaration of the type of this expression is incomplete or malformed


workflow.log file shows:

Done.
WorkflowCA: SQLPLUS:OWF_MGR/<WFCA WF PASSWORD> @/data/u00/app/oracle10/product/oidrca/wf/sql/wfsedupg.sql OWF_MGR <WFCA
WF PASSWORD> STANDALONE
WorkflowCA: SQLPLUS:OWF_MGR/<WFCA WF PASSWORD> @/data/u00/app/oracle10/product/oidrca/wf/sql/wfmlrqi.sql OWF_MGR <WFCA WF PASSWORD>
WorkflowCA: SQLPLUS:OWF_MGR/<WFCA WF PASSWORD> @/data/u00/app/oracle10/product/oidrca/wf/sql/wfeqen.sql OWF_MGR <WFCA WF PASSWORD>
WorkflowCA: SQLPLUS:OWF_MGR/<WFCA WF PASSWORD> @/data/u00/app/oracle10/product/oidrca/wf/sql/wfmlrreq.sql
WorkflowCA: java.sql.SQLException: ORA-04063: package body "OWF_MGR.FND_SVC_COMP_REQUESTS_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "OWF_MGR.FND_SVC_COMP_REQUESTS_PKG"
ORA-06512: at line 10

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