I have upgraded from Apex 5.1.0 to 5.1.2 running Glassfish 4 and ORDS
I have 4 test databases on our test server and have upgraded 3 of them using apxpatch.sql. All are using the same ORDS/glassfish.
The first 2 databases to upgrade have no issues.
The third database (DB3) has ORA-06508 errors at the following points :
open apex designer page :
Error during rendering of region "Application Express - Sign In".
ORA-06508: PL/SQL: could not find program unit being called
after login page of existing applications.
Error processing request.
ORA-06508: PL/SQL: could not find program unit being called
The same applications on the other databases are fine.
I have looked ate wwv_flow_debug_messages and there are the follwoing entries :
19-JUL-17 11.46.02.825658000 +01:00 - component: APEX_APPLICATION_PAGES &PRODUCT_NAME. - Sign In (4550000000001)
19-JUL-17 11.46.02.825530000 +01:00 "- error_backtrace: ORA-06512: at "APEX_050100.WWV_FLOW_DISP_PAGE_PLUGS", line 997
"
19-JUL-17 11.46.02.825417000 +01:00 - ora_sqlerrm: ORA-06508: PL/SQL: could not find program unit being called
19-JUL-17 11.46.02.825319000 +01:00 - ora_sqlcode: -6508
19-JUL-17 11.46.02.825226000 +01:00 - apex_error_code: APEX.REGION.UNHANDLED_ERROR
19-JUL-17 11.46.02.825159000 +01:00 - is_internal_error: true
19-JUL-17 11.46.02.825072000 +01:00 - display_location: ON_ERROR_PAGE
19-JUL-17 11.46.02.825005000 +01:00 - additional_info: ORA-06508: PL/SQL: could not find program unit being called
19-JUL-17 11.46.02.824928000 +01:00 Error: Error during rendering of region "&PRODUCT_NAME. - Sign In".
19-JUL-17 11.46.02.824887000 +01:00 "SID=38
USER=APEX_PUBLIC_USER
INSTANCE=1
"
19-JUL-17 11.46.02.824775000 +01:00 "GET http://sv-gf-test:28081/ords
REMOTE_ADDR=10.208.129.23
REMOTE_USER=APEX_PUBLIC_USER
APEX_LISTENER_VERSION=3.0.8.277.08.01
HTTP_COOKIE=LOGIN_USERNAME_COOKIE=furxx; ORA_WWV_WS_LANG_TERRITORY=en:UNITED KINGDOM
"
19-JUL-17 11.46.02.824645000 +01:00 CGI: PATH_INFO = /f?p=4550:1:16930304970113:::::YES
I have rerun apxpatch.sql.
PL/SQL procedure successfully completed.
...Validating Application Express
...(10:18:34) Starting validate_apex for APEX_050100
...(10:18:37) Checking missing sys privileges
...(10:18:37) Recompiling
...(10:18:41) Checking for objects that are still invalid
...(10:18:41) Key object existence check
...(10:18:42) Setting DBMS Registry for APEX to valid
...(10:18:43) Exiting validate_apex
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Complete Patch
Elapsed: 00:04:21.82
There were no errors in the log.
The dba_registry says VALID.
There are no invalid objects.
Any ideas?
Kathryn