alter system quiesce restricted never finishes
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Tue, 27 Nov 2012 12:04:19 -0500
Message-ID: <20121127170419.105510_at_gmx.com>
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 not have to be doing anything, just have the application up. I've looked at what Cursors that user has open and the only "transaction" i can see is Auditing insertion into sys.AUD$ I've went through Google and Metalink, and have queried v$blocking_quiesce and v$lock views (found that in Metalink) but even with nothing coming back from those queries, the command never finishes if someone is simply logged into the Forms application. Can a database be quiesced if Auditing is turned on? Anybody know what i'm doing wrong? Thanks,
Lyall Barbour
Date: Tue, 27 Nov 2012 12:04:19 -0500
Message-ID: <20121127170419.105510_at_gmx.com>
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 not have to be doing anything, just have the application up. I've looked at what Cursors that user has open and the only "transaction" i can see is Auditing insertion into sys.AUD$ I've went through Google and Metalink, and have queried v$blocking_quiesce and v$lock views (found that in Metalink) but even with nothing coming back from those queries, the command never finishes if someone is simply logged into the Forms application. Can a database be quiesced if Auditing is turned on? Anybody know what i'm doing wrong? Thanks,
Lyall Barbour
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 27 2012 - 18:04:19 CET