Automation of Migration to Oracle9i

Hi,

I've been charged with coming up with automation scripts which will migration
customer databases from Oracle 7.3.4 to Oracle 9i (35 databases in all). As the databases aren't huge I was gonna go with the Export/Import option
(rather than MIG utility),

so I'm in the process of writing batch files and sql scripts to automate this stage of the process.

I was under the impression that the installation of the 9i software would be a manual process,
but from the Universal Installer help I see it's possible to run this in silent mode with response files.

Has anyone ever used this before and how have you got on? Do you think it would be possible for
me to come up with scripts to automate this to run on all the client sites with minimal user intervention (assuming identical file systems)?

It sounds too good to be true.

Cheers,
Kieran Murray
CardBASE Technologies Limited®
Crofton Road
Dun Laoghaire
Co Dublin
Ireland

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kieran Murray
  INET: Kieran.Murray_at_CardBase.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).