RE: Automation of Migration to Oracle9i

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.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).