Thanks for the suggestion Eli. We are looking at this possibility - we could
have separate Oracle 9.2.x instance to support Business Objects with the
data being refreshed on a regular basis from our production Oracle 10gR2
instance. However, the challenge is there a bunch of custom views (mostly
joins, unions and such) that need to kept in synch between the two systems.
Also the data load has to be done at the DB level to make it efficient and
poses its own set of problems trying to keep the H tables and B tables also
in synch...
I was looking to see if someone had created a DB link from Oracle 9.2.x to
Oracle 10gR2 for the specific set of tables & views, so that the data is not
transferred over, but just the views for reporting purposes to support
Business Objects 6.5.1 are made available on 9.2.x.
I am not even sure if I this is possible at all, but I hope this makes sense
to others that might be proficient in Oracle Databases.
Cheers,
--
Shyam
----- Original Message -----
From: "Eli Schilling" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <[email protected]>
Sent: Thursday, August 23, 2007 9:14 PM
Subject: Re: (possibly) - Remedy AR 7.0.1 on Oracle 10gR2 and Business
Objects 6.5.1
Not sure if its possible on Oracle but could you upgrade your production
Oracle server and maintain a seperate 9.2 server to which BO would continue
to point? Then you could simply replicate/migrate/etc the necessary data on
a recurring basis from the 10gR2 to the 9.2.x server. It wouldn't be pretty
nor would it be real-time but it might get you by until you can upgrade BO.
________________________________
From: Action Request System discussion list(ARSList) on behalf of Shyam
Attavar
Sent: Thu 8/23/2007 8:59 PM
To: [email protected]
Subject: OT: (possibly) - Remedy AR 7.0.1 on Oracle 10gR2 and Business
Objects 6.5.1
**
Dear listers,
I have a very weird situation with Oracle 10gR2 and Business Objects 6.5.1
and I am trying to find my way out of this conundrum.
We are in the process of upgrading our current AR Server 6.3.0 Patch 20 to
AR Server 7.0.1 Patch 3. As part of this upgrade, we are moving our Oracle
DB from 9.2.x to 10gR2. However, as per Business Objects 6.5.1 is not
supported on Oracle 10gR2, but we don't have enough time to upgrade Business
Objects to the next version that supports 10g. Our options are for us to
move back the Oracle to 9.2.x, so that current version of Business Objects
can be supported, since we have a ton of reports that would be impacted.
However, from a performance standpoint, I believe that 10g is much better
for large data throughput, which we will have as part of the CMDB being
populated from various Discovery Sources.
I was wondering if any of you have been in this type of situation and been
able to come up with a solution where you were able to stay with the Oracle
10g but still support Business Objects 6.5.1?
Any help or insight is really appreciated.
Thanks in advance.
Cheers,
--
Shyam
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
