0

My question is what can I delete or how can I free space so that I can log onto oracle via sqlplus as sysdba. When I execute the command df -k to see the free space in the current directory it appears to be full and on the other machine its at 52%.

Filesystem                   1K-blocks     Used        Available  Use%    Mounted on

/dev/mapper/rootvq-rootlv    51606140    48985496      0          100%    /

1 Answer 1

3

If your oracle installation is on your root volume you should have a look at the DIAG_DESTINATION, e.g. /u01/app/oracle/diag/. If there's a lot of old trace files in there you can safely remove them with adrci. If your oracle installation is on a separate disk you have to check where the space is consumed (/var?) and free space there.

2
  • removing the old trace file and the .aud files did the job. Thanks.
    – Givko
    Dec 29, 2016 at 14:42
  • /u01/app/oracle/product/<VERSION>/<DB>/bin/adrci purge
    – Ivan Chau
    Oct 21, 2020 at 8:33

Not the answer you're looking for? Browse other questions tagged or ask your own question.