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: Heterogeneous Replication

RE: Heterogeneous Replication

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 29 Jan 2004 12:57:53 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6506D920@25exch1.vicorpower.vicr.com>


Kathy,

        Sure your not using the Sql*Server gateway product? I can't find any = licensing info on Oracle.com about it & our sales rep didn't understand = what we were talking about either (not a first I should also mention). = Also as is noted on Oracle.com these types of products are not sold by = the CPU, but for the computer as a whole.

BTW: That's cheap. Try Partitioning at $10K per cpu or RAC at $20K per.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: Duret, Kathy [mailto:kduret_at_starkinvestments.com] Sent: Thursday, January 29, 2004 11:54 AM To: 'oracle-l_at_freelists.org'
Subject: RE: Heterogeneous Replication

Watch / How you are using it. =20

We are using Heterogeneous services with a driver from data direct to = access
some data in our sql server and oracle in 3 different oracle views. $2,000/cpu so this is not cheap

Personally, I am not happy doing this... I wanted the deveopers to have = the
app open a separate ODBC connection and get the data

So when sql server goes down, we need to restart the app anyway. Once = the
application is up again, if someone accesses the view via an old = connection=20
to the Oracle database, we get ora-28500 errors, some solaris page = swapping
and the database load goes up for a bit.

If Sql Server hangs and someone accesses the Oracle/Sql Server view - = guess
what? Yep=20

Plus as an added bonus we got a new error last week [LEMRIST()+384] [SIGSEGV] [ADDRESS NOT MAPPED TO OBJECT] [12] ORA-07445 not sure what happened with sql server this time (I think it hung), = Oracle
datatbase when to a crawl, the machine was swapping and we pegged memory = for
acouple of minutes. I logged a tar with Oracle and all they could = suggest
was to increase our swap space. This seemed unrealistic since we = already
have
2G of swap space and normally don't even use 1/4 of this space on a very busy day.

Let me know what you find out from Golden Gate and if there connection = works
better.

Good Luck,

Kathy
long time listener, many time caller, first time responder.......

-----Original Message-----

From: Nikhil Khimani [mailto:nkhimani_at_marketaxess.com] Sent: Thursday, January 29, 2004 9:39 AM To: 'oracle-l_at_freelists.org'
Subject: Heterogeneous Replication

L&G,

We are looking at replicating data from Oracle (8.1.7.0 and 9.2.0.4) to MS-SQL (2K). I would like to know if anyone has done this using heterogeneous services and if yes would you please get me started at = least
with the right links to RTFM. Anything additional will be gravy. We are = also
looking at Golden Gate solutions (for Oracle to MS-SQL) and I'd = appreciate a
feed-back, if anyone has had any experience with it.=20

Kind Regards,
=20
Nikhil=20



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

This transmission contains information solely for intended recipient and = may
be privileged, confidential and/or otherwise protect from disclosure. = If
you are not the intended recipient, please contact the sender and delete = all
copies of this transmission. This message and/or the materials = contained
herein are not an offer to sell, or a solicitation of an offer to buy, = any
securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not = represent
that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject = to
change without notice. Any information you share with us will be used = in
the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written = agreement,
we are not agreeing to treat any information confidentially and will use = any
and all information and reserve the right to publish or disclose any information you share with us.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu Jan 29 2004 - 11:57:53 CST

Original text of this message

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