Re: Migration from Informix to Oracle 7.3.3

In article <34b0ed5e.0_at_news.cc.umr.edu>, Nathan Neulinger <nneul_at_umr.edu> 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.

It's hard to say from the amount of information given, but I think we have a terminology problem here. I think what Informix is calling a "database" Oracle calls a "schema." Database may be a much more all-encompassing concept in Oracle.

>
>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).

Without knowing exactly what you are doing, I'd say you might want to look into the OS_AUTHENT_PREFIX capability for Oracle to use the operating system to control logins.

>
>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.

Get some good consultants in there, before you start blaming your "learning experiences" on Oracle.

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

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!