Re: Keeping users out
- From: adrian angelov <adrian_angelov@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx, Sharon.Kovac@xxxxxxxxxxxxxxx
- Date: Mon, 23 Nov 2009 09:05:26 -0800 (PST)
Hi,
I totally agree with Niall.
Just to add a feature that might be of interest:
alter system quiesce restricted;
... do your work as SYS or SYSTEM(if it's an option ... not a good practice )
alter system unquiesce;
Details available on
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#SQLRF00902
Adrian Angelov
________________________________
From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: Sharon.Kovac@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Mon, November 23, 2009 6:55:05 PM
Subject: Re: Keeping users out
Hi Sharon,
What's the business process/ comms channel between your dept and Australia?
They've obviously had to make business arrangements (overtime etc) to get this
shift added. If you do find a successful technical solution it isn't hard to
imagine that you may just cause a further political issue. Equally you
obviously have a pre arranged maintenance window. This sounds like an issue to
escalate via both layers of management to get the right business decision made.
Niall
p.s. a load balancer like an F5 box could be a hardware solution to your
problem, just take access to boxes out of the load balancer...
On Mon, Nov 23, 2009 at 4:16 PM, <Sharon.Kovac@xxxxxxxxxxxxxxx> wrote:
>Hi everyone,
>
>Currently, we have Sunday mornings reserved for maintenance/updates/ whatever
>we need. This has worked great in the past. However, our site in Australia
>has added a third shift on Sunday night which is 7am my local time, right in
>the middle of our maintenance window. I'm looking for suggestions as to how
>to keep users out even though the database and the E-Business Suite are up.
>The twist that makes this difficult is that I still need the db and the apps
>available for my local super-users. For example, I recompile some packages,
>alter some tables and add a new form. Now I need the super-users to test the
>changes that I just made. How can I allows those users in and keep the
>Aussies out? Is there a hardware solution?
>
>Thanks!
>Sharon
>
>
>Sharon Kovac |RotoMetrics
>Phone: +1 636 587 3600 |Fax: +1 636 587 3701
>800 Howerton Lane |Eureka, MO 63025 |USA
>www.rotometrics.com
>
>
>
>
>---------------------------------------------------------------------
>This e-mail message is intended only for the personal use of the recipient(s)
>named above. This message is confidential. If you are not an intended
>recipient, you may not review, copy or distribute this message. If you have
>received this communication in error, please notify the sender immediately by
>e-mail and delete the original message.
>---------------------------------------------------------------------
>
>.
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
