ORA-7445 [kghalp()+48] while Opening the Database
(Doc ID 2128884.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Linux x86-64
Symptoms
Database startup fails with error ORA-7445 [kghalp] in the alert log like:
Starting ORACLE instance (normal)
...
Starting up:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.1/dbhome_1
System name: Linux
Node name: pheng01dbadm02.homes.corpnet.pulte.com
Release: 2.6.39-400.264.1.el6uek.x86_64
Version: #1 SMP Wed Aug 26 16:42:25 PDT 2015
Machine: x86_64
Storage: Exadata
...
Mon Nov 16 18:09:29 2015
ALTER SYSTEM SET resource_manager_plan= SCOPE=MEMORY;
Mon Nov 16 18:09:29 2015
ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY;
Resource Manager disabled during database migration
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5B] [PC:0xB830660, kghalp()+48] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/cdbdr4/cdbdr4/trace/cdbdr4_ora_117924.trc (incident=108281):
ORA-07445: exception encountered: core dump [kghalp()+48] [SIGSEGV] [ADDR:0x5B] [PC:0xB830660] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/cdbdr4/cdbdr4/incident/incdir_108281/cdbdr4_ora_117924_i108281.trc
...
...
Starting up:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/12.1.0.1/dbhome_1
System name: Linux
Node name: pheng01dbadm02.homes.corpnet.pulte.com
Release: 2.6.39-400.264.1.el6uek.x86_64
Version: #1 SMP Wed Aug 26 16:42:25 PDT 2015
Machine: x86_64
Storage: Exadata
...
Mon Nov 16 18:09:29 2015
ALTER SYSTEM SET resource_manager_plan= SCOPE=MEMORY;
Mon Nov 16 18:09:29 2015
ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY;
Resource Manager disabled during database migration
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5B] [PC:0xB830660, kghalp()+48] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/cdbdr4/cdbdr4/trace/cdbdr4_ora_117924.trc (incident=108281):
ORA-07445: exception encountered: core dump [kghalp()+48] [SIGSEGV] [ADDR:0x5B] [PC:0xB830660] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/cdbdr4/cdbdr4/incident/incdir_108281/cdbdr4_ora_117924_i108281.trc
...
The trace file shows characteristics like:
----- Current SQL Statement for this session (sql_id=5h75b6g8w23y5) -----
ALTER DATABASE OPEN MIGRATE
----- Call Stack Trace -----
... kghalp kgskigetelt kgskigetsagecdbob kskmsgsage kskplwfin kskopen adbdrv_options adbdrv opiexe opiosq0 kpoal8 opiodr ...
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 |
| Cause |
| Solution |
| References |