How to solve the problem of SVR4 Error error in oracle
This article mainly explains the "oracle SVR4 Error error problem how to solve", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's train of thought slowly in depth, together to study and learn "oracle SVR4 Error error problem how to solve" it!
The application reflects that the database is slow, and it is slow to log in to instances and asm instances, but in the end, it can log in. Finally, the following error is reported when logging in:
Oracle@eedw1:/export/home/oracle $ora si
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 4 20:45:19 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
SVR4 Error: 49: Disc quota exceeded
Additional information: 9925
ORA-01075: you are currently logged on
Enter user-name:
Oracle@eedw1:
Check df-h and find that the / oracle directory is full and start cleaning up the disk directory.
Du-s* | sort-n
-- check the resources:
Grid@eedw1 $/ oracle/app/11.2.0/grid/bin/crsctl stat res-t-init
NAME TARGET STATE SERVER STATE_DETAILS
Cluster Resources
Ora.asm
1 ONLINE ONLINE eedw1 Started
Ora.cluster_interconnect.haip
1 ONLINE ONLINE eedw1
Ora.crf
1 ONLINE OFFLINE
Ora.crsd
1 ONLINE OFFLINE
Ora.cssd
1 ONLINE ONLINE eedw1
Ora.cssdmonitor
1 ONLINE ONLINE eedw1
Ora.ctssd
1 ONLINE ONLINE eedw1 OBSERVER
Ora.diskmon
1 OFFLINE OFFLINE
Ora.drivers.acfs
1 ONLINE ONLINE eedw1
Ora.evmd
1 ONLINE ONLINE eedw1
Ora.gipcd
1 ONLINE ONLINE eedw1
Ora.gpnpd
1 ONLINE ONLINE eedw1
Ora.mdnsd
1 ONLINE ONLINE eedw1
Grid@eedw1 $
Note: ora.crf monitors resources for Cluster Health Monitor clusters, similar to OSWATCHER resource monitoring, but is rarely used now
Grid@eedw1 $/ oracle/app/11.2.0/grid/bin/crsctl start res ora.crsd-init
CRS-2672: Attempting to start 'ora.crsd' on' eedw1'
CRS-2676: Start of 'ora.crsd' on' eedw1' succeeded
Grid@eedw1 $
Grid@eedw1 $/ oracle/app/11.2.0/grid/bin/crsctl stat res-t-init
NAME TARGET STATE SERVER STATE_DETAILS
Cluster Resources
Ora.asm
1 ONLINE ONLINE eedw1 Started
Ora.cluster_interconnect.haip
1 ONLINE ONLINE eedw1
Ora.crf
1 ONLINE OFFLINE
Ora.crsd
1 ONLINE ONLINE eedw1
Ora.cssd
1 ONLINE ONLINE eedw1
Ora.cssdmonitor
1 ONLINE ONLINE eedw1
Ora.ctssd
1 ONLINE ONLINE eedw1 OBSERVER
Ora.diskmon
1 OFFLINE OFFLINE
Ora.drivers.acfs
1 ONLINE ONLINE eedw1
Ora.evmd
1 ONLINE ONLINE eedw1
Ora.gipcd
1 ONLINE ONLINE eedw1
Ora.gpnpd
1 ONLINE ONLINE eedw1
Ora.mdnsd
1 ONLINE ONLINE eedw1
Grid@eedw1 $
Grid@eedw1 $
Grid@eedw1 $crsctl stat res-t
NAME TARGET STATE SERVER STATE_DETAILS
Local Resources
Ora.ARCHDG.dg
ONLINE ONLINE eedw1
Ora.DATADG01.dg
ONLINE ONLINE eedw1
Ora.DATADG02.dg
ONLINE ONLINE eedw1
Ora.DATADG03.dg
ONLINE ONLINE eedw1
Ora.DATADG04.dg
ONLINE ONLINE eedw1
Ora.DATADG05.dg
ONLINE ONLINE eedw1
Ora.DATADG06.dg
ONLINE ONLINE eedw1
Ora.DATADG07.dg
ONLINE ONLINE eedw1
Ora.DATADG08.dg
ONLINE ONLINE eedw1
Ora.DATADG09.dg
ONLINE ONLINE eedw1
Ora.DATADG10.dg
ONLINE ONLINE eedw1
Ora.LISTENER.lsnr
ONLINE ONLINE eedw1
Ora.OCRVOTEDG.dg
ONLINE ONLINE eedw1
Ora.asm
ONLINE ONLINE eedw1 Started
Ora.gsd
OFFLINE OFFLINE eedw1
Ora.net1.network
ONLINE ONLINE eedw1
Ora.ons
ONLINE ONLINE eedw1
Ora.registry.acfs
ONLINE ONLINE eedw1
Cluster Resources
Ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE eedw1
Ora.cvu
1 ONLINE ONLINE eedw1
Ora.eedw.db
1 ONLINE ONLINE eedw1 Open
2 ONLINE OFFLINE
Ora.eedw1.vip
1 ONLINE ONLINE eedw1
Ora.eedw2.vip
1 ONLINE INTERMEDIATE eedw1 FAILED OVER
Ora.oc4j
1 ONLINE ONLINE eedw1
Ora.scan1.vip
1 ONLINE ONLINE eedw1
Grid@eedw1 $
Thank you for your reading, the above is the content of "how to solve the problem of SVR4 Error error in oracle". After the study of this article, I believe you have a deeper understanding of how to solve the problem of SVR4 Error error in oracle, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
