9 Replies Latest reply: Aug 27, 2011 5:43 AM by user151917 RSS

    shutdown does not finish

    user522961
      Hi,
      on 10 gR2 on Win 2003 , I issued shutdown immediate and I have the following in alertlog :
      Sat Aug 27 09:12:30 2011
      Shutting down instance (immediate)
      License high water mark = 47
      Sat Aug 27 09:12:30 2011
      Stopping Job queue slave processes
      Sat Aug 27 09:12:30 2011
      Job queue slave processes stopped
      Sat Aug 27 09:17:29 2011
      Active call for process 5576 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
      SHUTDOWN: waiting for active calls to complete.
      Sat Aug 27 09:31:45 2011
      MMNL absent for 1203 secs; Foregrounds taking over
      Sat Aug 27 09:40:24 2011
      Thread 1 advanced to log sequence 720671
        Current log# 1 seq# 720671 mem# 0: U:\ORADATA\mydb\mydb_REDO01.LOG
      I can not connect from another sqlplus session for my be shutdown abort.
      sqlplus sys@mydb as sysdba
      
      SQL*Plus: Release 10.2.0.3.0 - Production on Sat Aug 27 09:46:59 2011
      
      Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
      
      Enter password:
      ERROR:
      ORA-12518: TNS:listener could not hand off client connection
      
      Enter user-name: sys as sysdba
      Enter password:
      ERROR:
      ORA-01031: insufficient privileges
      
      
      Enter user-name: system
      Enter password:
      ERROR:
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      What do you sugest ?
      Thank you.