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 I looked at the space situation and it looked good (PowerShell command is from the dbatools module¬†and allows you to get this server space info. from your own host) Next, I looked at the alert log and saw … 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