Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Automation of Migration to Oracle9i

Re: Automation of Migration to Oracle9i

From: Jared Still <>
Date: Fri, 27 Sep 2002 07:38:28 -0800
Message-ID: <>

It will be more work, but still can be done.

Use Win32::TieRegistry in Perl to deal with the registry entries.


On Friday 27 September 2002 04:58, Kieran Murray wrote:
> Thanks for this Gerardo,
> I forgot to mention, but unfortunately this activity will have to
> be carried out on NT rather than Unix. I guess it would be more
> complicated as the registry and services would come into play aswell.
> Cheers,
> Kieran
> -----Original Message-----
> Sent: Thursday, September 26, 2002 6:14 PM
> To: Multiple recipients of list ORACLE-L
> I think it's very possible. Run the Universal Installer once
> (interactively). Tar up the stuff under the product directory (all
> subdirectories including jre and
> Now you can use the tar file to install to another machine. Write a
> wrapper script that untars your image.
> I recommend Perl and the Expect perl module for this type of work. This
> combination (Perl with Expect module) makes telnet'ing and ftp'ing a snap.
> I haven't tried to do ssh and scp yet via this method but I suspect it's
> also possible.
> There are some gotchas to watch out for.
> You have to keep the ORACLE_HOME directory name the same. Don't expect
> things to work if you change the directory name. This used to be the case
> with 7.x but not any more since 8.1.x.
> If you are setting up web server, then I think you have to figure out where
> the host name is "hard-coded" into the config files. We have not had to
> worry about this, since we do not set up the web server as part of our
> database server installs.
> Gerardo
> -----Original Message-----
> Sent: Thursday, September 26, 2002 7:48 AM
> To: Multiple recipients of list ORACLE-L
> 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:
Author: Jared Still

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Fri Sep 27 2002 - 10:38:28 CDT

Original text of this message