"The Oracle Store is
temporarily unavailable due to required maintenance. We apologize for the
inconvenience. For
further assistance, please contact an Oracle Sales Representative."
They must be upgrading :)
But for shareplex & Financials issues, I think
that Financials isn't probably supported running on "shareplexed" database. You
ought to go with an Oracle solution, but I think logical standby mechanism is
currently too buggy for a complex app (in sense of db feature usage) as
Financials 11i (for example, materialized view refreshing has do be done
manually IIRC, nested tables don't work, CTAS over dblink may
fail etc..).
Your next option would be going with physical standby
(opened as read only & , but that depends on your MTTR constraint and how
real-time your reporting environment has to be. Physical standby will be much
more safe in sense of replicating data to stdby, but even with physical standby
you have to worry about some logging issues, as some concurrent manager jobs do
nologging operations etc. Luckily in 9i you can use alter database/tablespace
force logging command to force logging on any nologging commands. OTOH, this
might mean a performance hit.
Note that when talking about Financials HA, you might
also want to replicate/mirror concurrent manager output and log files in
addition to database.
You should really check metalink notes 216212.1 and
216211.1 when thinking Apps and standby.
Tanel.
----- Original Message -----
Sent: Saturday, August 09, 2003 2:04
AM
Subject: RE: SharePlex
Actually, logical standby database does have a hidden cost because you
need Data Guard which is licensed
separately. The product that mimics SharePlex is called Oracle Streams
and it is a redo log based replication
tool, sort of Logminer on steroids. By the way, logminer was
published because of the Quest who reengineered
the
format of redo logs and based recovery mechanism on reading the changes
from the logs and applying
them
to "replicated" database. Neither logminer, SharePlex nor Streams can handle
DDL. One has to propagate
schema changes using Quest Schema Manager or the same thing from
Embarcadero or, for masochists, OEM Change
Management Pack. I used every expletive in the
book while I was testing OEM and I even invented a few of my
own.
If
you opt for any of those tools (and Data Streams is a pretty cool stuff, based
on the demos, white papers from OTN,
marketing brochures and spam about the database enlargement), you will
also need a schema manager tool.
Quest Schema Manager is a very good tool which I tested
extensively.
I'f
you decide to go cheap and use trigger/stored procedures based
replication ("advanced replication"), you'll
need
a gun, preferrably 44-magnum. That is known as "go ahead, make my data"
option. Do you feel lucky?
--
Mladen Gogala
Oracle DBA
Nelson,
SharePlex does the same basic thing that Oracle does
for the logical standby, as a matter of fact if your running 9i why not use
that instead of Quests's pricey tool? I don't believe there is any
additional cost to using logical standby over the second server license that
your going to have to pay anyway.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i
DBA
Hello,
Quest is trying to sell us a product named
SharePlex. It sounds very attractive, but then sales people are
supposed to be good at that. We are a mid sized company, about 2.2
billion per year, running Financials 11.5.7. We are interested in
this for HA and for reporting instance use.
<rant>
We use Cognos as our query tool and the owners of this product
tells me that we can't tune the SQL it emits. It makes pretty poor
choices, which is not surprising for a gooey, sticky tool designed for end
users. It is sort of pretty and if you can drool you too can
generate cross products. Anyway , I'd like to get them off the
production box.
<rant/>
Does SharePlex allow you to stay close to the
production instance in time? Does the store and forward work
well? Do you love it? Hate it? Anything you'd like to
say about this product I'd like to hear
Thanks in advance
______________________________________________________________________________
This
email is intended solely for the person or entity to which it is addressed
and may contain confidential and/or privileged information. Copying,
forwarding or distributing this message by persons or entities other than
the addressee is prohibited. If you have received this email in error,
please contact the sender immediately and delete the material from any
computer. This email may have been monitored for policy compliance.
[021216]
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and notify
the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Wang Trading
LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
