My Oracle Support Banner

ORA-29470 Dynamic Pages Do not Work After Upgrading to Database 11g (Doc ID 978194.1)

Last updated on AUGUST 08, 2018

Applies to:

Portal - Version 10.1.4.2 and later
Information in this document applies to any platform.
Checked for relevance on 29-Dec-2014

Symptoms

Passing parameters to dynamic pages are not working after applying <Patch  8887613> and upgrade the database to 11g.
The following error shows up in the application.log file:


09/12/07 10:37:30 portal: [module=RepositoryServlet, ecid=1170185971562,1] ERROR: Repository Gateway error: Database Error: ORA=29470 ORA-29470: Effective userid or roles are not the same as when cursor was parsed
ORA-06512: at "SYS.DBMS_SQL", line 1575
ORA-06512: at "PORTAL.MY_DYN_PAGE", line 175
ORA-06512: at "PORTAL.MY_DYN_PAGE", line 272
ORA-06512: at line 31

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.