We have been using Quest's Shareplex. My database version is Oracle 8i
and we want to move to Oracle9i. My question is will my existing
Shareplex which was installed
in June 2002 (looking at patch.log its version seems to be 3.2.12.x)
also require upgrade, i.e., does SharePlex 3.2.12.x work with
Oracle9i.

Also, is there a way to find the version of Shareplex (because I do
not see
it listed in any of its log files).

Because it is a production database and limited budget, we cannot use
Oracle9i RAC or any other high availability solutions, we are stuck
with SharePlex.

Any information will be appreciated.

Thanks a lot,

Prem

Prem K Mehrotra wrote:

> Because it is a production database and limited budget, we cannot use
> Oracle9i RAC or any other high availability solutions, we are stuck
> with SharePlex.

Don't know enough about your environment, but hope you realize that Oracle
Database 10g STANDARD Edition includes RAC for free.

If you have <= 4 CPU system and don't need Enteprise Edition capabilities,
Standard Edition is just fine. (Standard has roughly the same capability
as SQL Server Enteprise +/- a bit ... during the dot-com bubble, many
organizations did the comparison on name, not capability, and now think
they are stuck.)

/Hans

>
> Because it is a production database and limited budget, we cannot use
> Oracle9i RAC or any other high availability solutions, we are stuck
> with SharePlex.
>

The Oracle 'equivalent' to Shareplex is Data Guard (not RAC), and in
fact a move to Data Guard (assuming you are already using Enterprise
Edition) would help you with your limted budget by saving you the cost
of Shareplex. Your Oracle licence costs would remain the same in both
scenarios.

> The Oracle 'equivalent' to Shareplex is Data Guard (not RAC), and in
> fact a move to Data Guard (assuming you are already using Enterprise
> Edition) would help you with your limted budget by saving you the cost
> of Shareplex. Your Oracle licence costs would remain the same in both
> scenarios.

Would they?

My understanding is that when you use Data Guard - which continuously
receives and applies changes to standby database, requires additional
licenses as with normal database.
But if you use "poor man's standby" by transporting archivelogs manually or
custom script and recovering on standby site, you don't have to by
additional licenses if your standby is open less than 10 days per year?

Tanel.

"Tanel Põder" <change_to_my_first_name@integrid.info> wrote in message news:<411defbd$1_2@news.estpak.ee>...
> > The Oracle 'equivalent' to Shareplex is Data Guard (not RAC), and in
> > fact a move to Data Guard (assuming you are already using Enterprise
> > Edition) would help you with your limted budget by saving you the cost
> > of Shareplex. Your Oracle licence costs would remain the same in both
> > scenarios.
>
> Would they?
>
> My understanding is that when you use Data Guard - which continuously
> receives and applies changes to standby database, requires additional
> licenses as with normal database.
> But if you use "poor man's standby" by transporting archivelogs manually or
> custom script and recovering on standby site, you don't have to by
> additional licenses if your standby is open less than 10 days per year?
>
> Tanel.


I alerday have Oracle Enterprise Edition Licenses for both Primary
and Seconmdray servers, so I will not need any additional license for
Data Gurad. My problem is both of these severes are production servers
and we don't have
any environment to test move from SahrePlex to DataGuard. I know data
gurad is
not hard to setup, but I hav eto convince a team of people who don't
know anything of Oracle.

"Prem K Mehrotra" <premmehrotra@hotmail.com> wrote in message
news:43441e77.0408140543.7ac13019@posting.google.c om...
> "Tanel Põder" <change_to_my_first_name@integrid.info> wrote in message
news:<411defbd$1_2@news.estpak.ee>...
> > > The Oracle 'equivalent' to Shareplex is Data Guard (not RAC), and in
> > > fact a move to Data Guard (assuming you are already using Enterprise
> > > Edition) would help you with your limted budget by saving you the cost
> > > of Shareplex. Your Oracle licence costs would remain the same in both
> > > scenarios.
> >
> > Would they?
> >
> > My understanding is that when you use Data Guard - which continuously
> > receives and applies changes to standby database, requires additional
> > licenses as with normal database.
> > But if you use "poor man's standby" by transporting archivelogs manually
or
> > custom script and recovering on standby site, you don't have to by
> > additional licenses if your standby is open less than 10 days per year?
> >
> > Tanel.
>
>
> I alerday have Oracle Enterprise Edition Licenses for both Primary
> and Seconmdray servers, so I will not need any additional license for
> Data Gurad. My problem is both of these severes are production servers
> and we don't have
> any environment to test move from SahrePlex to DataGuard. I know data
> gurad is
> not hard to setup, but I hav eto convince a team of people who don't
> know anything of Oracle.

If they don't know anything about Oracle maybe it would be a good idea to
learn something new.
Jim

Tanel Põder wrote:
>>The Oracle 'equivalent' to Shareplex is Data Guard (not RAC), and in
>>fact a move to Data Guard (assuming you are already using Enterprise
>>Edition) would help you with your limted budget by saving you the cost
>>of Shareplex. Your Oracle licence costs would remain the same in both
>>scenarios.
>
>
> Would they?
>
> My understanding is that when you use Data Guard - which continuously
> receives and applies changes to standby database, requires additional
> licenses as with normal database.
> But if you use "poor man's standby" by transporting archivelogs manually or
> custom script and recovering on standby site, you don't have to by
> additional licenses if your standby is open less than 10 days per year?
>
> Tanel.
>
>

The 10 day exclusion policy applies to a failover environment, not to a
standby environment. Basically, if you have a copy of the data in a
seperate database, then the other database needs to be licenced as well,
no matter how you keep them in sync. See the SIG for guidance -
http://www.oracle.com/corporate/pric....html?sig.html

Hans Forbrich <forbrich@yahoo.net> wrote in message news:<VZfTc.11033$X12.6016@edtnps84>...
> Prem K Mehrotra wrote:
>
> > Because it is a production database and limited budget, we cannot use
> > Oracle9i RAC or any other high availability solutions, we are stuck
> > with SharePlex.
>
> Don't know enough about your environment, but hope you realize that Oracle
> Database 10g STANDARD Edition includes RAC for free.
>
> If you have <= 4 CPU system and don't need Enteprise Edition capabilities,
> Standard Edition is just fine. (Standard has roughly the same capability
> as SQL Server Enteprise +/- a bit ... during the dot-com bubble, many
> organizations did the comparison on name, not capability, and now think
> they are stuck.)
>
> /Hans

I am suprised why Oracle 10G Standard Edition (SE) includes RAC but not
Oracle10G Enterprise Edition (EE). List price for 10G EE per processor is $40000
but for SE it is only $15000.

Prem

Prem K Mehrotra wrote:

> I am suprised why Oracle 10G Standard Edition (SE) includes RAC but not
> Oracle10G Enterprise Edition (EE). List price for 10G EE per processor is
> $40000 but for SE it is only $15000.

I was as well.

Look at the limits - SE was only available on a frame capable of 1-4 CPU, no
partitioning allowed, etc. The way I read Oracle info they've changed the
rules to state any combination of servers to a maximum [capability] of 4
CPU. (http://www.oracle.com/database/Standard_Edition.html) IMO, that
makes RAC/SE a 1-trick pony - small business/workgroup HA only but right in
the Windows & Linux 'small business cluster' sweet spot. Although that'
pretty powerful in it's own right.


Still, a LOT of organization buy (or at least look at) EE because they think
they have to compare Oracle EE to SQL Server EE. Then they look at the
price difference, without having spent 1 second on the feature difference,
and gag. Whereas a 5 second feature evaluation would come to the
realization that many of the capabilities they want are in Oracle SE -
roughly priced against [it's true competitor] SS-EE.

For your purposes, you might just want to see whether a Linux cluster with
SE could fit your test requirements.

/Hans

Mark Townsend <markbtownsend@comcast.net> wrote in message news:<1iiTc.119900$8_6.44117@attbi_s04>...
> The Oracle 'equivalent' to Shareplex is Data Guard (not RAC), and in
> fact a move to Data Guard (assuming you are already using Enterprise
> Edition) would help you with your limted budget by saving you the cost
> of Shareplex. Your Oracle licence costs would remain the same in both
> scenarios.

He doesn't told us what's the purpose of using Shareplex. It is true
that Shareplex is costly, on the other it is much more powerfull then
Oracle's Data Guard, so maybe using DG is not a viable option for him.

--
Dusan Bolek