| Ora-48181. no space left on the device [message #680506] |
Tue, 19 May 2020 04:43  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
Hi,
i have 11.2.0.4
i am receiving ORA-48181 with no space left on device, followed by
Error: Direct connection failure with ASM
WARNING:ASM communication error : op 0 state 0x0 (15055)
/u01/app/oracle/diag/asm/+asm/+ASM2/trace
what can be the reason? please guide
Regards
[Updated on: Tue, 19 May 2020 05:24] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Ora-48181. no space left on the device [message #680603 is a reply to message #680559] |
Sun, 24 May 2020 15:58  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
oracle error
Non Critical error ORA-48181 caught while writing to trace file "/u01/app/oracle/diag/rdbms/mygrid/mygrid12/trace/mygrid12_m000_210009.trc"
Error Messages: SVr4 Error: 28 : No space left on device
writing to the above trace file is disabled for now on
Error: Direct connection failure with ASM
WARNING:ASM communication error : op 0 state 0x0 (15055)
/dev/dsk/c0t500xxxxxxd0s4 439G 381G 54G 88% /u01
current development are when i tried to issue any query on SQL prompt i get following
ORA-09817: Write to audit file failed
please reply where to delete the old files
|
|
|
|
|
|
| Re: Ora-48181. no space left on the device [message #680610 is a reply to message #680604] |
Mon, 25 May 2020 12:09 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
Mr John i dont have copy paste facilty so i need to write it manually and as the system messages saying that it /u01 then i shown that . now all other file system are not 100% full. u can trust that. u saw the alert log errors , so if u want to help here the is time. all other file system have free space so if you can point some specific file system the tell me i will check it for you.
if you want to help, then help
regards
|
|
|
|
| Re: Ora-48181. no space left on the device [message #680611 is a reply to message #680610] |
Mon, 25 May 2020 14:14 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
Now the issue has escalated and following error is reported in alert log
Master Archival Failure:313
ARCH: Archival stopped, error occured
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '+TG1/mygrid/redo04_2.log
ORA-17503:ksfdopn:2 Failed to open file +Tg1/mygrid/redo04_02.log
ORA-15055: unable to connect to ASM instance
ORA-09925: unable to create audit trail
any help
|
|
|
|
|
|
| Re: Ora-48181. no space left on the device [message #680731 is a reply to message #680699] |
Thu, 04 June 2020 06:59 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
yes Michel
i put over there as well to have some help but my issue still persists. i have now rebooted the machine so if there are some file handles busy so they will be relieved and after 8 hrs of reboot. ORA-48181 appear again but currently the instance is up and might die again in few more days
u have any point?
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
