Hello,

Does anyone have experience in migration from Informix 9.40 fc3 to Oracle?

At the moment we are going to switching to Oracle from Informix.
If there is in detail document with all steps to migrate from Informix to Oracle.

Are there any known problems regarding Baan IVc4 and Oracle?

Any problems with the migration? We are planning to move on a new server
with the new database.

We are grateful for every small reference.

Thank in advance,

I made one such migration. Major steps are as follows:
- validate Oracle database
- export all companies data into ASCII files
- install Oracle SW and create instance on a new server
- copy baan directory from old to a new server
- manually change $BSE/lib/tabledef6.1 on a new server
- run ora8_install6.1
- import company 000 data using bdbpost command
- import all others companies data from Baan session
- change database definition in Baan table, create all needed users in oracle, ...

I thnik there exists one old document for migration from bisam to Orace database. It will help you.

We did this last year, using bdbpre and bdbpost for all the import and export, company 000 and all the other companies.

We had better success with the ASCII export and import than we did with the binary. So use bdbpre with the -t'|' option. We found that over the years, the old database had gained some data that violated the table definitions (fields that were too long, etc). Oracle is less forgiving. Using the ASCII export allowed us to clean up the data. bdbpost was usually pretty good about telling us where to look for the corrupt data.

Be sure to follow the Oracle install guide in Infor Document number U70281US.

Leave yourself lots of time for tests. You may want to load the data a few times and run various tests to make sure Oracle is configured properly. Once you have done a load, make sure you have lots of disk space for the data, the backup recovery area, the Oracle temp files (I've seen our Oracle temp files grow 15G overnight for no good reason I could find). Since Baan is database-independant, some of its queries and some of your custom queries and table defs could create a lot of temp activity in Oracle.

Develop and test your backup system. If you are going to use archive-logging, make sure you have a way to clean out the old logs so your recovery area does not run out of space.

Its harder to configure Oracle once you've gone into production, so try to sort all this out before hand.

Rob

Hi,

Thanks to you all for quick reply which was needed.

Thanks again.

Regards,
Nilesh

So use bdbpre with the -t'|' option
I exported data with this option as well for all companies except company 000. Maybe I was not clear enough, with "ASCII files" I tought files ttable_name.S

I was more commenting on the fact that you used bdbpost for company 000 and the sessions for everything else. This is probably just a matter of taste: I don't know much about those sessions. I liked using bdbpost because I could pipe its output to a file to review later.

Rob