Posted on 2013-05-20
Last Modified: 2013-06-06
Is there any permanent solution for this problem..

[oracle@term1 dbs]$ ls
hc_DBUA0.dat  initorcl.ora  orapworcl      peshm_prim_0    spfileprim.ora
hc_orcl.dat   initprim.ora  orapwprim      snapcf_orcl.f
hc_prim.dat   lkORCL        peshm_DBUA0_0  snapcf_prim.f
init.ora      lkPRIM        peshm_orcl_0   spfileorcl.ora
[oracle@term1 dbs]$ . oraenv prim
ORACLE_SID = [prim] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@term1 dbs]$ sqlplus / as sysdba

SQL*Plus: Release Production on Mon May 20 09:40:25 2013

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

ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on

Enter user-name:
Question by:walkerdba
  • 3
  • 2
  • 2
  • +1

Expert Comment

ID: 39181853
Sounds like a space issue, have you attempted to expand the filesystem size?

Check the value of the AUDIT_FILE_DEST parameter, this will point you where the sys audit operation are recorded. Probably you don't have privileges to write on that path or the path is full, so you are unable to write the sys user log.

Writing sys audit records is an operation configured by default. Check the value of the instance parameter AUDIT_SYS_OPERATIONS.
Source URL

Author Comment

ID: 39183465
this is the init.ora file
how will I find out from this ..

orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/orcl/archive_log valid_for=(all_logfiles,all_roles) db_unique_name=orcl'
*.log_archive_dest_2='service=newdb valid_for=(online_logfiles,primary_role) db_unique_name=orcl'
LVL 19

Expert Comment

ID: 39183850
run a df -hi and see if there is anything thats 100% or close to it and increase the space as needed if you can.
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39184104
>>how will I find out from this ..

With *.audit_trail='db' you are not writing audit records to the file system so that isn't it.

Use the df command above to find out what file system is full.  Given that you are writing audit records to the database, you have filled up one of the database file folders if you have auto extend turned on or you have filled up a datafile.

Check the database alert log for more information.
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)


Author Comment

ID: 39190879
[oracle@term1 ~]$ df -hi
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/sda2               3.5M    174K    3.3M    5% /
/dev/sda6               4.1M     42K    4.1M    1% /u01
/dev/sda5               1.3M      72    1.3M    1% /tmp
/dev/sda1                50K      33     49K    1% /boot
tmpfs                   190K       1    190K    1% /dev/shm
[oracle@term1 ~]$ df -hi
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/sda2               3.5M    174K    3.3M    5% /
/dev/sda6               4.1M     42K    4.1M    1% /u01
/dev/sda5               1.3M      72    1.3M    1% /tmp
/dev/sda1                50K      33     49K    1% /boot
tmpfs                   190K       1    190K    1% /dev/shm
LVL 76

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 39190898
As I posted in http:#a39184104,  File system space likely isn't the issue.

My guess is you have filled up a datafile/tablespace and it is not set to auto extend.

There is a query in the link below that shows tablespace usage.  I'm thinking you will find one that is about at capacity.
LVL 19

Expert Comment

ID: 39193874
sorry, df -h, the i was a typo.... my bad.

Author Closing Comment

ID: 39226978

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Fastest way to replace data in Oracle 5 51
Exchange 2010 unable to mount DB due to corruption 11 71
oracle 11g 23 51
Error Message during CentOS 7 Minimal Install 3 34
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now