Wednesday, October 23, 2019

Logical standby sync stopped with error ORA-07445 kxsFrameAllocate()+416 SIGSEGV


Issue:-

Logical standby sync operation has been failed with below error.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FE4AE512D94] [PC:0x10DAB5D0, kxsFrameAllocate()+416] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/xxxx/xxxx/trace/xxxxx_as01_13493.trc  (incident=23523):
ORA-07445: exception encountered: core dump [kxsFrameAllocate()+416] [SIGSEGV] [ADDR:0x7FE4AE512D94] [PC:0x10DAB5D0] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
ORA-26808: Apply process AS01 died unexpectedly.
ORA-00447: fatal error in background process


Fix:-


Follow the metalink id:-
Logical Standby Apply Process Aborts with ORA-7445[kxsEphemeralFramePush] (Doc ID 1332064.1)

Temporary Fix:-

Execute the below command and restart apply process.

 exec dbms_logstdby.apply_set('_DATA_LAYER','FALSE')

Permanent Fix:-
Apply the patch the oneoff patch 28777050 

Sunday, September 22, 2019

Oracle DBCA hanging and not creating database


Oracle DBCA hanging and not creating database

Error:-
Database creation hung database after 56% in windows server in oracle 12c.

Reason:-
DBCA should be triggered by the user who is member of ORA_DBA group. Add the user in this group and run DBCA console. Without adding in the group, dbca hungs at 56% Even, if the user try to run dbca as administrator