Re: Migration from Informix to Oracle 7.3.3

Just out of curiosity, if Oracle gave you all these problems, why was it decided to migrate to Oracle instead of upgrade to Informix ODS 7.2x? Please note, I have no experience in using Oracle, so I cannot confirm what you're saying; I'm taking your word for it, though I find it hard to believe that Oracle only allows one database per instance. Don't they follow standard SQL? At 01:31 PM 1/6/98 EDT, you wrote: } } }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@umr.edu }University of Missouri - Rolla Phone: (573) 341-4841 }Computing Services Fax: (573) 341-4216 } Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+