Skip to main content

ORA-09925:Unable to create audit trail file

Once u got this check filesystem to have enough disk space with running 
df -h 
In my case I had over 27% free but still got the same error, then look at Inodes:
bash-3.2# df -o i /optFilesystem             iused   ifree  %iused  Mounted on/dev/dsk/c1t0d0s5    4280640       0   100%   /opt
Catcha!

 Ok now we must find that busty folder with a lot of files 
#for i in /opt/*; do echo $i; find $i |wc -l; done
This command will list directories and number of files in them. Once you see a directory with unusually high number of files (or command just hangs over calculation for a long time), repeat the command for that directory to see where exactly the small files are.
repeat it until you will have
bash-3.2# for i in /opt/oracle/app/oracle/product/grid/rdbms/*; do echo $i; find $i |wc -l; done
/opt/oracle/app/oracle/product/grid/rdbms/admin
    1683
/opt/oracle/app/oracle/product/grid/rdbms/audit
 4229135
/opt/oracle/app/oracle/product/grid/rdbms/demo
       2
/opt/oracle/app/oracle/product/grid/rdbms/doc
       3
/opt/oracle/app/oracle/product/grid/rdbms/install
      22
/opt/oracle/app/oracle/product/grid/rdbms/jlib
      30
/opt/oracle/app/oracle/product/grid/rdbms/lib
     132
/opt/oracle/app/oracle/product/grid/rdbms/log
       8
/opt/oracle/app/oracle/product/grid/rdbms/mesg
     190
/opt/oracle/app/oracle/product/grid/rdbms/public
       5
/opt/oracle/app/oracle/product/grid/rdbms/utl
       8
/opt/oracle/app/oracle/product/grid/rdbms/xml
     460

And then clean up that audit folder.
Well done! Applause! Relax and have some tea.

Comments

  1. technodeFebruary 20, 2017 at 11:00 PM

    Nice article , thanks for sharing , very informative and presented nice , keep updating morered hat linux administration training in chennai|red hat training in chennai|RHCE training in chennai|red hat training center in chennai|red hat training partner in chennai|red hat linux certification training in chennai

    ReplyDelete
  2. UnknownJanuary 24, 2018 at 5:20 AM

    Telangana State Engineering Agricultural and Medical Common Entrance Test TS EAMCET is a state level entrance examination conducted in the state of Telangana for the selection of candidates into Engineering and Medicine and Agriculture courses. It is conducted by Jawaharlal Nehru technical Institute (JNTU) on behalf of TSCHE.

    ReplyDelete

Post a Comment

Popular posts from this blog

Solaris. remove unusable scsi lun

Solaris remove unusable or failing scsi lun 1. The removed devices show up as drive not available in the output of the format command: # format Searching for disks...done ................      255. c1t50000974082CCD5Cd249 <drive not available>           /pci@3,700000/SUNW,qlc@0/fp@0,0/ssd@w50000974082ccd5c,f9 ................      529. c3t50000974082CCD58d249 <drive not available>           /pci@7,700000/SUNW,qlc@0/fp@0,0/ssd@w50000974082ccd58,f9 2. After the LUNs are unmapped Solaris displays the devices as either unusable or failing. # cfgadm -al -o show_SCSI_LUN | grep -i unusable # # cfgadm -al -o show_SCSI_LUN | grep -i failing c1::50000974082ccd5c,249       disk         connected    configured   failing c3::50000974082ccd58,249 ...
1 comment
Read more

memory error detect XSCF uboot

If you see something like this when you poweron you server: memory error detect 80000008, address 000002d0 data 55555555 -> fbefaaaa capture_data hi fbefaaaa lo deadbeef ecc 1b1b capture_attributes 01113001 address 000002d0 memory error detect 80000008, address 000002d4 data aaaaaaaa -> deadbeef capture_data hi fbefaaaa lo deadbeef ecc 1b1b capture_attributes 01113001 address 000002d4 memXSCF uboot  01070000  (Feb  8 2008 - 11:12:19) XSCF uboot  01070000  (Feb  8 2008 - 11:12:19) SCF board boot factor = 7180     DDR Real size: 256 MB     DDR: 224 MB Than your XSCF card is broked. Replace it with new one. After that it will ask you for enter chassis number - located at front of the server XSCF promt to enter your chasses number ( is a S/N of your server ): Please input the chassis serial number : XXXXXXX 1:PANEL Please select the number : 1 Restoring data from PANEL to XSCF#0. Please wait for se...
1 comment
Read more

SPARC OBP cheatsheet

Boot PROM Basics Boot PROM(programmable read only memory): It is a firmware (also known as the monitor program) provides: 1. basic hardware testing & initialization before booting. 2. contains a user interface that provide access to many important functions. 3. enables the system to boot from wide range of devices. It controls the system operation before the kernel becomes available. It provides a user interface and firmware utility commands known as FORTH command set. These commands include the boot commands, the diagnostic commands & the commands for modifying the default configuration. Command to determine the version of the Open Boot PROM on the system: # /usr/platform/'uname -m'/sbin/prtdiag -v (output omitted) System PROM revisions: ---------------------- OBP 4.16.4 2004/12/18 05:21 Sun Blade 1500 (Silver) OBDIAG 4.16.4.2004/12/18 05:21 # prtconf -v OBP 4.16.4 2004/12/18 05:21 Open Boot Architectures Standards: It is based on IEEE standard #1275, accord...
Post a Comment
Read more