Home
Topics
Oracle database administration
Oracle database availability
Using connection load balancing with Oracle RAC

Ask the Expert

Using connection load balancing with Oracle RAC

When using XA data sources on a RAC database, the Oracle best practice is to set up a singleton service to avoid split branches. This limits the usefulness of RAC because we cannot load balance. Is it still safe to use connection load balancing? The data sources are defined in IBM WebSphere Application Server.

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

As you know, the problem with using load balancing at the Oracle level with WebSphere AS is that when a RAC instance fails, the WebSphere application may attempt to recover a transaction branch from the failing node and leave it hanging.

The setting up of singleton services forces single connections but you still need to point them to individual instances and use DTP to synchronize the transaction IDs.

The only way I know of to continue to use load balancing at the Oracle level is to catch the associated errors (ORA-01591 and/or ORA-24756) and rollback the in-doubt transactions with code.

The dba_2pc_pending view contains the pending transaction IDs.

I know this sounds messy but unless someone knows of a better workaround, this is the best I can come up with.

Good luck.

More News and Tutorials

Articles

This was first published in July 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Management
Business Analytics
SAP
SQL Server
Java
Data Center
Content Management
Financial Applications

Data Management
- Events report: Information Builders Summit 2013, graph databases and more
  
  SearchDataManagement editors discuss the Information Builders user conference and two other events; topics include graph databases and 'data artists.'
- From 4GLs to HTML5 desktop apps: Bringing data to the masses
  
  Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.
- Enterprise data quality efforts in good company with MDM, governance
  
  Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.
Business Analytics
- No more shortcuts: Sound data quality strategy a must for BI success
  
  In the past, companies might have gotten away with not building data quality efforts into business intelligence programs. That's less likely now.
- Member Exclusive Downloads
  
  Member Exclusive Downloads from SearchBusinessAnalytics
- In-memory applications take on big data analytics challenge
  
  In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.
SAP
- Food bank network delivers with SAP mobility
  
  The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.
- SAP adds hybris to its SAP CRM tool set: More choices, or confusion?
  
  One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.
- Limit returns, SAP procurement expenses with a stability study
  
  Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.
SQL Server
- SQL Server 2014 'keeps up with the Joneses,' says analyst
  
  Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- SQL Server high availability: Natural enemy of virtualization?
  
  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
- SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
  
  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.
Java
- Will the Red Hat model work for IaaS cloud computing with OpenStack?
  
  The Red Hat transition is to move their successful model to IaaS through OpenStack and cloud computing. But will this new move from the JBoss company work as well as RHEL did a decade ago?
- How Red Hat's Linux and OpenStack IaaS drives Intel's bottom line
  
  While a major protectorate of intellectual property, Red Hat Linux and OpenStack IaaS offerings provide the bonus of driving innovation, which leads to more chips being purchased, driving revenue at Intel's bottom line.
- Embracing OpenStack: How Red Hat commoditized open source cloud computing
  
  By leveraging OpenStack, Red Hat plans to commoditized cloud computing, just like they commoditized open source Linux ten years ago.
Data Center
- Red Hat Open Hybrid Cloud aids private, public cloud management
  
  Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.
- Mainframe modernization takes on urgency
  
  A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.
- AMD microprocessors regroup to fight another day
  
  Intel may win the server war, but AMD microprocessors could find more acceptance in another niche market.
Content Management
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
- Quiz: Implementing digital asset management systems
  
  Take this quiz to test your knowledge of digital asset management (DAM) technologies and processes.
Financial Applications
- Fight fraud, fog and waste when processing business travel expenses
  
  Problems with business travel expenses have CFOs re-examining their processes for reimbursement, disbursement and audits.
- CFOs reap the benefits of BPM tools in efficiency, compliance
  
  BPM tools can help CFOs reduce errors and enhance the accuracy of reporting and forecasting, experts say.
- CFOs can seize opportunity to lead good governance over IT
  
  Get tips from experts on how to enact good IT governance by getting the right people to do the right processes.

All Rights Reserved,Copyright 2003 - 2013, TechTarget