Re: Re: 24 x 7 x 365

2003-12-15 Thread Jonathan Lewis
There is a problem with this approach that may only become apparent at high concurrency. Since you are operating with two-phase commits, you may come up against the case where writers block readers. Your client issues a commit to both servers. Each server get the PREPARE message, and when both

Re: Re: 24 x 7 x 365

2003-12-15 Thread Tanel Poder
Jonathan, Thanks for this valuable information. However, I'm using regular commits, not distributed two-phased ones and I just have simple code to handle the situation where servers return different success/error codes. Tanel. There is a problem with this approach that may only become

Re: Re: 24 x 7 x 365

2003-12-15 Thread Murali Vallath
Tanel, If this is the approach, then quite a bit of code would have to be developed on the front end to handle transaction integrity. For example when one fails and the other has completed the write successfully, they will have to be physically removed.What about if the record that is commited

RE: Re: 24 x 7 x 365

2003-12-15 Thread Matthew Zito
-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Monday, December 15, 2003 6:29 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: 24 x 7 x 365 Jonathan, Thanks for this valuable

Re: 24 x 7 x 365

2003-12-13 Thread Murali Vallath
t to remove every possible outage and it can be much easier to manage a small outage every few months. Regards, Mark. "Tracy Rahmlow" <[EMAIL PROTECTED] Multiplerecipients of list ORACLE-L <[EMAIL PROTECTED]> xp.com cc: Sent by: Subject: 24 x 7 x 365 [EMAIL PROTECTED] .com 11/12/200

Re: 24 x 7 x 365

2003-12-13 Thread Murali Vallath
If this is the customer you are talking about, this database supports over 12 million subscribers.. Murali Tim Gorman [EMAIL PROTECTED] wrote: As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs

Re: 24 x 7 x 365

2003-12-13 Thread Ryan
AM Subject: Re: 24 x 7 x 365 If this is the customer you are talking about, this database supports over 12 million subscribers.. Murali Tim Gorman [EMAIL PROTECTED] wrote: As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP

Re: Re: 24 x 7 x 365

2003-12-13 Thread Tanel Poder
Yep, I also think so. I'm currently developing a small prototype for this kind of transparent proxy, which I'll post here when it's stable... Tanel. Tanel,   I think this is a good solution, provided the application can handle two phased commit protocol across both the databases, else there

24 x 7 x 365

2003-12-10 Thread Tracy Rahmlow
Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve

RE: 24 x 7 x 365

2003-12-10 Thread Pete Sharman
Well, first thing that needs to be noted is that 24 x 7 x 365 indicates uptime for 7 years, which always gives me a chuckle when people say it. Mind you, Ive been guilty of saying it too! J And probably the second thing that needs to be said is that no single product addresses true HA

RE: 24 x 7 x 365

2003-12-10 Thread Whittle Jerome Contr NCI
Title: RE: 24 x 7 x 365 As 2004 is a Leap Year, in February you have a one day window of opportunity to do upgrades. ;-) Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED] Sent

Re: 24 x 7 x 365

2003-12-10 Thread Mladen Gogala
-Original Message- From: Tracy Rahmlow [SMTP:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject:24 x 7 x 365 Hello, Our company would like to know whether or not Oracle supports true 24x7x365

Re: 24 x 7 x 365

2003-12-10 Thread ryan_oracle
PROTECTED] Date: 2003/12/10 Wed AM 11:44:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 24 x 7 x 365 Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise

Re: 24 x 7 x 365

2003-12-10 Thread Mladen Gogala
Tracy, both OPS (8i) and RAC (9i)support independent node shutdown. Both support listener based load balancing so that incoming connections will be evenly spread on all nodes. That still doesn't give you the true 24 x 7 x 365 availability. For that, you need two replicated copies of the database

Re: 24 x 7 x 365

2003-12-10 Thread Mark Richard
cc: Sent by: Subject: 24 x 7 x 365 [EMAIL PROTECTED

RE: 24 x 7 x 365

2003-12-10 Thread Goulet, Dick
True 24x365 is just about impossible. No if, ands. or buts about it. Why is because of the number of factors outside your control that affect system availability. Sure your web sever and database are up 24x365, but your ISP has 1 hour down time each month for maintenance. OOPS!! from a

Re: 24 x 7 x 365

2003-12-10 Thread Tanel Poder
recipients of list ORACLE-L [EMAIL PROTECTED] xp.com cc: Sent by: Subject: 24 x 7 x 365 [EMAIL PROTECTED] .com 11/12/2003 03:44

Re: 24 x 7 x 365

2003-12-10 Thread Tim Gorman
Title: Re: 24 x 7 x 365 As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs that has been up and available continuously for the past 11-12 years. on 12/10/03 2:49 PM, Goulet, Dick at [EMAIL