Re: Automation of Migration to Oracle9i

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

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

Jared

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 9.2.0.1).
>
> 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.
>
> HTH
> 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: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).