RE: 8.1.6 to 8.1.7 upgrade
Rachna - Decide carefully on which 8.1.7 version to upgrade to. Which platform are you on? That may help someone give you advice specific to your platform. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 01, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: DENNIS WILLIAMS 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: 8.1.6 to 8.1.7 upgrade
I also found that I had to use SVRMGRL instead of SQLPLUS when doing the Java install. Dunno why. HP-UX 11.0 and 11i. I think it takes so long because it is reloading and revalidating the whole entire Java library. I guessing. My 2¢ worth... Mike -Original Message- Sent: Tuesday, October 01, 2002 10:56 AM To: Multiple recipients of list ORACLE-L If you have java installed be aware that there are a lot of changes with 8.1.7. If you have problems with the upgrade you *cannot* simply run rmjvm.sql and initjvm.sql There are two documents on removing and installing java which are must reads (I don't have the numbers handy, sorry). Allow a lot of time for the java upgrade. In the end I found it easier to remove java and do a fresh install (it helped that we weren't actually using it outside of development at the time). Good luck! Jay Miller -Original Message- Sent: Tuesday, October 01, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Miller, Jay 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: Vergara, Michael (TEM) 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: 8.1.6 to 8.1.7 upgrade
If you have java installed be aware that there are a lot of changes with 8.1.7. If you have problems with the upgrade you *cannot* simply run rmjvm.sql and initjvm.sql There are two documents on removing and installing java which are must reads (I don't have the numbers handy, sorry). Allow a lot of time for the java upgrade. In the end I found it easier to remove java and do a fresh install (it helped that we weren't actually using it outside of development at the time). Good luck! Jay Miller -Original Message- Sent: Tuesday, October 01, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Miller, Jay 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: 8.1.6 to 8.1.7 upgrade
On Tue, Oct 01, 2002 at 07:48:33AM -0800, Rachna Vaidya wrote: > Gurus! > > Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? -- 1. Don't be tempted to run below 8.1.7.4. 2. Do patch the listener vulnerability. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
8.1.6 to 8.1.7 upgrade
Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: 64-to-32-bit "upgrade" (was "8.1.6 to 8.1.7 upgrade")
I did not have a specific problem, it's just that patches are 3 to 6 months behind the 32 bit version, on Solaris anyway. I have 2 bugs fixed in 8163 which is not available... Also, we will not have that much ram available so I'm ok with the 32 bit version. --- "Jesse, Rich" <[EMAIL PROTECTED]> a écrit : > Stephane, > > I've had questions on migrations and upgrades in the > past and the final > answer has always been: It is always safest to > export/import to change what > version of Oracle your database uses. It's > certainly leaves the tablespaces > a helluva lot cleaner than the other methods of > migration! Of course, in > what most consider a "downgrade" from 64-to-32-bit, > I'm not sure the same > applies... > > BTW, what problems with 64-bit did you encounter? > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > > -Original Message- > Sent: Thursday, July 19, 2001 14:11 > To: Multiple recipients of list ORACLE-L > > > I did not find on metalink how to "upgrade" and > change > the wordsize from 64bit to 32bit. > Yes, I'm tired of waiting for patches that never > come... > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
64-to-32-bit "upgrade" (was "8.1.6 to 8.1.7 upgrade")
Stephane, I've had questions on migrations and upgrades in the past and the final answer has always been: It is always safest to export/import to change what version of Oracle your database uses. It's certainly leaves the tablespaces a helluva lot cleaner than the other methods of migration! Of course, in what most consider a "downgrade" from 64-to-32-bit, I'm not sure the same applies... BTW, what problems with 64-bit did you encounter? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, July 19, 2001 14:11 To: Multiple recipients of list ORACLE-L I did not find on metalink how to "upgrade" and change the wordsize from 64bit to 32bit. Yes, I'm tired of waiting for patches that never come... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 8.1.6 to 8.1.7 upgrade
It's pretty simple, actually, to change the wordsize. Check out the Oracle8i Migration guide - specifically, page 7-38. Brian paquette stephane wrote: > I did not find on metalink how to "upgrade" and change > the wordsize from 64bit to 32bit. > Yes, I'm tired of waiting for patches that never > come... > > --- Jared Still <[EMAIL PROTECTED]> a écrit : > > > For the record, this isn't a migration, it's an > > upgrade. > > > > A migration is changing your database to a new > > version. > > > > An upgrade is a new release. > > > > 8.1.6 -> 8.1.7 is a new release, and an upgrade > > according to Oracle. > > > > Migrations imply much more work than an upgrade. > > > > Jared > > > > > > On Thursday 19 July 2001 11:05, > > [EMAIL PROTECTED] wrote: > > > Take a look at the Oracle 8i Mogration Guide, part > > number A86632-01 > > > (available on Technet). In particular, review all > > the steps in Chapter 7. > > > You can either have the installer do the migration > > for you, or do it > > > manually. I just did a migration from 8.1.6 to > > 8.1.7.1.3 on NT 4 Sp6a > > > following the instructions in the document above > > and had no issues. FWIW, > > > I followed the manual path ;-) > > > > > > Best of Luck! > > > Mike > > > > > > [EMAIL PROTECTED] wrote: > > > > We are about to do an 'emergency' upgrade from > > 8.1.6 to 8.1.7 on NT > > > > 4.0.Since this is the first time we are doing > > this on NT, I am wondering > > > > if > > > > > > anybody on the list who has been there, done that, > > and let us know what > > > kind of caveats we might run into or just outline > > the steps we should go > > > through. I know Oracle provide a GUI tool for this > > but I don't know if it's > > > that reliable. > > > > > > TIA > > > > > > Dennis Meng > > > Database Administrator > > > Focal Communications > > > 847-954-8328 > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > 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). > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Vos albums photos en ligne, > Yahoo! Photos : http://fr.photos.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 8.1.6 to 8.1.7 upgrade
I did not find on metalink how to "upgrade" and change the wordsize from 64bit to 32bit. Yes, I'm tired of waiting for patches that never come... --- Jared Still <[EMAIL PROTECTED]> a écrit : > > For the record, this isn't a migration, it's an > upgrade. > > A migration is changing your database to a new > version. > > An upgrade is a new release. > > 8.1.6 -> 8.1.7 is a new release, and an upgrade > according to Oracle. > > Migrations imply much more work than an upgrade. > > Jared > > > On Thursday 19 July 2001 11:05, > [EMAIL PROTECTED] wrote: > > Take a look at the Oracle 8i Mogration Guide, part > number A86632-01 > > (available on Technet). In particular, review all > the steps in Chapter 7. > > You can either have the installer do the migration > for you, or do it > > manually. I just did a migration from 8.1.6 to > 8.1.7.1.3 on NT 4 Sp6a > > following the instructions in the document above > and had no issues. FWIW, > > I followed the manual path ;-) > > > > Best of Luck! > > Mike > > > > [EMAIL PROTECTED] wrote: > > > We are about to do an 'emergency' upgrade from > 8.1.6 to 8.1.7 on NT > > > 4.0.Since this is the first time we are doing > this on NT, I am wondering > > > if > > > > anybody on the list who has been there, done that, > and let us know what > > kind of caveats we might run into or just outline > the steps we should go > > through. I know Oracle provide a GUI tool for this > but I don't know if it's > > that reliable. > > > > TIA > > > > Dennis Meng > > Database Administrator > > Focal Communications > > 847-954-8328 > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 8.1.6 to 8.1.7 upgrade
For the record, this isn't a migration, it's an upgrade. A migration is changing your database to a new version. An upgrade is a new release. 8.1.6 -> 8.1.7 is a new release, and an upgrade according to Oracle. Migrations imply much more work than an upgrade. Jared On Thursday 19 July 2001 11:05, [EMAIL PROTECTED] wrote: > Take a look at the Oracle 8i Mogration Guide, part number A86632-01 > (available on Technet). In particular, review all the steps in Chapter 7. > You can either have the installer do the migration for you, or do it > manually. I just did a migration from 8.1.6 to 8.1.7.1.3 on NT 4 Sp6a > following the instructions in the document above and had no issues. FWIW, > I followed the manual path ;-) > > Best of Luck! > Mike > > [EMAIL PROTECTED] wrote: > > We are about to do an 'emergency' upgrade from 8.1.6 to 8.1.7 on NT > > 4.0.Since this is the first time we are doing this on NT, I am wondering > > if > > anybody on the list who has been there, done that, and let us know what > kind of caveats we might run into or just outline the steps we should go > through. I know Oracle provide a GUI tool for this but I don't know if it's > that reliable. > > TIA > > Dennis Meng > Database Administrator > Focal Communications > 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 8.1.6 to 8.1.7 upgrade
Take a look at the Oracle 8i Mogration Guide, part number A86632-01 (available on Technet). In particular, review all the steps in Chapter 7. You can either have the installer do the migration for you, or do it manually. I just did a migration from 8.1.6 to 8.1.7.1.3 on NT 4 Sp6a following the instructions in the document above and had no issues. FWIW, I followed the manual path ;-) Best of Luck! Mike [EMAIL PROTECTED] wrote: > We are about to do an 'emergency' upgrade from 8.1.6 to 8.1.7 on NT 4.0.Since this >is the first time we are doing this on NT, I am wondering if anybody on the list who has been there, done that, and let us know what kind of caveats we might run into or just outline the steps we should go through. I know Oracle provide a GUI tool for this but I don't know if it's that reliable. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
8.1.6 to 8.1.7 upgrade
We are about to do an 'emergency' upgrade from 8.1.6 to 8.1.7 on NT 4.0. Since this is the first time we are doing this on NT, I am wondering if anybody on the list who has been there, done that, and let us know what kind of caveats we might run into or just outline the steps we should go through. I know Oracle provide a GUI tool for this but I don't know if it's that reliable. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).