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!

Missing Public synonyms after upgrade to APEX 20.1

jentooSep 3 2020

Hi,

APEX was upgraded from APEX 5.0 to 20.1 using apexins.sql.

The upgrade was successful, but the applications cannot be accessed:

Errors are:

404 Not Found

2020-09-03T05:31:37.604Z | IWAcZ1Gb1Mx1FzQugbwf6g

  • The procedure named apex could not be accessed, it may not be declared or the user executing this request may not have been granted execute privilege on the procedure. Check the spelling of the procedure and check that the execute privilege has been granted to the caller

and

404 Not Found

2020-09-03T05:23:35.904Z | hDxe6fMZeLgJxEcQqVurCg

  • The procedure named f could not be accessed, it may not be declared or the user executing this request may not have been granted execute privilege on the procedure. Check the spelling of the procedure and check that the execute privilege has been granted to the caller

I checked the privileges and synonyms, and there seem to be a number of missing PUBLIC synonyms as per document:

https://docs.oracle.com/en/database/oracle/application-express/20.1/htmdb/about-granted-privileges.html#GUID-C3FE4C23-C7AA-4E24-85E5-5ADB326ACB73

Where did I go wrong?

Is there a script in the apex installer to re-create the missing synonyms?

There are only 102 PUBLIC synonyms after the upgrade:

 

APEX_APPLICATION_LOV_COLS
APEX_APPLICATION_PAGE_CHARTS
APEX_APPLICATION_PAGE_CHART_A
APEX_APPLICATION_PAGE_CHART_S
APEX_APPLICATION_RPT_LAYOUTS
APEX_APPLICATION_RPT_QRY_STMTS
APEX_APPLICATION_RPT_QUERIES
APEX_APPLICATION_SETTINGS
APEX_APPL_ACL_ROLES
APEX_APPL_ACL_USERS
APEX_APPL_ACL_USER_ROLES
APEX_APPL_DATA_PROFILES
APEX_APPL_DATA_PROFILE_COLS
APEX_APPL_EMAIL_TEMPLATES
APEX_APPL_PAGE_FACETS
APEX_APPL_PAGE_IGS
APEX_APPL_PAGE_IG_COLUMNS
APEX_APPL_PAGE_IG_COL_GROUPS
APEX_APPL_PAGE_IG_RPTS
APEX_APPL_PAGE_IG_RPT_AGGS
APEX_APPL_PAGE_IG_RPT_CHT_COLS
APEX_APPL_PAGE_IG_RPT_COLUMNS
APEX_APPL_PAGE_IG_RPT_COMPUTES
APEX_APPL_PAGE_IG_RPT_FILTERS
APEX_APPL_PAGE_IG_RPT_HIGHLTS
APEX_APPL_PAGE_IG_RPT_VIEWS
APEX_APPL_PLUGIN_STD_ATTRS
APEX_APPL_WEB_SRC_COMP_PARAMS
APEX_APPL_WEB_SRC_MODULES
APEX_APPL_WEB_SRC_OPERATIONS
APEX_APPL_WEB_SRC_PARAMETERS
APEX_INSTANCE_PARAMETERS
APEX_INST_RESTADM_CLIENTS
APEX_INST_RESTADM_CLIENT_ROLES
APEX_ISSUES
APEX_ISSUE_ATTACHMENTS
APEX_ISSUE_COMMENTS
APEX_ISSUE_EMAIL_PREFS
APEX_ISSUE_EVENTS
APEX_ISSUE_LABELS
APEX_ISSUE_LABEL_GROUPS
APEX_ISSUE_LABEL_RELATION

APEX_ISSUE_MILESTONES

Thank you.

APEX_ISSUE_MILESTONE_RELATION
APEX_ISSUE_NOTIFICATIONS
APEX_ISSUE_STAKEHOLDERS
APEX_PATCHES
APEX_PKG_APPS
APEX_PKG_APP_ACTIVITY
APEX_PKG_APP_AUTHENTICATIONS
APEX_PKG_APP_AVAILABLE
APEX_PKG_APP_INSTALLED
APEX_SCHEDULER_JOBS
APEX_USAGE_METRICS
APEX_WEBSERVICE_LOG
APEX_WORKSPACE_CREDENTIALS
APEX_WORKSPACE_REMOTE_SERVERS
APEX_WORKSPACE_RESTENABLED_SQL
WWV_FLOW_ACL_API
WWV_FLOW_APPL_COMPONENT_TYPES
WWV_FLOW_APPL_EXPORT_COMPS
WWV_FLOW_APP_SETTING_API
WWV_FLOW_COMPONENT
WWV_FLOW_CREDENTIAL_API
WWV_FLOW_DATA_PARSER
WWV_FLOW_DATA_PARSER
WWV_FLOW_EXEC_API
WWV_FLOW_EXPORT_API
WWV_FLOW_INSTANCE_REST_ADMIN
WWV_FLOW_INTERACTIVE_GRID_API
WWV_FLOW_JWT
WWV_FLOW_LOV_API
WWV_FLOW_LOV_API
WWV_FLOW_PKG_APP_INSTALL_API
WWV_FLOW_POOL_CONFIG
WWV_FLOW_SESSION_API
WWV_FLOW_SPATIAL_API
WWV_FLOW_STRING
WWV_FLOW_STRING
WWV_FLOW_STRING_UTIL
WWV_FLOW_TEAM_API
WWV_FLOW_THEME_API
WWV_FLOW_T_CLOB
WWV_FLOW_T_CLOB
WWV_FLOW_T_EXPORT_FILE
WWV_FLOW_T_EXPORT_FILES
WWV_FLOW_T_NUMBER
WWV_FLOW_T_NUMBER
WWV_FLOW_T_PARSER_COLUMN
WWV_FLOW_T_PARSER_COLUMNS
WWV_FLOW_T_PARSER_COLUMNS
WWV_FLOW_T_PARSER_ROW
WWV_FLOW_T_PARSER_ROW
WWV_FLOW_T_PARSER_TABLE
WWV_FLOW_T_PARSER_TABLE
WWV_FLOW_T_PARSER_WORKSHEET
WWV_FLOW_T_PARSER_WORKSHEET
WWV_FLOW_T_PARSER_WORKSHEETS
WWV_FLOW_T_PARSER_WORKSHEETS
WWV_FLOW_T_TEMP_LOV_DATA
WWV_FLOW_T_TEMP_LOV_VALUE
WWV_FLOW_WORKSPACE_USER_API

Comments
Post Details
Added on Sep 3 2020
0 comments
642 views