My Oracle Support Banner

The instance hangs in RAC environment with archiver issues ORA-19504,ORA-17502,ORA-17500 (Doc ID 2378546.1)

Last updated on MARCH 24, 2024

Applies to:

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 Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 

The instance hangs with below errors in RAC environment.
There is some issue with the archive location for LOG_ARCHIVE_DEST_1 meaning that the logs cannot be archived.
If you are in archive log mode you cannot switch through all of the logs until they have been archived, so until the archiver is freed the process
performing the log switch will hang, Archiver cannot just overwrite the online log without it being archived.
The issue happens when dnfs enabled environment. ARC file starts with . denies the new file to get created in the same name

 

inst1
~~~~~
Unable to create archive log file '/node1/arch/node1_2367_1_6.arc'
ORA-19504: failed to create file "/node1/arch/node1_2367_1_6.arc"
ORA-17502: ksfdcre:4 Failed to create file
/node1/arch/node1_2367_1_6.arc
ORA-17500: ODM err:File exists

inst2
~~~~~
Unable to create archive log file '/node1/arch/node1_2367_2_5.arc'
ORA-19504: failed to create file "/node1/arch/node1_2367_2_5.arc"
ORA-17502: ksfdcre:4 Failed to create file
/node1/arch/node1_2367_2_5.arc
ORA-17500: ODM err:File exists

pstack of archive process id shows

[root@node1 ~]# pstack <archive process id>
#0 0x00007f3f02936de0 in __poll_nocancel () from /lib64/libc.so.6
#1 0x00007f3f05f44dab in sipcgxp_poll () from
/cdbcc122/oracle/product/12201/lib/libipc1.so
#2 0x00007f3f05f42969 in ipcgxp_selectex () from
/cdbcc122/oracle/product/12201/lib/libipc1.so
#3 0x00007f3f05dce085 in ipclw_wait () from
/cdbcc122/oracle/product/12201/lib/libipc1.so
#4 0x00000000063fb824 in ksxpwait_ipclw ()
#5 0x00000000063b3647 in ksxpwait_int ()
#6 0x00000000063b3afd in ksxpwait ()
#7 0x0000000010a12935 in ksliwat ()
#8 0x0000000010a0fab5 in kslwaitctx ()
#9 0x0000000006dbbd52 in kjusuc ()
#10 0x000000000d61290e in ksigeti ()
#11 0x0000000003298626 in ksbcic_int ()
#12 0x000000000cdc223a in kcrf_switch_all_logfile ()
#13 0x0000000007cafaa4 in kcb_tsemk_rekey ()
#14 0x000000000a405ccd in kzekmsmk ()
#15 0x000000000a475684 in kzckmaeke ()
#16 0x000000000a4795db in kzckmrekapdb ()
#17 0x000000000a4758b3 in kzckmrek ()
#18 0x000000000a49cd47 in kzckmrgek ()
#19 0x000000000a491006 in kzckmrgrek ()
#20 0x000000000dc1a32f in akmdrv ()
#21 0x0000000010c59e9e in opiexe ()
#22 0x0000000010e8d34e in opiosq0 ()
#23 0x00000000025dae38 in kpooprx ()
#24 0x00000000025d8682 in kpoal8 ()

 

 

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.