Oracle DB not starting properly. Error :ORA-01034: ORACLE not available

I have had an issue with Oracle starting properly at startup. When I access the Enter prise manager I get error "Error :ORA-01034: ORACLE not available".  When I try using the Recovery Settings I get "ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist". I followed the instructions in the post : http://www.experts-exchange.com/Databases/Oracle/Q_21250658.html
to try to recover the settings, but it will only restore the database until I restart.

Steps taken:
C:\>SET ORACLE_SID=ORCL
C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 23 18:31:13 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup pfile=C:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.1013200718051
ORACLE instance started.
Total System Global Area  595591168 bytes
Fixed Size                  1250356 bytes
Variable Size             163580876 bytes
Database Buffers          427819008 bytes
Redo Buffers                2940928 bytes
Database mounted.
Database opened.

SQL> create spfile='c:\spfileORCL.ora' from pfile='c:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.1013200718051';
File created.

**I then moved the SPFILEORCL.ORA to C:\oracle\product\10.2.0\db_1\dbs and renamed the old one to SPFILEORCL.ORA.OLD

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  595591168 bytes
Fixed Size                  1250356 bytes
Variable Size             197135308 bytes
Database Buffers          394264576 bytes
Redo Buffers                2940928 bytes
Database mounted.
Database opened.
SQL>
------------------------------------
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )  
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = orcl)
    )    
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = SEVM20)(PORT = 1521))
    )
  )
 
-----------------------------------------------------------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SEVM20)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )  

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
Start Free Trial