RCU Failing to Install Portal Schema with Oracle Database 11.2 or Higher (12.1) (Doc ID 2056847.1)

Last updated on JULY 20, 2016

Applies to:

Portal - Version 11.1.1.4.0 to 11.1.1.4.0 [Release FMW11g]
Information in this document applies to any platform.

Symptoms

When attempting to run RCU (11.1.1.7) to create PORTAL schema on 11.2.0.3.0 or 12.1.0.2  Database the following error occurs.


RCU.log (RDBMS 11.2.0.3.0)

2015-09-01 13:55:08.140 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: Executing Task: Portal
2015-09-01 13:55:08.140 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction command=oracle.ias.version.SchemaVersionUtil:utilCreateRegistryEntry
2015-09-01 13:55:08.140 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction method=utilCreateRegistryEntry
2015-09-01 13:55:08.140 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Connect As Owner: false
2015-09-01 13:55:08.140 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:SYS, role:SYSDBA, connectString:(description=(address=(host=x.x.x.x)(protocol=tcp)(port=1521))(connect_data=(service_name=orcl)(server=dedicated)))
2015-09-01 13:55:11.154 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction command=oracle.webdb.config.PortalConfigAssistant:main
2015-09-01 13:55:11.244 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction method=main
2015-09-01 13:55:31.764 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method: Excepton:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.RuntimeException: ERROR: Portal Configuration Assistant aborted
at oracle.webdb.config.PortalConfigAssistant.(Unknown Source)
at oracle.webdb.config.PortalConfigAssistant.main(Unknown Source)
... 6 more

2015-09-01 13:55:31.764 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ERROR: Portal Configuration Assistant aborted

2015-09-01 13:57:32.398 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6135:Error while trying to execute Java action.
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:302)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6135:Error while trying to execute Java action.
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:537)
... 1 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)
... 1 more
Caused by: java.lang.RuntimeException: ERROR: Portal Configuration Assistant aborted
at oracle.webdb.config.PortalConfigAssistant.(Unknown Source)

 

RCU.log (RDBMS 12.1.0.2)

checkinstall2=Add ACL for network packages if DB is 11.1 or higher...
old 4: schema varchar2(2000) := upper('&&1');
new 4: schema varchar2(2000) := upper('DEV_PORTAL');
Package DBMS_NETWORK_ACL_ADMIN exists, assign ACL if not already assigned
Removing dangling principals,if any from the ACL privilege list ...
ERROR: when assigning network ACL
declare
*
ERROR at line 1:
ORA-46114: ACL name /sys/acls/portal-permissions.xml not found.
ORA-06512: at line 100



Portal.log

Package DBMS_NETWORK_ACL_ADMIN exists, assign ACL if not already assigned
Removing dangling principals,if any from the ACL privilege list ...
ERROR: when assigning network ACL
declare
*
ERROR at line 1:
ORA-19114: XPST0003 - error during parsing the XQuery expression:
ORA-06512: at line 100

Grant Oracle Text URL/FILE datastore role
old 103: dbms_output.put_line('granting PORTAL_SEARCH_FILE_ACCESS_ROLE to &&1 and setting file_access_role parameter.');
new 103: dbms_output.put_line('granting PORTAL_SEARCH_FILE_ACCESS_ROLE to DEV1_PORTAL and setting file_access_role parameter.');
old 104: execute immediate 'grant PORTAL_SEARCH_FILE_ACCESS_ROLE to &&1';
new 104: execute immediate 'grant PORTAL_SEARCH_FILE_ACCESS_ROLE to DEV1_PORTAL';
l_db_version_string = 11.2.0.3.0
l_db_compatibility = 11.2.0.0.0

Database is 11.2 or higher, therefore setting datastore preference
PORTAL_SEARCH_FILE_ACCESS_ROLE already exists, no need to create it.
granting PORTAL_SEARCH_FILE_ACCESS_ROLE to DEV1_PORTAL and setting file_access_role parameter.

Grant Oracle Text URL/FILE datastore role completed sucessfully.
PL/SQL procedure successfully completed.

...end of SYS install

INSTALL_ERROR: sqlExecuter() : Raised Exception oracle.webdb.config.PortalWiringException: Generated errors of type ORA-, PLS-, SP2-, ERROR: or IMP-. Refer to the log file for details.

ERROR : Creating Portal Schema raised exception for wdbisys.sql.
2015-09-01 13:57:59.897 rcu:Executing SQL statement: drop tablespace DEV1_PORTAL including contents and datafiles

2015-09-01 13:58:06.437 rcu:Executing SQL statement: drop tablespace DEV1_PORTAL_DOC including contents and datafiles

2015-09-01 13:58:12.756 rcu:Executing SQL statement: drop tablesand datafiles
pace DEV1_PORTAL_LOG including contents
2015-09-01 13:58:18.364 rcu:Executing SQL statement: drop tablespace DEV1_PORTAL_IDX including contents and datafiles

 

 

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