Solution : https://service.sap.com/sap/support/notes/658744 (SAP Service marketplace login required)
Summary :
The SAP Note addresses the Oracle error ORA-00600 [2103] caused by the inability of a process to lock the control file due to another process holding the CF enqueue. Key solutions include setting the _CONTROLFILE_ENQUEUE_TIMEOUT to manage locking duration, ensuring correct environments for NFS file setups, and maintaining NFS lock daemon activity to prevent control file lock issues. It also advises against simultaneous execution of Oracle operations like ADD DATAFILE and BEGIN BACKUP that can amplify control file access issues. Further, the note suggests consulting Oracle’s documentation and ensuring that no I/O-intensive OS processes interfere with database operations.
Key words :
/o-intensive operating system process 6, oracle meta link document 28045, missing nfs lock daemon 4, control file enqueueoracle enqueues, alter database backup controlfile, /o-intensive processes, operating system partner, operating system level, nfs lock daemon, long-lasting lock
Related Notes :
| 857847 | Oracle ora-600 and timeouts on AIX |
| 745639 | FAQ: Oracle enqueues |
| 192375 | Ora-600 [2103] |