| 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: upgrade from 8.1.6 to 8.1.7
Hi there,
We had a nightmare upgrade from 8.1.6 to 8.1.7 because of the way our application code was written.
There were commits within cursor for loops - which caused the loop to end - thus not dealing with all the data in the cursor.
Might be something to look out for,
good luck!
N.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Andrey Bronfin
Sent: 01 February 2004 15:22
To: oracle-l_at_freelists.org; oracledba_at_lazydba.com
Subject: RE: upgrade from 8.1.6 to 8.1.7
THANKS A LOT TO ALL WHO REPLIED !!!
-----Original Message-----
From: MacGregor, Ian A. [mailto:ian_at_SLAC.Stanford.EDU]
Sent: ? 01 ?????? 2004 4:30
To: 'oracle-l_at_freelists.org'; oracledba_at_lazydba.com
Subject: RE: upgrade from 8.1.6 to 8.1.7
The most common problem is the failure to disable the system level triggers and job queues during the upgrade Are you using any of the OWA packages? 8.1.7 installs these in the sys schema and establishes public synonyms for them. It is possible some of your programs will not work with these new packages. It is quite probable WebDB will not work with sys.OWA packages.
If the database supports a third party application, be sure to visit that site for cetification and known problems.
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
From: Andrey Bronfin [mailto:andreyb_at_elrontelesoft.com]
Sent: Thursday, January 29, 2004 5:34 AM
To: oracle-l_at_freelists.org; oracledba_at_lazydba.com
Subject: upgrade from 8.1.6 to 8.1.7
Hi friends !
I'm about to upgrade a DB rom Oracle 8.1.6 EE 32-bit to Oracle 8.1.7 EE
32-bit on HP-UX 11.11 Are there any known issues, pitfalls etc. thta I'd
better be aware of before i begin ? Thanks a lot in advance.
P.S> No, i can not upgrade to Oracle 9.* neither can i go 64-bit
;-)
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |