Upgrading Portal Schema To 11g Using Upgrade Assistant Fails With DRG-10595 And DRG-10758 (Doc ID 1366654.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version 11.1.1.4.0 and later
Information in this document applies to any platform.
Checked for relevance on 21-Nov-2014

Symptoms


Portal repository upgrade from 10.1.4.2 to 11.1.1.4 fails with the following error reported in the log file:

### ERROR: WWU-01013: Upgrade terminated with the following errors:
### 10021 : ERROR at line 1:
### 10022 : ORA-20000:
### 10023 : ORA-06512: at "PORTAL.WWPOF", line 440
### 10024 : ORA-06512: at line 152
### 10025 : ORA-06510: PL/SQL: unhandled user-defined exception
### 10026 : ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 164
### 10027 : ORA-06512: at "PORTAL.WWV_CONTEXT", line 2283
### 10028 : ORA-06510: PL/SQL: unhandled user-defined exception
### 10029 : ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 71
### 10030 : ORA-06512: at "PORTAL.WWV_CONTEXT", line 2231
### 10031 : ORA-29874: warning in the execution of ODCIINDEXALTER routine
### 10032 : ORA-29960: line 1,
### 10033 : DRG-10595: ALTER INDEX WWSBR_URL_CTX_INDX failed
### 10034 : DRG-10758: index owner does not have the privilege to use file or URL datastore
### 10044 : # ERROR: Creating missing Text indices
### 10045 : # ERROR: User-Defined Exception
### 10053 : ### ERROR: Exception Executing upg/common/posttrge/crtxtind.sql

Changes

The portal upgrade procedure is documented below:

Oracle Fusion Middleware Upgrade Guide for Oracle Portal, Forms, Reports, and Discoverer
11g Release 1 (11.1.1)
Part Number E10130-04
3 Upgrading Your Oracle Portal, Forms, Reports, and Discoverer Environment

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