| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Automation of Migration to Oracle9i
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: 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).
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).
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). Received on Fri Sep 27 2002 - 06:58:19 CDT
 |
 |