Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error on upgrade from 3.2 to 4 [Unable to run page sentry in application 45

328328Jun 29 2010 — edited Jul 2 2010
Hi Folks,
To upgrade from 3.2 to Apex 4, I logged-in as sys and ran
apexins SYSAUX SYSAUX TEMP /i/

After installation when I tried accessing apex in browser, I am getting following error message

* ORA-06508: PL/SQL: could not find program unit being called*
* Unable to run page sentry in application 4500.*
* Return to application.*
* Application Express 4.0.0.00.46*
* Workspace: User: *
* Language: en | Copyright © 1999, 2010, Oracle. All rights reserved.*

This statement is returning INVALID status
SELECT STATUS FROM DBA_REGISTRY
WHERE COMP_ID = 'APEX'

The log is showing errors
Errors for PACKAGE BODY SYS.WWV_DBMS_SQL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
218/5 PL/SQL: Statement ignored
218/5 PLS-00306: wrong number or types of arguments in call to
'PARSE_AS_USER'

256/5 PL/SQL: Statement ignored
256/5 PLS-00306: wrong number or types of arguments in call to
'PARSE_AS_USER'

574/6 PL/SQL: Statement ignored
574/6 PLS-00306: wrong number or types of arguments in call to
'PARSE_AS_USER'

Can someone here guide me how to resolve this? Shall I reinstalled APEX 4 or rollback to 3.2 or do I need to run any other file.

Thanks in advance
Aali
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2010
Added on Jun 29 2010
2 comments
1,439 views