We will be upgrading our Oracle 8.0.5 to 8.0.6 over the next couple of weeks. Can anybody give me some pointers on any possible issues that we may encounter plus any other guidelines.

Our current set-up:

HPUX 11
Oracle 8.0.5.2
Baan IVc4, SP5, porting set 6.1c.05.02

Many Thanks

PJ

Should be no problem. However we got the advise from Baan to go to 8.1 because it solves some problems.

PJ,

I would not expect any problems since this a minor upgrade only. You might want to check with Oracle Support for Oracle specifics. I also agree with Han's remark that you should consider going for Oracle 8i (8.1.7) on a short term basis as the support for releases 8.0.x is limited (no error correction anymore).

Thanks for your replies.

Our DBA does want to go to 8.1 but would rather take the 8.0.6 path first.

Also, we have upgraded our DR site from 805 to 806 but how do you link Baan to the new db environment? We've identfied the ora8_inst6.1 script but this seems a bit long winded for such a simple change.

Cheers

PJ

PJ,

Your link between Baan <-> Oracle is configured trough the sessions 'Maintain Database definitions [ttaad4110m000]' and 'Assign tables to Databases' [ttaad4111m000].

You can either create a new database in ttaad4110m000 with the new ORACLE_HOME setting (if present there) and reassign your tables to this new database
- or -
simply change the current database definition to point to the new ORACLE_HOME.

Do not forget to convert to runtime so that your $BSE/lib/tabledef6.1 is updated. Make sure you check the file as well before starting the upgrade.

Pat,

Thanks for the quick response.

Our problem is that we cannot open Baan.

Should we have done what you've suggested before performing the actual upgrade?

Thanks

PJ

PJ,

Yes, you switch your database definitions before you upgrade your Oracle environment. You would have to hack your tabledef6.1 now to reflect the new ORACLE_HOME. I think that would make Baan accessible again, then you log in again and apply the changes in previous mentioned sessions and do a Convert to Runtime again.

In worst case you have to hack one of the tt tables (can't check which one right now) to update your database definition from SQL*Plus.

Pat,

That's exactly what I did, changed the paths in the tabledef6.1 and everything worked fine.

I'll remember to use the sessions next time!!

Thanks

PJ

In addition to upgrading Oracle I also want to take the opportunity to install the latest Baan service packs and porting set. Does it matter in which order the upgrades (Oracle, SP's, porting set) are performed?

Thanks

PJ

I would say that it depends on what you're installing and even if you shouldn't get problems, by experience I would suggest to install things in some sort of chronological order, eg., install first SP7 and then portingset 6.1c.06.02 (latest), not vice-versa, and so on.

Thanks Victor,

What I intended to do was:

1. Perform Oracle 805 to 806 upgrade and test
2. Install SP 6, 7 & 8 and test
3. Install latest porting set and test

All to be done on a pre-production server.

If you had to complete the same task would you do it in this order?

Thanks for the advice

PJ

Yes, I would do that.
I would sugest however to run creation of RTDD in between each of the SP's and follow any Baan recommendations regarding them (check the latest info about service pack x on the Baan website).

Also, as extra info, if you're comming from a portingset under 6.1c.06, you will have new added functionality related to bdbpre/bdbpost you will need to do some updates regarding to report generation - new functionality added related to html headers and you need to create a few tables (solution 110334).

As general rule, try to check everything before you start the work :-)

I've already come across solution 110334 in conjuction with 110323 with the three new report template tables.

We installed it onto our TEST server an couldn't compile any reports after, due to the age of our current porting set.

Thanks again