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

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

Re: URGENT - MULTI MASTER

From: Rahul Dandekar <orcldba_at_hotmail.com>
Date: Wed, 29 Nov 2000 07:59:11 -0500
Message-Id: <10695.123177@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0077_01C059DA.427FD3B0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What would you take to write in lowercase? Why are you shouting?

-Rahul

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

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

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

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

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

  dgoulet_at_vicr.com wrote:=20

    Donna,=20

        I fear you maybe a little hasty in pointing the finger of blame. =  You might=20

    look to the Catholic hierarchy as potential culprits too since = they've become=20

    rather intolerant over the past few years. I smell a Cardinal = RATzinger in the=20

    neighborhood.=20

    Dick Goulet=20

    ____________________Reply Separator____________________=20
    Author: "Maser; Donna  (SEA)" <DonnaMaser_at_chiroscience.com>=20
    Date:       11/27/2000 4:10 PM=20

    It's true, Howard_at_ORCL's Sister of the Immaculate Tongue web site = has been=20

    closed down!=20

    I think Oracle is getting a bit overbearing. I'm an Oracle DBA, and = enjoyed=20

    his website for the content. I sent the link to his homepage to my = sister=20

    who is a Catholic nun, and she thought it was great! What is = Oracle's=20

    problem with this? Can't we have ANY fun?=20

    http://www.geocities.com/howardjr2000/=20

    Donna Maser=20
    Oracle DBA=20

    The information contained in this email is intended for the=20
    personal and confidential use of the addressee only. It may=20
    also be privileged information. If you are not the intended=20
    recipient then you are hereby notified that you have received=20     this document in error and that any review, distribution or=20     copying of this document is strictly prohibited. If you have=20     received this communication in error, please notify Celltech=20     Group immediately on:=20

    +44 (0)1753 534655, or email 'is_at_celltech.co.uk'=20

    Celltech Group plc=20
    216 Bath Road, Slough, SL1 4EN, Berkshire, UK=20

    Registered Office as above. Registered in England No. 2159282=20     --=20
    Please see the official ORACLE-L FAQ: http://www.orafaq.com=20     --=20
    Author: Maser, Donna (SEA)=20
      INET: DonnaMaser_at_chiroscience.com=20

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20     San Diego, California -- Public Internet access / Mailing = Lists=20

    To REMOVE yourself from this mailing list, send an E-Mail message=20     to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20     the message BODY, include a line containing: UNSUB ORACLE-L=20     (or the name of mailing list you want to be removed from). You may=20     also send the HELP command for other information (like subscribing). =

    --=20
    Please see the official ORACLE-L FAQ: http://www.orafaq.com=20     --=20
    Author:=20
      INET: dgoulet_at_vicr.com=20

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20     San Diego, California -- Public Internet access / Mailing = Lists=20

    To REMOVE yourself from this mailing list, send an E-Mail message=20     to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20     the message BODY, include a line containing: UNSUB ORACLE-L=20     (or the name of mailing list you want to be removed from). You may=20     also send the HELP command for other information (like subscribing).

------=_NextPart_000_0077_01C059DA.427FD3B0 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>What would you take to write in lowercase? Why are =
you=20
shouting?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>-Rahul</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:ukumsu02_at_shafika.vetri.com"=20   title=3Dukumsu02_at_shafika.vetri.com>Suganya</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, November 29, = 2000 6:25=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> URGENT - MULTI = MASTER</DIV>
  <DIV><BR></DIV>HI ALL=20
  <P><FONT color=3D#006600>FROM ORACLE8.SHAFIKA.VETRI.COM SITE</FONT> = <BR><FONT=20
  color=3D#ff0000>SELECT =
GNAME,DBLINK,MASTERDEF,MASTER,PROP_UPDATES,MY_DBLINK FROM=20   DBA_REPSITES;</FONT> <BR><FONT=20
  =
color=3D#3333ff>GNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;=20
  =
DBLINK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  M M PROP_UPDATES M</FONT> <BR><FONT=20   color=3D#3333ff>SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp;=20   =
GXDB.THIRU.VETRI.COM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;=20
  N=20
  =
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;=20
  0 N</FONT> <BR><FONT color=3D#3333ff>SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp; =

  ORACLE8.SHAFIKA.VETRI.COM&nbsp; Y=20
  =
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;=20
  0 Y</FONT> <BR><FONT color=3D#3333ff></FONT>&nbsp;=20   <P><FONT color=3D#006600>FROM GXDB.THIRU.VETRI.COM SITE</FONT> = <BR><FONT=20
  color=3D#ff0000>SELECT =
GNAME,DBLINK,MASTERDEF,MASTER,PROP_UPDATES,MY_DBLINK FROM=20   DBA_REPSITES;</FONT>=20
  =
<BR>GNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;=20
  =

DBLINK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20   M M PROP_UPDATES M <BR>SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20   =
GXDB.THIRU.VETRI.COM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;=20
  N=20
  =
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;=20
  0 Y <BR>SCOTT_REP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20   ORACLE8.SHAFIKA.VETRI.COM Y=20
  =
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;=20
  0 N=20
  <P>ACCORDING TO THE ABOVE O/P ORACLE8.SHAFIKA.VETRI.COM BECOMES A = <BR>MASTER=20
  DEFINITION SITE=20
  <P>&nbsp;BEGIN <BR>&nbsp;IF DBMS_REPUTIL.REPLICATION_IS_ON THEN = <BR>&nbsp;=20
  DBMS_OUTPUT.PUT_LINE('DFDFDF'); <BR>&nbsp; END IF; <BR>&nbsp;END; = <BR>IN BOTH=20
  THE SITES IT RETURNED THE OUTPUT "DFDFDF" THAT ENSURES REPLICATION IS = ON.=20
  <P>PROBLEM&nbsp;&nbsp; : <FONT color=3D#cc33cc>NOT UPDATED IN THE = MASTER=20
  DESTINATION SITE</FONT><FONT color=3D#cc33cc></FONT>=20   <P>BUT EVEN AFTER THE SCHEDULED HRS WE DIDN'T GET ANY ERRORS IN THE = DEFERROR=20
  VIEW=20
  <P>AS WELL AS THE TRANSACTION WAS NOT UPDATED IN THE MASTERDESTINATION = SITE.=20
  <BR>PLEASE TELL ME HOW TO TRACE THE PROBLEM . <BR>IT IS PRETTY URGENT=20   <P>THANKS IN ADVANCE <BR>REGARDS <BR>SUGANYA <BR>&nbsp; <BR>&nbsp; = <BR>&nbsp;=20
  <BR>&nbsp; <BR>&nbsp; <BR>&nbsp;=20
  <P>dgoulet_at_vicr.com wrote:=20
  <BLOCKQUOTE TYPE=3D"CITE">Donna,=20

    <P>&nbsp;&nbsp;&nbsp; I fear you maybe a little hasty in pointing = the finger=20

    of blame.&nbsp; You might <BR>look to the Catholic hierarchy as = potential=20

    culprits too since&nbsp; they've become <BR>rather intolerant over = the past=20

    few years.&nbsp; I smell a Cardinal RATzinger in the = <BR>neighborhood.=20

    <P>Dick Goulet=20

    <P>____________________Reply Separator____________________ =
<BR>Author:=20

    "Maser; Donna&nbsp; (SEA)" &lt;DonnaMaser_at_chiroscience.com&gt;=20     <BR>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/27/2000 4:10 PM=20     <P>It's true, Howard_at_ORCL's Sister of the Immaculate Tongue web site = has=20

    been <BR>closed down!=20
    <P>I think Oracle is getting a bit overbearing.&nbsp; I'm an Oracle = DBA, and=20

    enjoyed <BR>his website for the content.&nbsp; I sent the link to = his=20

    homepage to my sister <BR>who is a Catholic nun, and she thought it = was=20

    great!&nbsp; What is Oracle's <BR>problem with this?&nbsp; Can't we = have ANY=20

    fun?=20
    <P><A=20
    =
href=3D"http://www.geocities.com/howardjr2000/">http://www.geocities.com/= howardjr2000/</A>=20

    <P>Donna Maser <BR>Oracle DBA=20
    <P>The information contained in this email is intended for the = <BR>personal=20

    and confidential use of the addressee only. It may <BR>also be = privileged=20

    information. If you are not the intended <BR>recipient then you are = hereby=20

    notified that you have received <BR>this document in error and that = any=20

    review, distribution or <BR>copying of this document is strictly = prohibited.=20

    If you have <BR>received&nbsp; this communication in error, please = notify=20

    Celltech <BR>Group immediately on:=20     <P>+44 (0)1753 534655, or email 'is_at_celltech.co.uk'=20     <P>Celltech Group plc <BR>216 Bath Road, Slough, SL1 4EN, Berkshire, = UK=20

    <P>Registered Office as above. Registered in England No. 2159282 = <BR>--=20

    <BR>Please see the official ORACLE-L FAQ: <A=20     href=3D"http://www.orafaq.com">http://www.orafaq.com</A> <BR>-- = <BR>Author:=20

    Maser, Donna&nbsp; (SEA) <BR>&nbsp; INET: = DonnaMaser_at_chiroscience.com=20

    <P>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX:=20

    (858) 538-5051 <BR>San Diego,=20
    California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet=20

    access / Mailing Lists=20
    =

<BR>-------------------------------------------------------------------- =

    <BR>To REMOVE yourself from this mailing list, send an E-Mail = message=20

    <BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in=20

    <BR>the message BODY, include a line containing: UNSUB ORACLE-L = <BR>(or the=20

    name of mailing list you want to be removed from).&nbsp; You may = <BR>also=20

    send the HELP command for other information (like subscribing). = <BR>--=20

    <BR>Please see the official ORACLE-L FAQ: <A=20     href=3D"http://www.orafaq.com">http://www.orafaq.com</A> <BR>-- = <BR>Author:=20

    <BR>&nbsp; INET: dgoulet_at_vicr.com=20     <P>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX:=20

    (858) 538-5051 <BR>San Diego,=20
    California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet=20

    access / Mailing Lists=20
    =

<BR>-------------------------------------------------------------------- =

    <BR>To REMOVE yourself from this mailing list, send an E-Mail = message=20

    <BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = Received on Wed Nov 29 2000 - 06:59:11 CST

Original text of this message

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