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%    /

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.

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

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