APEX

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: