Re: Migration from Informix to Oracle 7.3.3
Posted in 1998
Topics: Installation, Setup & Upgrades, Security, Permissions & Auditing, Migration, Import/Export & Data Conversion
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 -----+