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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Kieran Murray INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).