I have read several posts here and on the Baan support web site. I think I read too much and have confused myself. Is Baan actually certified to run on Oracle 9i? That is the first question my DBA's asked me. Is it also true that Baan still uses the 8i driver for 9i? It seems the tuning and configuring is much more important for 9i for performance reasons. So the last and final question - any thoughts on upgrading? For or against. Any/all responses are welcome.

Thanks

Hi Mark,

Yes - Baan is certified on Oracle 9i (and 10g) [ Sol 163684 ]

Yes there is only 1 driver, it's been modified to work with 8i, 9i and 10g.

I think that tuning is always important, remember the jump between 7 and 8?
Baan's just making the point (and effort) to give some hints in that area this time around.

I think 9i is a great release.. tuned right, and using the right bells and whistles (LMT, UndoTbs, Automatic PGA) it's made my life a whole lot easier.

Of course, given the choice, I still like Oracle 7 =)

Dave

I agree 100% with all points Dave gave.

Additionally you do not really have a choice. Oracle 8i is allready desupported and so you will need to move on anyway. Naturally you can take the stand, that this is not an issue for you, but then I would downgrade to Oracle7 (also like Dave).

Thanks for the input. I think as soon as we can we will try to upgrade. Hopefully by the end of 1st qtr 2006.

I think as soon as we can we will try to upgrade. Hopefully by the end of 1st qtr 2006.
By 2007+, the Oracle-9i will be desupported too, better to plan to migrated to Oracle-10g (as long as you have a porting set which gives you compatibility) and also depends on the size of the database. Oracle-10g needs HP-UX-11i as prerequisite, I am not sure of the Solaris version requirement.