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

  • To: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>, <boris_dali@xxxxxxxx>, <john.hallas@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 29 Jan 2007 09:36:25 -0800

Andrew,

I have done that on 2 or 3 occasions. Unfortunately my experience has
been that it is very difficult to get RAC support from Oracle. The front
line support people seem to know very little about it. I have spent
quite a bit of time on the phone with them, often to no avail. I keep
trying though.

Thanks. 


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: Kerber, Andrew [mailto:Andrew.Kerber@xxxxxxx] 
Sent: Monday, January 29, 2007 9:26 AM
To: William Wagman; boris_dali@xxxxxxxx; john.hallas@xxxxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: What does an app need to do to work with RAC

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
UMB
816-860-3921
andrew.kerber@xxxxxxx


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

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of William Wagman
Sent: Monday, January 29, 2007 11:14 AM
To: boris_dali@xxxxxxxx; john.hallas@xxxxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: What does an app need to do to work with RAC

Greetings,

This discussion has cropped up at an interesting time as I am
experiencing interesting problems in a RAC setup. Our 10.1.0.4.0 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. 

Thanks. 


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

John,

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:

http://www.orafaq.com/maillist/oracle-l/2002/11/29/2163.htm

Thanks,
Boris Dali.

--- John Hallas <john.hallas@xxxxxxxxxxxxxxxxx> wrote:

> 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 
http://mail.yahoo.com 
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l



------------------------------------------------------------------------
------
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.

========================================================================
======

--
//www.freelists.org/webpage/oracle-l


Other related posts: