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

Last updated on AUGUST 07, 2023

Applies to:

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=<HOSTNAME>)(protocol=tcp)(port=<DB_PORT>))(connect_data=(service_name=<SID>)(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('<PREFIX>_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 <PREFIX>_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 <PREFIX>_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 <PREFIX>_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 <PREFIX>_PORTAL including contents and datafiles

2015-09-01 13:58:06.437 rcu:Executing SQL statement: drop tablespace <PREFIX>_PORTAL_DOC including contents and datafiles

2015-09-01 13:58:12.756 rcu:Executing SQL statement: drop tablesand datafiles
pace <PREFIX>_PORTAL_LOG including contents
2015-09-01 13:58:18.364 rcu:Executing SQL statement: drop tablespace <PREFIX>_PORTAL_IDX including contents and datafiles 

Changes

Cause

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