It does reduce your maintenance windows though when you are upgrading. Really nice when you are a 24x7 shop. I do not have to have a database down when upgrading the software. I will actually run catalog and catproc with the database open for business and have not had an issue yet. So I do one side of the node, fail the databases over, run the upgrade script, and do the other side after that has successfully been completed. On my N-classes it really does not take long.
-----Original Message----- Sent: Friday, January 18, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Nah, I make sure all servers have the same uid/gid for oracle but I have naming standards for the lv's and filesystems. This allows me to failover multiple primary servers to a single secondary. I was just curious, b/c I have seen other sites that use your method. I prefer not having to synch multiple OH's. I can just see it happen 6 mos from now, failover occurs, but someone forgot the synch, o o :). Thanks. Gene >>> [EMAIL PROTECTED] 01/18/02 09:50AM >>> I have way to many f'ing Oracle Homes to deal with. When I first got here they were all different versions as well. So it was more of a maintenance thing. To tell you the truth someone else originally set it up that way and I liked it so I kept it. It does mean I have to keep more in sync manually then I normally would have to. If I only had one database on the server (or if they were all developed in-house) I probably would have installed the software on failover disks as well. Do you fail over the Unix account as well? -----Original Message----- Sent: Friday, January 18, 2002 4:50 AM To: Multiple recipients of list ORACLE-L When I failover, I bring the Oracle Home as well. Do you have special reasons for not bringing the Oracle Home over? *just curious* Gene >>> [EMAIL PROTECTED] 01/17/02 08:45PM >>> You will always have the same issues with fail over technology. Your users will get disconnected. My databases take less then 5 minutes to fail over and that is an acceptable time frame to the client. Its great from my standpoint for maintenance cause I can do it on one node, fail the databases over, and bring the other node up to date. I do not have the Oracle software itself in fail over, just the database. We do not find it to hard to work with here. I have no experience with Sun's so I cannot compare them. Whether or not you go with fail over technology all depends on what you are looking for. You will not lose any committed data with HP's (probably not with anyone else's either). Fail over is automatic when configured correctly. I have seen it happen once that I did not even know, it was that quick. Went to go look for my database on the server and it was not there:-) -----Original Message----- McCann Sent: Thursday, January 17, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Thanks for your help everyone. Very useful advice, although your scaring me of Sun Clusters. At the minute, Parallel server looks the best, with a standby database remotely for disaster. Does anyone know what the HP solution is like (MC Service Guard)? I think some one on this list gave it a good review in the past . Thanks, Jim -----Original Message----- Sent: 17 January 2002 17:12 To: Multiple recipients of list ORACLE-L IBM HACMP works well. Ooops. guess that means you'll have to change some things. ;-) Seriously, we *did* get the Sun "clustering" working, but it required some serious feet-to-fire holding and gyrations. -----Original Message----- Sent: Thursday, January 17, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Thanks for the advice everyone. So what do you recommend on a Sun cluster/machines for failover other than OPS? Quest Shareplex? Standby database? Any others? Thanks, Jim -----Original Message----- Sent: 17 January 2002 16:22 To: Multiple recipients of list ORACLE-L I concur with BB.........yea, I ran Sun "cluster" at <deleted> and it broke ALOT. Kept me and two full time Sun Engineers (they got paid ALOT more) in consulting dollars, but i made a mental note not to use it in "my business". Caveat: this was 1.5 years ago. Things change. Mit Gluck, mein freund....... - Ross "mit schuss" Mohan -----Original Message----- Jim: Sorry, you're not gonna like this answer. HA is a Sun product, not an Oracle product. Under Sun's High Availability, you can configure several modules like Sybase and Oracle. (The Oracle product is Sun Cluster HA-DBMS for Oracle.) It does require what I believe Sun calls a cluster but (IMHO) is a bastardization of the term. It truly is failover, not cluster. We've had lots of problems with it. It's caused us lots of grief, and only in a few instances gained us anything. It is NOT OPS, as the database does not run in parallel, but only on 1 box at a time. (Everything is double cabled, and so the drives are re-mounted on the 2nd box if a failover occurs.) Your users still get disconnected. You'd probably lose less data than with a standby (since you pick up with the same drives mounted on the other box), but it depends on how you have the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb > ---------- > From: James McCann[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, January 17, 2002 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Standby Instance questions and HA > > Hi, > I was reading in the book "Oracle 24/7 Tips and Techniques" about > Standby > Instances. > > Note, this is not a standby database. > > From the book it seams to work in the following way... > > There is only one database. > The database files exist on a shared disk pack. One machine is the primary > instance, and if this instance dies, a new instance is started on the > second > machine using the datafiles on the shared disk. > > The problem is that I can't find anything in the Oracle docs about this, > or > on Meta Link. > > I also want to know if this method of HA requires a clustered environment > (I > think it does, but just want to be sure)? > > Also, does it come with an Enterprise Edition license? > Or is it something which each hardware vendor implements in their own way, > at extra cost? > > We have a requirement for a fail over method on Sun Solaris. > We do not want to loose any committed data (i.e. a standby database could > loose some), and want the fail over to be as automatic as possible. > > We don't want the expense of Parallel Server (Anyone know how expensive it > is these days?). > > The disk pack is RAID, and we may also have a standby database off site. > > Has anyone any recommendations? > > > Thanks, > > Jim > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James McCann > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
