Hi

I plan to create a Oracle 9.2.0.4 database for Baan IVc4
to run on. When running Database configuration assistant:
If on the database features you select the standard database features tab:
A window comes up with the following Quote:
"Select the standard database features you want to configure for use in your database. Oracle Corporation recommends that you install these features in your database."
Oracle JVM
Oracle Intermedia
Oracle Text
Oracle XML DB
My question:
1) Do I need to install any/all these features for BaanIVc4?

Thanx Patrick

No. None of these are needed for Baan. Baan uses the lean and clean database.

Kind regards,
Dick

Hi Patrick,

some people say, Baan is using oracle as a "data graveyard", meaning, Baan will store the data in oralce, but is using none of it's advanced features.

So the simple answer is: None of the features you listed, will be needed.

If you plan to access the Baan data at a later stage from inside oracle (ie. stored procedures written in java), then I would be tempted to install the JVM. On the other hand, installing an oracle patchset was complicated, when you had the JVM installed.

Hope, it helped,

enjoy

markus

Thank you for the feedback.

This will make upgrades more simple and
use less memory (No java pools etc).

You will keep a java_pool_size as the default is 20000. And the minimum value to set is 1.000.000... This sounds weird, but that is what Oracle Metalink says about it. To find out the actually used number of bytes use:

SELECT pool, name, bytes
FROM v$sgastat
WHERE pool = 'java pool';

Hope this helps,
Dick

One more question.
Why would one purchase Oracle Enterprise edition
when Baan does not use any of the Enterprise edition
features?

The only reason I can find, is if you have more than 4 CPU's.

One thing is clear, baan runs perfectly fine (meaning without errors) on a personal edition. I tried that in test environments.

I think at least a long time ago, Baan would only support the product on oralce, if oracle was enterprise edition. That might not be the case anymore.

I think it is more a licensing and support issue, then anything else.

I am even sceptical about the 4 CPU limit. This again sounds like a licencing issue. Oracle can not prevent it's user processes from using all X CPU (with X>4) anyway. The same goes for the bshell and oralce driver processes, which take a lot of load.

has anybody any experience here?

Regards

Indeed it is all about money. Oracle EE are much more expensive, but you have to buy them at the moment you buy a box with more than 1 or 2 CPU's. Baan connects the same, so from Baan point it doesn't matter. Ok, some issues are not supported for versions less than EE. But for test enviornments this doesn't differ always.

Kind regards,
Dick

Originally posted by patrickmonks
One more question.
Why would one purchase Oracle Enterprise edition
when Baan does not use any of the Enterprise edition
features?

The only reason I can find, is if you have more than 4 CPU's.

One reason could be the need to use RMAN and its 3rd party interface modules for backing up and restoring your databases.

Pat mentioned:

One reason could be the need to use RMAN and its 3rd party interface modules for backing up and restoring your databases.

And that is a very good reason but not needed for running Baan. So, my answer was purely related if running on a simple Oracle environment was possible. But for backup and (many) other good reasons EE is the only solution.

Kind regards,
Dick