Migration from Informix to Oracle 7.3.3

We are currently running Informix-5, with a setup as follows:

	Single DB server running version 5 of informix.
	Multiple (60+) databases served
	Lots of Infomaker clients using password authentication
	Several unix client workstations using .rhosts/hosts.equiv
		authentication.

From the looks of things after installing 7.3.3, (well, starting to install it anyway.) It seems that oracle can only serve a single database per instance. This means we would have to run 60+ instances of oracle on the DB server, does it not? Many of the databases have identical tables and are archive versions of the main database. I.e. the Fall Semester 1996 student database.

Oracle does not seem to support .rhosts/hosts.equiv authentication, so it looks like we'll have to move to embedding the passwords in the perl scripts that connect to the database server (or in a local file or similar).

Does anyone have any pointers or tips for going about this migration process. At the moment, I am still struggling with just getting Oracle up and running to where I can connect to it remotely.

• Nathan

  ---

Nathan Neulinger                       EMail:  nneul_at_umr.edu
University of Missouri - Rolla         Phone: (573) 341-4841
Computing Services                       Fax: (573) 341-4216