ORA-7445[pfrins()+196] During Apex Installation
(Doc ID 2874964.1)
Last updated on JULY 21, 2023
Applies to:
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and laterInformation in this document applies to any platform.
APEX has been installed and then un-installed. Now in a second intent to install it is showing the error.
Symptoms
We are facing ORA-07445 during apex installation.
ORA-07445: exception encountered: core dump [pfrins()+196] [SIGSEGV] [ADDR:0x28] [PC:0x540FF64] [Address not mapped to object] []
In incident trc file observed:
----- PL/SQL Call Stack -----
object line object
handle number name
0xe6585388 1642 package body APEX_040200.WWV_FLOW_WS_SETUP
0xe6585388 1797 package body APEX_040200.WWV_FLOW_WS_SETUP
0xf34ce390 3 anonymous block
[TOC00005-END]
--- Abridged Call Stack Trace -----
ksedsts()+244<-kjzdssdmp()+321<-kjzduptcctx()+692<-kjzdpcrshnfy()+347<-kstdmp()+352<-dbkedDefDump()+8728<-ksedmp()+261<-ssexhd()+2660<-sslsshandler()+456<-__sighandler()<-pfrins()+196<-pfri1_inst_spec()+463<-pfrrun()+5138<-plsql_run()+712<-peicnt()+284<-kkxexe()+1200
<-opiexe()+13318<-kpoal8()+2856<-opiodr()+1165<-ttcpip()+2491
[04]: sslsshandler []<-- Signaling
[05]: __sighandler []
[06]: pfrins [PLSQL_Code_Execution]
[07]: pfri1_inst_spec [PLSQL_Code_Execution]
[08]: pfrrun [PLSQL_Code_Execution]
[09]: plsql_run [PLSQL_PSD_Standalones]
[10]: peicnt [PLSQL_Code_Execution]
[11]: kkxexe [PROGINT_PLSQL]
[12]: opiexe [Time_Limit]
[13]: kpoal8 [PROGINT_MISC]
[14]: opiodr [OPI]
[15]: ttcpip []
Changes
APEX has been installed and then un-installed.
@In this case in particular it seems the clean-up was tried when ORDS was still open so apex_public_user was not cleaned and also the APEX on the PDB was local NOT Inherited, so it had to be manually cleaned.
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |