Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: What does an app need to do to work with RAC

RE: What does an app need to do to work with RAC

From: Kerber, Andrew <>
Date: Mon, 29 Jan 2007 11:25:34 -0600
Message-ID: <>

Just one point, that should be a severity 1 issue with Oracle, severe loss of service. Make them get back to you quickly. You pay for support, make them do their job.

Andrew W. Kerber
Oracle DBA

"If at first you dont succeed, dont take up skydiving"

-----Original Message-----
[] On Behalf Of William Wagman Sent: Monday, January 29, 2007 11:14 AM
Subject: RE: What does an app need to do to work with RAC


This discussion has cropped up at an interesting time as I am experiencing interesting problems in a RAC setup. Our RAC database maintains user accounts and users are able to create and update account information via a web page. One task which is completed upon new account creation is to then update our student information system and add the new account information there. This is done using a trigger and a pipe from the accounts database. All was working smoothly for the first few months of implementation of the accounts setup in the RAC environment and for the last couple of months has been failing intermittently but with the failure apparently upon execution of the trigger. I believe the failure started occurring when the student information database was upgraded from 9i to 10gR2 but am not certain. When the failure occurs there is one table in the accounts database which I can perform updates to from one node but not the second node. Restarting the instance on the failed node solves the problem. The last time this happens I ran the RACDIAG.SQL script and uploaded the results to Oracle and am waiting for an answer. My question/problem is that I am beginning to suspect this is due to contention for resources in the code but I don't know what to look for to prove that. As Anjo suggested I will look at v$latch, v$sysstat, x$kcbsw, etc but I'm not dure I know how to interpret the results. If anyone can offer suggestions I would greatly appreciate it.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208
-----Original Message-----
[] On Behalf Of Boris Dali Sent: Monday, January 29, 2007 6:11 AM
To:; Subject: Re: What does an app need to do to work with RAC


For what it's worth I asked a somewhat related question back in 2002 and found Tim and Cary's replies very informative. I think they are still relevant. Here's the link:

Boris Dali.

> I will show my ignorance here and ask for what
> reasons an application
> might not work with RAC when more than one instance
> is added.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around


NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.


Received on Mon Jan 29 2007 - 11:25:34 CST

Original text of this message