Troubleshoot Fix unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 17946

Error Description:
In my database alert log I am seeing following error keep on generating periodically. Even though I have enough space in ASM I am not able to resize the datafile, add datafile etc.
ERROR: unrecoverable error ORA-29701 raised in ASM I/O path; terminating process 16956

Solution Description:
The error is looks like some permission / space issue in ASM instance. When I checked the ASM alert.log file it shows like the database is not able to create some trace files to the file system. I cleared some space in the file system and which fixed the issue.
Below mentioned is the error which I got from the ASM alert.log file. Also check whether the ASM has sufficient permissions to write the files on the file system.

Thu Jan 06 08:46:12 2012
Non critical error ORA-00001 caught while writing to trace file "/u01/app/oracle/asm/+asm/+ASM/trace/+ASM_m000_20936.trc"
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google