Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> URGENT - MULTI MASTER

URGENT - MULTI MASTER

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Wed, 29 Nov 2000 16:49:05 +0530
Message-Id: <10695.123172@fatcity.com>

--------------57122978D8E8D0C8E0E30E17
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

HI ALL FROM ORACLE8.SHAFIKA.VETRI.COM SITE
SELECT GNAME,DBLINK,MASTERDEF,MASTER,PROP_UPDATES,MY_DBLINK FROM DBA_REPSITES;

GNAME             DBLINK                                          M M PROP_UPDATES
M
SCOTT_REP     GXDB.THIRU.VETRI.COM             N Y                             0 N
SCOTT_REP     ORACLE8.SHAFIKA.VETRI.COM  Y Y                             0 Y


FROM GXDB.THIRU.VETRI.COM SITE
SELECT GNAME,DBLINK,MASTERDEF,MASTER,PROP_UPDATES,MY_DBLINK FROM DBA_REPSITES;

GNAME              DBLINK                                           M M
PROP_UPDATES M
SCOTT_REP       GXDB.THIRU.VETRI.COM             N Y                             0
Y
SCOTT_REP        ORACLE8.SHAFIKA.VETRI.COM Y Y                             0 N

ACCORDING TO THE ABOVE O/P ORACLE8.SHAFIKA.VETRI.COM BECOMES A MASTER DEFINITION SITE  BEGIN
 IF DBMS_REPUTIL.REPLICATION_IS_ON THEN
  DBMS_OUTPUT.PUT_LINE('DFDFDF');
  END IF;
 END;
IN BOTH THE SITES IT RETURNED THE OUTPUT "DFDFDF" THAT ENSURES REPLICATION IS ON. PROBLEM : NOT UPDATED IN THE MASTER DESTINATION SITE BUT EVEN AFTER THE SCHEDULED HRS WE DIDN'T GET ANY ERRORS IN THE DEFERROR VIEW AS WELL AS THE TRANSACTION WAS NOT UPDATED IN THE MASTERDESTINATION SITE. PLEASE TELL ME HOW TO TRACE THE PROBLEM . IT IS PRETTY URGENT THANKS IN ADVANCE
REGARDS
SUGANYA dgoulet_at_vicr.com wrote:

> Donna,
>
> I fear you maybe a little hasty in pointing the finger of blame. You might
> look to the Catholic hierarchy as potential culprits too since they've become
> rather intolerant over the past few years. I smell a Cardinal RATzinger in the
> neighborhood.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Maser; Donna (SEA)" <DonnaMaser_at_chiroscience.com>
> Date: 11/27/2000 4:10 PM
>
> It's true, Howard_at_ORCL's Sister of the Immaculate Tongue web site has been
> closed down!
>
> I think Oracle is getting a bit overbearing. I'm an Oracle DBA, and enjoyed
> his website for the content. I sent the link to his homepage to my sister
> who is a Catholic nun, and she thought it was great! What is Oracle's
> problem with this? Can't we have ANY fun?
>
> http://www.geocities.com/howardjr2000/
>
> Donna Maser
> Oracle DBA
>
> The information contained in this email is intended for the
> personal and confidential use of the addressee only. It may
> also be privileged information. If you are not the intended
> recipient then you are hereby notified that you have received
> this document in error and that any review, distribution or
> copying of this document is strictly prohibited. If you have
> received this communication in error, please notify Celltech
> Group immediately on:
>
> +44 (0)1753 534655, or email 'is_at_celltech.co.uk'
>
> Celltech Group plc
> 216 Bath Road, Slough, SL1 4EN, Berkshire, UK
>
> Registered Office as above. Registered in England No. 2159282
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Maser, Donna (SEA)
> INET: DonnaMaser_at_chiroscience.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--------------57122978D8E8D0C8E0E30E17
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
HI ALL
<p><font color="#006600">FROM ORACLE8.SHAFIKA.VETRI.COM SITE</font> <br><font color="#FF0000">SELECT GNAME,DBLINK,MASTERDEF,MASTER,PROP_UPDATES,MY_DBLINK FROM DBA_REPSITES;</font>
<br><font color="#3333FF">GNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBLINK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M M PROP_UPDATES M</font>
<br><font color="#3333FF">SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp; GXDB.THIRU.VETRI.COM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 N</font>
<br><font color="#3333FF">SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp; ORACLE8.SHAFIKA.VETRI.COM&nbsp; Y Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 Y</font>

<br><font color="#3333FF"></font>&nbsp;
<p><font color="#006600">FROM GXDB.THIRU.VETRI.COM SITE</font>
<br><font color="#FF0000">SELECT GNAME,DBLINK,MASTERDEF,MASTER,PROP_UPDATES,MY_DBLINK
FROM DBA_REPSITES;</font>
<br>GNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBLINK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; M M PROP_UPDATES M
<br>SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GXDB.THIRU.VETRI.COM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 Y
<br>SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ORACLE8.SHAFIKA.VETRI.COM Y Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 N
<p>ACCORDING TO THE ABOVE O/P ORACLE8.SHAFIKA.VETRI.COM BECOMES A
<br>MASTER DEFINITION SITE
<p>&nbsp;BEGIN
<br>&nbsp;IF DBMS_REPUTIL.REPLICATION_IS_ON THEN
<br>&nbsp; DBMS_OUTPUT.PUT_LINE('DFDFDF');
<br>&nbsp; END IF;
<br>&nbsp;END;
<br>IN BOTH THE SITES IT RETURNED THE OUTPUT "DFDFDF" THAT ENSURES REPLICATION
IS ON.
<p>PROBLEM&nbsp;&nbsp; : <font color="#CC33CC">NOT UPDATED IN THE MASTER DESTINATION SITE</font><font color="#CC33CC"></font> <p>BUT EVEN AFTER THE SCHEDULED HRS WE DIDN'T GET ANY ERRORS IN THE DEFERROR VIEW
<p>AS WELL AS THE TRANSACTION WAS NOT UPDATED IN THE MASTERDESTINATION SITE.
<br>PLEASE TELL ME HOW TO TRACE THE PROBLEM .
<br>IT IS PRETTY URGENT
<p>THANKS IN ADVANCE
<br>REGARDS
<br>SUGANYA
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<p>dgoulet_at_vicr.com wrote:
<blockquote TYPE=CITE>Donna,
<p>&nbsp;&nbsp;&nbsp; I fear you maybe a little hasty in pointing the finger
of blame.&nbsp; You might
<br>look to the Catholic hierarchy as potential culprits too since&nbsp; they've become
<br>rather intolerant over the past few years.&nbsp; I smell a Cardinal RATzinger in the
<br>neighborhood.
<p>Dick Goulet
<p>____________________Reply Separator____________________
<br>Author: "Maser; Donna&nbsp; (SEA)" &lt;DonnaMaser_at_chiroscience.com>
<br>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/27/2000 4:10 PM
<p>It's true, Howard_at_ORCL's Sister of the Immaculate Tongue web site has
been
<br>closed down!
<p>I think Oracle is getting a bit overbearing.&nbsp; I'm an Oracle DBA, and enjoyed
<br>his website for the content.&nbsp; I sent the link to his homepage to my sister
<br>who is a Catholic nun, and she thought it was great!&nbsp; What is Oracle's
<br>problem with this?&nbsp; Can't we have ANY fun?
<p><a href="http://www.geocities.com/howardjr2000/">http://www.geocities.com/howardjr2000/</a>
<p>Donna Maser
<br>Oracle DBA
<p>The information contained in this email is intended for the
<br>personal and confidential use of the addressee only. It may
<br>also be privileged information. If you are not the intended
<br>recipient then you are hereby notified that you have received
<br>this document in error and that any review, distribution or
<br>copying of this document is strictly prohibited. If you have
<br>received&nbsp; this communication in error, please notify Celltech
<br>Group immediately on:
<p>+44 (0)1753 534655, or email 'is_at_celltech.co.uk'
<p>Celltech Group plc
<br>216 Bath Road, Slough, SL1 4EN, Berkshire, UK
<p>Registered Office as above. Registered in England No. 2159282
<br>--
<br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a>
<br>--
<br>Author: Maser, Donna&nbsp; (SEA)
<br>&nbsp; INET: DonnaMaser_at_chiroscience.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;
FAX: (858) 538-5051
<br>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists
<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
<br>the message BODY, include a line containing: UNSUB ORACLE-L <br>(or the name of mailing list you want to be removed from).&nbsp; You may
<br>also send the HELP command for other information (like subscribing).
<br>--
<br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a>
<br>--
<br>Author:
<br>&nbsp; INET: dgoulet_at_vicr.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;
FAX: (858) 538-5051
<br>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists
<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in <br>the message BODY, include a line containing: UNSUB ORACLE-L Received on Wed Nov 29 2000 - 05:19:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US