My Oracle Support Banner

This Page Can't Be Displayed / ORA-06502: PL/SQL: numeric or value error: Instead of Login After Installing / Upgrading APEX (Doc ID 2411472.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (APEX) - Version 5.1.4.00.08 and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Performed a successful install of APEX 5.1.4 into a 12.2.0.1.0 PDB. Attempted to access ADMIN link and received 'This page can't be displayed'

The ADMIN link via EPG http://hostname:8181/apex/apex_admin results in:
The page cannot be displayed.

Failures also occur in when ORDS is configured. http://hostname:8080/ords fails with:

Error processing authorization.
ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters

No errors are seen in the installation logs for APEX.

Changes

 Upgrade of APEX in a 12.2.0.1 multi-tenant database.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.