Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Heterogeneous Replication
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
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org