ORA-7445 [kghalp()+48] while Opening the Database
(Doc ID 2128884.1)
Last updated on FEBRUARY 22, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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 = <ORACLE_HOME>
System name: Linux
Node name: <NODE_NAME>
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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_108281/<sid>_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 = <ORACLE_HOME>
System name: Linux
Node name: <NODE_NAME>
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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<sid>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_108281/<sid>_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 ...
Changes
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 |