Hi,
Our DBAs are on the verge of upgrading all of our Oracle systems from 7.3 to 8 and SQL*NET 7.3 to Net 8 which will impact our Business Objects repository.
Could anyone share their experiences and the necessary changes required besides the connection? Any problems?
Also, the DBAs pointed out that our BO repository was using LONGs and since Oracle changed those to LOBs in version 8 how do we migrate them?
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)
Hello, (Edna)
We are about to upgrade from oracle 7.33 to Oracle 8.16. I need to know what steps to take.I did not see a reply to your posting and have the same concerns you had. Did you get things squared away ?
I tried to do some testing and ran into some some snags. If I install Net8 on a PC that already has BusObj and Net7, I can not make a connection from BusObj to the Oracle 8i. I can see it via SQLPlus.
If I install NET8 and BusObj 5.03 on a freash PC, there is no problems. I tried to uninstall everything on a working PC and reintall the new stuff, but that did not help.
I also need know how to move the repository and what to do with WebIntelligence ! 
Jeremy
Hi,
Our DBAs are on the verge of upgrading all of our Oracle systems from 7.3 to 8 and SQL*NET 7.3 to Net 8 which will impact our Business Objects repository.
Could anyone share their experiences and the necessary changes required besides the connection? Any problems?
Also, the DBAs pointed out that our BO repository was using LONGs and since Oracle changed those to LOBs in version 8 how do we migrate them?
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)
Edna,
The upgrade of the Oracle database holding the BO repository is the DBA’s problem. The Oracle migration utility should do the necessary conversions when the instance is upgraded to Oracle8. If you have a universe built against the Business Objects repository tables, you will probably have to refresh your structure there.
You are not clear as to what version of Oracle 8, e.g. 8.0.5 or 8.0.6 or 8i (8.1.5 or 8.1.6).
For Oracle 8.0.5 or 8.0.6 there we encountered no issues in switching to Net8. Even if the connections were defined as Oracle7, they still worked OK. I cannot answer the question for 8i SQLNet, however. Even though we have upgraded our Oracle databases to 8i, our PC NT clients and BCA server are still running 8.0.5 SQLNet. Our testing with 8i SQL*Net clients has thus far been problematic, so we have not yet switched.
As an additional comment…
As a DBA, I would not undertake an upgrade of the database version and the middleware at the same time. It is too difficult to diagnose problems when several upgrades are going on at the same time. After the database upgrades are applied and tested, then the middleware could be done. SQL*Net 7 runs fine against Oracle8.
Hi,
Our DBAs are on the verge of upgrading all of our Oracle systems from 7.3 to 8 and SQL*NET 7.3 to Net 8 which will impact our Business Objects repository.
Could anyone share their experiences and the necessary changes required besides the connection? Any problems?
Also, the DBAs pointed out that our BO repository was using LONGs and since Oracle changed those to LOBs in version 8 how do we migrate them?
Thanks,
Edna
Listserv Archives (BOB member since 2002-06-25)
First of all: I don’t want to discourage anybody to swith to Oracle 8i. I just want to comment about it:
We encountered some severe problems with Net2.3 against Oracle8i (parallel server) and BusObj V418/V502
BusinessObjects was running stable only if we defined all connections as synchronous, OR set arraysize=1.
In other cases (which we were not always able to reproduce) we sometimes got connection errors, database errors (ORA-01002: fetch out of sequence) and even busobj crashes during data fetch. I have a case open with Business Objects on this issue, but they could not find the reason up to now. The only thing they could tell me was to upgrade to Net8 middleware because there is some bug in certain versions of Net2.x which most probably causes this behaviour. Unfortunately, they could not tell why busobj crashed in theses cases…
Another thing to mention: NEVER EVER allow Oracle8i to use automatic data type conversion, e.g. joining numeric fields to varchar/char fields. Oracle then converts the varchar to numeric and this might fail in certain situations (such as null values or non digits in the varchar field, even if you have restricted the table to only those rows with numeric field content).
Specifically if you use the statistic optimizer: depending of the access path you will encounter ORA-errors… So make sure all your universes have proper object/join/condition definitions in them…
Hope this helps
Walter
“Baker, Cathy” schrieb:
Edna,
…
As an additional comment…
…
are applied and tested, then the middleware could be done. SQL*Net 7 runs fine against Oracle8.
…
–
DI Walter Muellner
Leiter Bereich Consulting
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-450 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)