Skip to main content

Posts

Showing posts from July, 2016

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 /opt Filesystem             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 /o

Oracle installation Windows 2008 R2 (6.1)

If you are trying to install  Oracle 10g over windows server 2008 R2 (6.1) but it gives error that OS is not supported. The workaround is here: simpliest way is to use --IgnoreSysPrereqs key to avoud system check. more complex - locate file oraparam.ini under install directory of your db dstributive and modify string Windows=5.0,5.1,5.2,6.0, 6.1