DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 17, 2017

Database goes down automatically after starts up.ORA-07445: exception encountered: core dump [kmmlrl()+6723] [SIGSEGV] [ADDR:0x8] [PC:0x8BB9B2D] [Address not mapped to object] []

ORA-07445: exception encountered: core dump [kmmlrl()+6723] [SIGSEGV] [ADDR:0x8] [PC:0x8BB9B2D] [Address not mapped to object] []


Symptoms

   After starting the database it goes down automatically with the following errors in the alert log file.

Completed: ALTER DATABASE OPEN 
Fri Jul 14 14:08:33 2017 
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x8BB9B2D, kmmlrl()+6723] 
Errors in file /Oracle/cig/app/cig/diag/rdbms/orcl/orcl/trace/orcl_pmon_14242.trc (incident=123636): 
ORA-07445: exception encountered: core dump [kmmlrl()+6723] [SIGSEGV] [ADDR:0x8] [PC:0x8BB9B2D] [Address not mapped to object] [] 
Incident details in: /Oracle/cig/app/cig/diag/rdbms/orcl/orcl/incident/incdir_123636/orcl_pmon_14242_i123636.trc 
Fri Jul 14 14:08:35 2017 
Trace dumping is performing id=[cdmp_20170714140835] 
Fri Jul 14 14:09:13 2017 
DBRM (ospid: 14250): terminating the instance due to error 472

Solution
-----------

Step 1:

     If you are using apex in your environment then comment the dispatcher patameter value in the parameter file and try to start the database.

Step 2:

   Now the database will start normally,but if you set the dispatcher value it will work and the dispatcher value will be taken.

Step 3:

  Now if you try to set the port for apex you will face the below error(for all the port it will throw the below error).

ORA-07445: exception encountered: core dump [kmmlrl()+6723] [SIGSEGV] [ADDR:0x8] [PC:0x8BB9B2D] [Address not mapped to object] [] 
Incident details in: /Oracle/cig/app/cig/diag/rdbms/orcl/orcl/incident/incdir_140436/orcl_pmon_15661_i140436.trc 
  

Step 4:
     
   Bounce the server and then set the port it will work fine,and apex will open.
    The issue is that port number

No comments: