When connecting ASM it gives ASMCMD-8102: no connection to Oracle ASM or ORA-09925: Unable To Create Audit Trail File While Trying To Connect To ASM Instance as SYSDBA
(Doc ID 1987611.1)
Last updated on DECEMBER 23, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
1] ASMCMD shows ASMCMD-8102 error
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
2] Manual connection to ASM using sqlplus shows ORA-09925 error
[grid@node1]$ sqlplus / as sysasm
SQL*Plus: Release 126.96.36.199.0 Production on Sun Mar 1 22:59:47 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on
3] All ASM related background processes are up and running
[grid@node1]$ ps -ef | grep asm
grid 18991 1 0 2014 ? 00:39:31 asm_psp0_+ASM
grid 18993 1 1 2014 ? 2-05:12:31 asm_vktm_+ASM
grid 18997 1 0 2014 ? 00:08:19 asm_gen0_+ASM
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