ORA-01034: ORACLE not available

I was getting the following errors with an Oracle database today. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist I fixed this by getting to a command prompt and doing the following set oracle_sid = sqlplus /nolog conn system/ as sysdba shutdown abort startup Database came back up, connection was good!