3 Replies Latest reply: Jun 21, 2012 10:34 PM by Sunthar Tharmalingam RSS

    SHUTDOWN: Active sessions prevent database close operation

    arizuddin
      Hi

      Yesterday morning, our Oracle Apps Database did not shutdown and throws the following error.

      Fri May 11 06:57:18 2012
      Active call for process 2031784 user 'xxxl' program 'oracleyyy@zzz'
      SHUTDOWN: waiting for active calls to complete.
      Fri May 11 07:04:01 2012
      Incremental checkpoint up to RBA [0x165b.1b2b21.0], current log tail at RBA [0x165b.1b2b21.0]
      Fri May 11 07:11:14 2012
      MMNL absent for 1203 secs; Foregrounds taking over
      Fri May 11 07:24:05 2012
      Incremental checkpoint up to RBA [0x165b.1b2b42.0], current log tail at RBA [0x165b.1b2b4a.0]
      Fri May 11 07:44:10 2012
      Incremental checkpoint up to RBA [0x165b.1b2b6f.0], current log tail at RBA [0x165b.1b2b7d.0]
      Fri May 11 07:52:18 2012
      SHUTDOWN: Active sessions prevent database close operation
      Fri May 11 08:04:39 2012

      Since last 3 years, we never faced such a situation even though many modules (oracle Apps) were implemented from time to time. This time OTL module is going live and consultants were running some procedure during backup start time.

      Even after issuing 'addbctl.sh stop immediate', how come oracle did not close all the database sessions? How to prevent such situation in future?

      Any help is highly appreciated.

      Regards
      Arizuddin