Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.