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. I looked at the space situation and it looked … Continue reading Oracle: Resolve ORA-00257 – Connect AS SYSDBA only until resolved

Advertisements

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

I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux.┬áThis is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive