ORA-01045 Error During Upgrade of WebCenter Content (Doc ID 2224003.1)

Last updated on JANUARY 20, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade WebCenter Content from 11.1.1.8.0 to 11.1.1.9.0 using the Patch Set Assistant, the upgrade fails with this error:

MDS ERROR:
java.sql.SQLException: ORA-06550: line 34, column 9:
PLS-00201: identifier 'DBMS_RLS' must be declared
ORA-06550: line 34, column 9:
PL/SQL: Statement ignored

OCSSEARCH ERROR:
ORA-01045: user TSTA_OCSSEARCH lacks CREATE SESSION privilege; logon denied
the DB user ECMTAO is given DBA permission, still PSA

 


Due to this issue, WebCenter Content cannot be upgraded.

Changes

 

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