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.
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.

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.

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Where Does Time Value Come From for Database Insert or Update 4 33
linux - yum package installation issue 2 58
IP / 61 56
oracle collections 2 20
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

856 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