title: Oracle database error (ORA-12505, ORA-01078, ORA-00600)
body: <p>I am a beginner who has just begun to study Spring. And I'm using Boot Camp on a MacBook. I am having a problem linking SQL Developer to my database. </p>
  
  <p>I downloaded Oracle 11g Express Edition and SQL Developer to link Oracle database to use STS. But an ORA-12505 error occurred in SQL Developer when I tried to connect.</p>
  
  <p>To solve that I tried to run SQL*Plus but got ORA-01034 and ORA-27101 errors (I think caused by the database being shut down). To solve those errors, I tried the following.</p>
  
  <pre><code>sqlplus /nolog
  conn sys/as sysdba
  </code></pre>
  
  <p>which said "Connected to an idle instance", so I tried:</p>
  
  <pre><code>shutdown abort
  startup
  </code></pre>
  
  <p>but that got:</p>
  
  <pre><code>ORA-01078: failure in processing system parameters
  ORA-00600: internal error code, arguments: [kspifisp:ksfdread_resilver], [0x000A9FA68],
             [0x000A9F800], [512], [], [], [], [], [], [], [], []"
  </code></pre>
  
  <p>I tried </p>
  
  <pre><code>show parameter undo
  </code></pre>
  
  <p>but that just got "ORA-01034 ORACLE not available" again.</p>
  
  <p>I don't know where it's wrong because of so many errors. I think the root of all this error is the lack of <code>spfile</code>, but I haven't found a solution to it.</p>
  
  <p>How can I resolve this?</p>