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

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

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

FOS Password recovery (Brocade Fabric OS Switch Password recovery procedure)

Password recovery using root account If you have access to the root account, you can reset the passwords on the switch to default. This feature is available for all currently supported versions of the Fabric OS. Follow the below steps to reset any account password from the root account. 1. Open a CLI session (serial or telnet for an unsecured system and sectelnet for a secure system) to the switch. 2. Log in as root. 3. At the prompt, enter the passwddefault command as shown below: switch:root> passwddefault 4. Follow the prompts to reset the password for the selected account. For example: switch:root> passwddefault All account passwords have been successfully set to factory default. Once the passwords have been reset, log into the switch as admin, and modify your default passwords. Make sure to keep a hardcopy of your switch passwords in a secure location. The default passwords for Fabric OS switches are: Root fibranne Adminpassword Userpassword Password r...
4 comments
Read more