RE: alter system quiesce restricted never finishes
Date: Wed, 28 Nov 2012 18:02:30 +0000
Message-ID: <EC65ECF8123FEE4D8FC5B212637C30400165DE2EFF3C_at_EXCH1.morrisonsplc.co.uk>
I have not seen a response to this yet (and to be honest I have never found a use for the quiesce database command). Is the issue that the user is logged in as a sysdba user and therefore may be doing 'priviliged work'.
Why are you considering the use of the quiesce database command Lyall over say bouncing and starting up in restricted mode?
John
www.jhdba.wordpress.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyall Barbour
Sent: 27 November 2012 17:04
To: oracle-l_at_freelists.org
Subject: alter system quiesce restricted never finishes
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-l
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
--
http://www.freelists.org/webpage/oracle-l Received on Wed Nov 28 2012 - 19:02:30 CET