Archiving Redo Logs Fails With ORA-19510, ORA-27086 Linux-x86_64 Error: 37: No locks available

(Doc ID 1418233.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***

Symptoms

Redo Log switching stopped due to following archival errors:

ORA-19510: failed to set size of 203 blocks for file "/opt/archivelog/2012_02_12/o1_mf_1_102_7mkjgtf7_.arc" (blocksize=512)
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
ARCH: Error 19510 Closing archive log file '/opt/archivelog/2012_02_12/o1_mf_1_102_7mkjgtf7_.arc'
Sun Feb 12 23:56:01 PST 2012
ORA-16038: log 1 sequence# 102 cannot be archived
ORA-19510: failed to set size of blocks for file "" (blocksize=)
ORA-00312: online log 1 thread 1: '/opt/oracle/db/oradata/TEST/log01.dat'
Sun Feb 12 23:56:03 PST 2012
ARCH: Archival stopped, error occurred. Will continue retrying
Sun Feb 12 23:56:03 PST 2012
ORACLE Instance TEST - Archival Error
Sun Feb 12 23:56:03 PST 2012
ORA-16014: log 1 sequence# 102 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/opt/oracle/db/oradata/TEST/log01.dat'
Sun Feb 12 23:56:03 PST 2012
Errors in file /opt/app/oracle/admin/TEST/bdump/test_arc1_6244.trc:
ORA-16014: log 1 sequence# 102 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/opt/oracle/db/oradata/TEST/log01.dat'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms