My Oracle Support Banner

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 21, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 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.

Symptoms

1] ASMCMD shows ASMCMD-8102 error  

[grid@node1]$ asmcmd

Connected to an idle instance.
ASMCMD> ls
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 12.1.0.1.0 Production on Sun Mar 1 22:59:47 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
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 18989 1 0 2014 ? 00:37:58 asm_pmon_+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
... 

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.