APEX INVALID: ORA-00600 [Qctbyt : Bfc] and ORA-06508: "PL/SQL: could not find program unit being called" (Doc ID 2075216.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The issue is related to an APEX upgrade, In this case, the upgrade was from 4.2 to 5.0.

Attempt to login into the APEX web page raise an error:

ORA-06508: PL/SQL: could not find program unit being called


The alert log shows:

alter pluggable database pdb$seed close immediate instances=all
ALTER SYSTEM: Flushing buffer cache inst=0 container=2 local
Pluggable database PDB$SEED closed
Completed: alter pluggable database pdb$seed close immediate instances=all
alter pluggable database pdb$seed OPEN READ ONLY instances=all
Database Characterset for PDB$SEED is AL32UTF8
Opening pdb PDB$SEED (2) with no Resource Manager plan active
Pluggable database PDB$SEED opened read only
Completed: alter pluggable database pdb$seed OPEN READ ONLY instances=all

alter pluggable database pdb$seed close immediate instances=all
ALTER SYSTEM: Flushing buffer cache inst=0 container=2 local
Pluggable database PDB$SEED closed
Completed: alter pluggable database pdb$seed close immediate instances=all
alter pluggable database pdb$seed OPEN READ WRITE
Database Characterset for PDB$SEED is AL32UTF8
Opening pdb PDB$SEED (2) with no Resource Manager plan active
Pluggable database PDB$SEED opened read write
Completed: alter pluggable database pdb$seed OPEN READ WRITE

XDB installed.

XDB initialized.

ORA-00600: internal error code, arguments: [qctbyt : bfc], [65532], [18446744073709551612], [1], [873], [1], [1], [0], [], [], [], []

 
The incident trace file shows characteristics like:

---- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x16b6c1ab30       913  package body APEX_050000.WWV_FLOW_META_DATA
0x16fb8e0100      3709  package body APEX_050000.WWV_FLOW
0x16d93971f8       173  procedure APEX_050000.F
0x16d9f08420        35  anonymous block

---- Call Stack ----

... qctbyt qctfrc qctsto2c qctsvcti qctcopn qctcpqb qctcpqbl qctcpqbl qctcpqb qctcpqbl ...


The DBA_REGISTRY shows the APEX component as invalid: 

COMP_ID        VERSION       STATUS    COMP_NAME
-------------- ------------- --------- --------------------------
...
APEX           5.0.1.00.06   INVALID   Oracle Application Express
...

 



Changes

 Trying to install APEX in PDB.

Cause

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 hundreds of Community platforms