RE: upgrade from 8.1.6 to 8.1.7

From: Nuala Cullen <ncullen_at_catlogic.com>
Date: Tue, 3 Feb 2004 08:56:34 -0000
Message-ID: <GJEIKLKHHGODGLDFHFCAIEEJNDAA.NCullen@catlogic.com>

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!

-----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

;-)

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org put

'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Feb 03 2004 - 02:56:34 CST