Embedded Files
Status
Status
If status is INVALID...
SELECT text
FROM user_source
WHERE name = 'VALIDATE_APEX'
AND INSTR(text,'select user#') > 0;
Ouptut should be similar to...
select user# into l_owner# from sys.user$ where name = 'APEX_040200';If you get this instead...
select user# into l_owner# from sys.user$ where name = '^3';then do this to fix...
cd ${APXDIR} # Should be set in .profile
sqlplus / as sysdba
set define '^'
@apexvalidate x x APEX_XXXXXX
(Where APEX_XXXXXX represents the current APEX schema. For example, APEX_040200)exec validate_apex;
Workspace Activity Log
Workspace Activity Log
The APEX Workspace Activity log is stored in the database as APEX_WORKSPACE_ACTIVITY_LOG.
Number of columns may vary depending on the APEX version. Most important:
page_name
log_context
view_date
apex_user
error message
Login as SYSTEM:
Bibliography
Bibliography
Application Express App Builder User's Guide https://docs.oracle.com/cd/E71588_01/HTMDB/running-advisor-to-check-application-integrity.htm (Release 5.1 BETA)
APEX Installation Verification Scripthttps://support.oracle.comAPEX Installation Verification Script (Doc ID 1254932.1)
APEX Installation Verification Scripthttps://support.oracle.comAPEX Installation Verification Script (Doc ID 1254932.1)
Page updated
Google Sites
Report abuse