Oracle: Resolve ORA-00257 – Connect AS SYSDBA only until resolved

Recently, one of the Oracle users complained that the database was unusable and received the error below Check #1: Are we physically out of space? When the host is out of space on the drive/device where the FRA has been set, it can produce this error. We run Oracle on Windows. So, it could be …

Advertisement

Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

Update 2018/11/19: In 12c, you can now do this operation online. Please check out the “ALTER DATABASE MOVE DATAFILE” command which moves the file without you having to copy. Check it out here. I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log …