RE: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
A quick scan of it looks ok. Not sure about copying the password file. Too easy to create it to bother I think. BTW, export the Oracle registry key to a file first. It comes in useful on occasion. :) Jared Jack van Zanen <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/02/2003 01:10 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K I have a few databases in Home0 and a few in Home1 and need to move one from Home0 to Home1 So if I understand correct I can do: Oradim -delete -sid Remove the entries that look like ORA__AUTOSTART ORA__SHUTDOWN ORA__SHUTDOWNTYPE ORA__SHUTDOWN_TIMEOUT >From Home0(if not done by oradim) Put the init.ora file in the new home location Create a new service \bin\oradim.exe -new -sid -startmode m \bin\oradim.exe -edit -sid -startmode a \bin\orapwd.exe file=d:\oracle\ora90\database\PWD.ora password= (Or can I just copy the password file?) Change the listener.ora Start the database Run catalog/catproc/catexp etc Is this Correct??? TIA Jack -Original Message- Sent: Tuesday, July 01, 2003 11:07 PM To: Multiple recipients of list ORACLE-L Assuming that you are changing the second Oracle Home, ie. Home1. Change the following entries in the registry: HKLM\Software\Oracle\ALL_HOMES\ID1\PATH HKLM\Software\Oracle\HOME1\ORACLE_HOME Depending on how you've located init and dump files, etc., you may see other entries in HKLM\Software\Oracle\HOME1 that need to be changed as well. You then need to remove and re-create the service. oradim -delete -sid SID oradim -new -sid SID -pfile type oradmin on a command line to get all options. Then check HKLM\System\CurrentControlSet\Services\OracleService to ensure that the correct binary is in use. Edit your tnsnames.ora/names registry or whatever you use for name resolution. That should about do it. Jared Jack van Zanen <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2003 08:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K Hi All, We have a test machine with both the 81730 and 81741 software in their own oracle homes. We now want to move a database from the 81730 home to 81741 I know I have to run the catalog.sql, catproc.sql from the new home etc... But how do I tell the registry that the database moved homes?? TiA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Jack van Zanen 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.net -- Author: 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: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
I have a few databases in Home0 and a few in Home1 and need to move one from Home0 to Home1 So if I understand correct I can do: Oradim -delete -sid Remove the entries that look like ORA__AUTOSTART ORA__SHUTDOWN ORA__SHUTDOWNTYPE ORA__SHUTDOWN_TIMEOUT >From Home0(if not done by oradim) Put the init.ora file in the new home location Create a new service \bin\oradim.exe -new -sid -startmode m \bin\oradim.exe -edit -sid -startmode a \bin\orapwd.exe file=d:\oracle\ora90\database\PWD.ora password= (Or can I just copy the password file?) Change the listener.ora Start the database Run catalog/catproc/catexp etc Is this Correct??? TIA Jack -Original Message- Sent: Tuesday, July 01, 2003 11:07 PM To: Multiple recipients of list ORACLE-L Assuming that you are changing the second Oracle Home, ie. Home1. Change the following entries in the registry: HKLM\Software\Oracle\ALL_HOMES\ID1\PATH HKLM\Software\Oracle\HOME1\ORACLE_HOME Depending on how you've located init and dump files, etc., you may see other entries in HKLM\Software\Oracle\HOME1 that need to be changed as well. You then need to remove and re-create the service. oradim -delete -sid SID oradim -new -sid SID -pfile type oradmin on a command line to get all options. Then check HKLM\System\CurrentControlSet\Services\OracleService to ensure that the correct binary is in use. Edit your tnsnames.ora/names registry or whatever you use for name resolution. That should about do it. Jared Jack van Zanen <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2003 08:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K Hi All, We have a test machine with both the 81730 and 81741 software in their own oracle homes. We now want to move a database from the 81730 home to 81741 I know I have to run the catalog.sql, catproc.sql from the new home etc... But how do I tell the registry that the database moved homes?? TiA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Jack van Zanen 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: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
Assuming that you are changing the second Oracle Home, ie. Home1. Change the following entries in the registry: HKLM\Software\Oracle\ALL_HOMES\ID1\PATH HKLM\Software\Oracle\HOME1\ORACLE_HOME Depending on how you've located init and dump files, etc., you may see other entries in HKLM\Software\Oracle\HOME1 that need to be changed as well. You then need to remove and re-create the service. oradim -delete -sid SID oradim -new -sid SID -pfile type oradmin on a command line to get all options. Then check HKLM\System\CurrentControlSet\Services\OracleService to ensure that the correct binary is in use. Edit your tnsnames.ora/names registry or whatever you use for name resolution. That should about do it. Jared Jack van Zanen <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/01/2003 08:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K Hi All, We have a test machine with both the 81730 and 81741 software in their own oracle homes. We now want to move a database from the 81730 home to 81741 I know I have to run the catalog.sql, catproc.sql from the new home etc... But how do I tell the registry that the database moved homes?? TiA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
Try telling it very nicely. :) Try looking in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. You can change the home location of the appropriate instance (HOME0, HOME1, etc.) there. Change it in the main Oracle directory then in the individual HOME(n) folder. I hope this helps. Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] EMS.NL To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K ity.com 07/01/2003 10:55 AM Please respond to ORACLE-L Hi All, We have a test machine with both the 81730 and 81741 software in their own oracle homes. We now want to move a database from the 81730 home to 81741 I know I have to run the catalog.sql, catproc.sql from the new home etc... But how do I tell the registry that the database moved homes?? TiA Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: [EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).