RE: upgrade from 8.1.6 to 8.1.7
- From: "Nuala Cullen" <ncullen@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>
- Date: Tue, 3 Feb 2004 08:56:34 -0000
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Andrey Bronfin
Sent: 01 February 2004 15:22
To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx]
Sent: ? 01 ?????? 2004 4:30
To: 'oracle-l@xxxxxxxxxxxxx'; oracledba@xxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: Andrey Bronfin [mailto:andreyb@xxxxxxxxxxxxxxxxx]
Sent: Thursday, January 29, 2004 5:34 AM
To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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
;-)
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
