Database Administration (MOSC)

MOSC Banner

ALTER SYSTEM QUIESCE RESTRICTED never finishes

edited Dec 7, 2012 3:23AM in Database Administration (MOSC) 9 commentsAnswered
Hello everyone,

  We are trying to get some End-Of-Month procedures automated for our accouting application on Oracle.  We'd like to Quiesce the 10.2.0.5 database and have an AS SYSDBA login do the procedures.  We've tested quiescing an empty 10g database, and it works fine with the Default Resource Manager settings.  It seems to work with Grid's 12c Agent turned on for that database's host also.  If someone is logged into the application, though, the ALTER SYSTEM statement never finishes (or, at least takes longer then 1 hour and 20 minutes when i came back from lunch)  The logged in user does

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center