Anyone running BAAN on an Oracle 9i RAC or Oracle 10g RAC? It is time to refresh our hardware and we are considering Oracle RAC as a possible solution this time. Our peak BAAN session count is 4000 - 5000. The database size is 500 Gbyte and growing fast. Any experiences others can share relating to Oracle RAC and BAAN would be appreciated.

Thanks,

Robert

Are you talking about 4000-5000 concurrent Baan users or 4000-5000 Oracle session caused by Baan?

SQL> select count(*) from v$session;

COUNT(*)
----------
3420

If I would go for RAC I will never choose the 9i version since I know customers who implemented RAC with 9i had many problems, RAC is mature/reliable product with 10g version.

- ranias

Which were the problems in Oracle9i/RAC/BAAN ?
Why 10g is better (for BAAN ERP) ?

If I would go for RAC I will never choose the 9i version since I know customers who implemented RAC with 9i had many problems, RAC is mature/reliable product with 10g version.
That is what I hear with every latest version of Oracle RAC. There evangelists seem to do good work while for 90+% of the customers who believe they can breath without RAC can live with a much cheaper solution like a standby database.

Kind regards,
Dick

When the number of users is (fast) growing and ressources of the database server run low after extension to maximum cpu/memory utilization, you may need to "scale out" (using another database server). Here RAC comes in sight.
Regards,
bherkend

When the number of users is (fast) growing and ressources of the database server run low after extension to maximum cpu/memory utilization, you may need to "scale out" (using another database server). Here RAC comes in sight.
This might be true if the performance of RAC scales better than without. But if users run on the same company this will become a real pain in the back with RAC. If they run on different companies I think that you most of the time can run on multiple systems with different databases as well. I know a customer that used it in the past: from 1 application server they connected to company 100-199 on database server A and company 200-299 connected to database on system B. This of course had some other consequences like multiple drivers and no 2 phase commit between company 100 and 200 but I think that is no problem for 99% of the Baan customers if you can split on functional level.

Kind regards,
Dick