Error on upgrade from 3.2 to 4 [Unable to run page sentry in application 45
328328Jun 29 2010 — edited Jul 2 2010Hi 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