Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Migration from Informix to Oracle 7.3.3

Re: Migration from Informix to Oracle 7.3.3

From: David Williams <djw_at_smooth1.demon.co.uk>
Date: 1998/01/05
Message-ID: <t4b+SHADSSs0EwuE@smooth1.demon.co.uk>#1/1

In article <34b0ed5e.0_at_news.cc.umr.edu>, Nathan Neulinger <nneul_at_umr.edu> writes
>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
 Correct. Oracle people get used to each application having it's own  tables, not database...ROTFL..

>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
 

-- 
David Williams

Maintainer of the Informix FAQ
 Primary site (Beta Version)  http://www.smooth1.demon.co.uk
 Official site                http://www.iiug.org/techinfo/faq/faq_top.html

I see you standin', Standin' on your own, It's such a lonely place for you, For 
you to be If you need a shoulder, Or if you need a friend, I'll be here 
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care
Received on Mon Jan 05 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US