title: ORA-01012: not logged on While executing alter system flush shared_pool;
body: <p>I want to flush shared pool because of error like </p>
  
  <pre><code>ORA-04031: unable to allocate 32 bytes of shared memory 
  </code></pre>
  
  <p>So I want to flush shared pool using </p>
  
  <pre><code>alter system flush shared_pool;
  </code></pre>
  
  <p>Connected as sysdba using </p>
  
  <pre><code>hwflow08:flman800 &gt; sqlplus "conn as sysdba"
  
  SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jan 28 05:39:56 2015
  
  Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
  
  Enter password: Connected.
  </code></pre>
  
  <p>While executing alter system command we faced ORA-01012</p>
  
  <pre><code>SQL&gt; alter system flush buffer_cache;
  alter system flush buffer_cache
  *
  ERROR at line 1:
  ORA-01012: not logged on
  </code></pre>
  
  <p>Can anyone please guide how can I flush the Shared Pool ? (I dont want to shutdown the DB)</p>