Re: Migration from Informix to Oracle 7.3.3

On 7 Jan 1998, Nigel Gall wrote: Here is my experience with Oracle/Informix: we are running 4gl parsed to odbc/C to access Oracle, "straight" 4gl to go after Informix. Time to setup database (after you have configuration defined): Informix -- 10 minutes Oracle -- 2 hours Triple (at least!) hard disk space and memory on Oracle. > > }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. single database per instance is correct... Your solution will work, but amount of CPU/disk/memory required needs to be estimated quite carefully! I would try structure like: using database name (in Informix) as user name (in Oracle), but I am not sure if it will work with identical table names. > } > }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). > } will OS level authorization work for you? > }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. Good Luck, I spent few days getting my Oracle database setup first time, Alex