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

From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
To: wjwagman@xxxxxxxxxxx
Date: Mon, 29 Jan 2007 10:04:34 -0800 (PST)

>>This is done using a trigger and a pipe from the accounts database
...
>>I can perform updates to from one node but not the second node.

Bill - is the system using a DBMS_PIPE kind of pipe? That only works within the 
context of a single instance (in 9i, 10g or any other release). If you have 
pipe 'sources' - ie calling send_message() - on an instance, you need 'sinks' - 
calling receive_message() - on the same instance.


http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_pipe.htm#998100
 and 
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_pipe.htm#sthref5327
 both start:

"The DBMS_PIPE package lets two or more sessions in the same instance 
communicate. "

HTH

Regards Nigel

Follow-Ups:

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

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

Other related posts: