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

From: Nigel Thomas <nigel_cl_thomas_at_yahoo.com>
Date: Mon, 29 Jan 2007 10:04:34 -0800 (PST)
Message-ID: <585139.80709.qm@web58715.mail.re1.yahoo.com>

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

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

Received on Mon Jan 29 2007 - 12:04:34 CST