Re: Load Balanced Remedy - Load Balanced Oracle environments?
Sean, More cause for concern then we're currently running a hardware load balancer in front of 2 Remedy 7/Solaris boxes each running with (if I remember right) either 8 or 16 processors and 16 gig of RAM. The backend database is running something like 16 processors and 32gig of RAM. And we're currently on something like 70% DB utilisation. I could be slightly out on the specs, but its about right. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Garrison, Sean (Norcross) Sent: 18 November 2008 20:22 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** Word of Caution on an Oracle RAC ... make sure you allocate a lot of memory to the db. Here is what remedy recommends: Small DB: CPU 2 Memory 4 Gig Concurrent Users1-400 sga_target 1-2 gigs pga_aggregate-target1 gig Medium DB: CPU 4 Memory 8 Gig Concurrent Users401-800 sga_target 3-4 gigs pga_aggregate-target2 gig Large DB: CPU 8 Memory 16 Gig Concurrent Users800 or more sga_target 6-8 gigs pga_aggregate-target2-4 gig (page 18 on the Performance Tuning for Business Service Management Document) One problem we ran into with RAC: 4 servers x 1 gig of memory is not equal to 1 server X 4 gigs of memory. The more memory you allocate to the DB the better your performance. So if your remedy db is shared among other databases on the same server you may not be able to allocate a whole lot of memory to the db. Something to keep in mind. Thanks, Sean This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Load Balanced Remedy - Load Balanced Oracle environments?
Word of Caution on an Oracle RAC ... make sure you allocate a lot of memory to the db. Here is what remedy recommends: Small DB: CPU 2 Memory 4 Gig Concurrent Users1-400 sga_target 1-2 gigs pga_aggregate-target1 gig Medium DB: CPU 4 Memory 8 Gig Concurrent Users401-800 sga_target 3-4 gigs pga_aggregate-target2 gig Large DB: CPU 8 Memory 16 Gig Concurrent Users800 or more sga_target 6-8 gigs pga_aggregate-target2-4 gig (page 18 on the Performance Tuning for Business Service Management Document) One problem we ran into with RAC: 4 servers x 1 gig of memory is not equal to 1 server X 4 gigs of memory. The more memory you allocate to the DB the better your performance. So if your remedy db is shared among other databases on the same server you may not be able to allocate a whole lot of memory to the db. Something to keep in mind. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of W Scott Russell Sent: Monday, November 17, 2008 9:16 AM To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** Dave, It will work given the right DBA help and experience. And the right appliction tuning. We are running a 4 node Oracle 10g RAC with 20+ ARS (7.1) processing over 100,000+ tickets a day. Scott On Fri, Nov 14, 2008 at 3:41 AM, Barber, David [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** Shyam, I think the question for us is whether going Oracle RAC will give us scalability. From what Conny said it sounds as if we'd probably have a performance drop, as we are primarily read/write/modify. I've discussed this with our DBA, and he's done some investigation, and it turns out that Remedy is not truly Oracle RAC aware. This could also explain why I've had one of the developers ask if I've seen anything about Remedy 7.5 (hoping that its RAC aware???). Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG]On Behalf Of Shyam Attavar Sent: 14 November 2008 07:05 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** We are also running Oracle 10gR2 (RAC) on a RHEL (Red Hat Enterprise Linux) cluster with three nodes. Not sure if this directly equates as Load Balanced Oracle environment. We have been on this setup for over a year and we have not seen any real issues so far. HTH -- Shyam - Original Message - From: Barber, Davidmailto:[EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 7:59 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com/ ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security
Re: Load Balanced Remedy - Load Balanced Oracle environments?
Dave, It will work given the right DBA help and experience. And the right appliction tuning. We are running a 4 node Oracle 10g RAC with 20+ ARS (7.1) processing over 100,000+ tickets a day. Scott On Fri, Nov 14, 2008 at 3:41 AM, Barber, David [EMAIL PROTECTED] wrote: ** Shyam, I think the question for us is whether going Oracle RAC will give us scalability. From what Conny said it sounds as if we'd probably have a performance drop, as we are primarily read/write/modify. I've discussed this with our DBA, and he's done some investigation, and it turns out that Remedy is not truly Oracle RAC aware. This could also explain why I've had one of the developers ask if I've seen anything about Remedy 7.5 (hoping that its RAC aware???). Ta Dave -Original Message- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of *Shyam Attavar *Sent:* 14 November 2008 07:05 *To:* arslist@ARSLIST.ORG *Subject:* Re: Load Balanced Remedy - Load Balanced Oracle environments? ** We are also running Oracle 10gR2 (RAC) on a RHEL (Red Hat Enterprise Linux) cluster with three nodes. Not sure if this directly equates as Load Balanced Oracle environment. We have been on this setup for over a year and we have not seen any real issues so far. HTH -- Shyam - Original Message - *From:* Barber, David [EMAIL PROTECTED] *Newsgroups:* gmane.comp.crm.arsystem.general *To:* arslist@ARSLIST.ORG *Sent:* Thursday, November 13, 2008 7:59 AM *Subject:* Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards *Dave Barber* This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Load Balanced Remedy - Load Balanced Oracle environments?
Scott, Many thanks - we'll have to do more investigations on this. The BMC support site is lacking on information about running Remedy against an Oracle RAC - barely a few words on one document. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of W Scott Russell Sent: 17 November 2008 14:16 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** Dave, It will work given the right DBA help and experience. And the right appliction tuning. We are running a 4 node Oracle 10g RAC with 20+ ARS (7.1) processing over 100,000+ tickets a day. Scott On Fri, Nov 14, 2008 at 3:41 AM, Barber, David [EMAIL PROTECTED] wrote: ** Shyam, I think the question for us is whether going Oracle RAC will give us scalability. From what Conny said it sounds as if we'd probably have a performance drop, as we are primarily read/write/modify. I've discussed this with our DBA, and he's done some investigation, and it turns out that Remedy is not truly Oracle RAC aware. This could also explain why I've had one of the developers ask if I've seen anything about Remedy 7.5 (hoping that its RAC aware???). Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] Behalf Of Shyam Attavar Sent: 14 November 2008 07:05 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** We are also running Oracle 10gR2 (RAC) on a RHEL (Red Hat Enterprise Linux) cluster with three nodes. Not sure if this directly equates as Load Balanced Oracle environment. We have been on this setup for over a year and we have not seen any real issues so far. HTH -- Shyam - Original Message - From: Barber, David mailto:[EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 7:59 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information
Re: Load Balanced Remedy - Load Balanced Oracle environments?
Conny, Many thanks - I'd say that at least 90% of the worklod is read/write - currently we've got up to 900 people actively updating tickets - this is scheduled to jump by another 400+ next week, with other leaps in the future as new functionality comes into place. More to look at with this Distributed Lock Manager ... interesting days ahead on this! Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Martin, Conny Sent: 14 November 2008 08:21 To: arslist@ARSLIST.ORG Subject: AW: Load Balanced Remedy - Load Balanced Oracle environments? ** Hi Dave, an Oracle RAC is fine, if your workload is mostly read access. But if you do many creates or modifys then you have locks on the database side. A Distributed Lock Manager must tell the other nodes about that lock. This can be a significant overhead compared to a single node database instance. We've experienced this problem and after switching to only one node the system performed better than before. But this was on Oracle 9i. I don't know if it's better in 10g Kind Regards Conny _ Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von Barber, David Gesendet: Freitag, 14. November 2008 08:57 An: arslist@ARSLIST.ORG Betreff: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** The DBA reasoning : that the RAC is normally configured in a failover mode. Haven't spoken to him directly though. It would be a pain if it didn't scale, as we're looking at potentially massive increases in workload - in the next few weeks database utilisation is expected to jump up to around 70%, and we're expecting much bigger leaps in application functionality and users. Many thanks - as a few have said they're running against an Oracle RAC fine, then we'll have to look into configurations. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ramey, Anne Sent: 13 November 2008 20:47 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** We are running with an Oracle RAC configuration and it works fine. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, November 13, 2008 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** Did your DBA give you any reasons why it would not work? Theoretically it should.. All that Remedy requires is a connection string to the database (TWO_TASK if its a remote database - in a cluster this will most definitely be the case). Joe _ From: Barber, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 10:59:56 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more
Re: Load Balanced Remedy - Load Balanced Oracle environments?
Shyam, I think the question for us is whether going Oracle RAC will give us scalability. From what Conny said it sounds as if we'd probably have a performance drop, as we are primarily read/write/modify. I've discussed this with our DBA, and he's done some investigation, and it turns out that Remedy is not truly Oracle RAC aware. This could also explain why I've had one of the developers ask if I've seen anything about Remedy 7.5 (hoping that its RAC aware???). Ta Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Shyam Attavar Sent: 14 November 2008 07:05 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** We are also running Oracle 10gR2 (RAC) on a RHEL (Red Hat Enterprise Linux) cluster with three nodes. Not sure if this directly equates as Load Balanced Oracle environment. We have been on this setup for over a year and we have not seen any real issues so far. HTH -- Shyam - Original Message - From: Barber, mailto:[EMAIL PROTECTED] David Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 7:59 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Load Balanced Remedy - Load Balanced Oracle environments?
Did your DBA give you any reasons why it would not work? Theoretically it should.. All that Remedy requires is a connection string to the database (TWO_TASK if its a remote database - in a cluster this will most definitely be the case). Joe From: Barber, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 10:59:56 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Load Balanced Remedy - Load Balanced Oracle environments? Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Load Balanced Remedy - Load Balanced Oracle environments?
We are running with an Oracle RAC configuration and it works fine. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, November 13, 2008 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** Did your DBA give you any reasons why it would not work? Theoretically it should.. All that Remedy requires is a connection string to the database (TWO_TASK if its a remote database - in a cluster this will most definitely be the case). Joe From: Barber, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 10:59:56 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Load Balanced Remedy - Load Balanced Oracle environments?
The DBA reasoning : that the RAC is normally configured in a failover mode. Haven't spoken to him directly though. It would be a pain if it didn't scale, as we're looking at potentially massive increases in workload - in the next few weeks database utilisation is expected to jump up to around 70%, and we're expecting much bigger leaps in application functionality and users. Many thanks - as a few have said they're running against an Oracle RAC fine, then we'll have to look into configurations. Regards Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ramey, Anne Sent: 13 November 2008 20:47 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** We are running with an Oracle RAC configuration and it works fine. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, November 13, 2008 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy - Load Balanced Oracle environments? ** Did your DBA give you any reasons why it would not work? Theoretically it should.. All that Remedy requires is a connection string to the database (TWO_TASK if its a remote database - in a cluster this will most definitely be the case). Joe _ From: Barber, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 10:59:56 AM Subject: Load Balanced Remedy - Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
