RE: FW: Manual UPgrade question
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <dramirezr@xxxxxxxxx>, <Hemant-K.Chitale@xxxxxx>
- Date: Fri, 4 Jul 2014 10:30:19 -0400
Nods. As Oracle promised might occur from at least the V5 manuals forward,
Oracle implemented a non-ordering method of aggregation (specifically hash),
so that group-by no longer inherently performed a sort. If memory serves,
only a few releases of V5 did a gratuitous extra sort in the presence of
group by and order by, so it was (almost) never a good idea to leave the
order by out if you wanted it. (And random ordering of reports is rarely
wanted, though hash order of intermediate results can potentially swing in
value either way).
So yes, scrutinize your code for this (but dont consider it an Oracle
flaw).
Back on the OPs first post, I was wondering *why* export/import was ruled
out. Size?
And I understand not wanting to temporarily pay extra for GG and similar.
But even if you data volume is very large, if your transaction rate is
modest it is possible to implement a variety of change tracking and
propagating mechanisms as of 9i.
Big multi-version upgrades do always pose various challenges if windows are
tight. Good luck with the process.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of David Ramírez Reyes
Sent: Friday, July 04, 2014 10:09 AM
To: Hemant-K.Chitale@xxxxxx
Cc: ORACLE-L
Subject: Re: FW: Manual UPgrade question
Didn't remember that detail of ORDER BY, that caused me lots of headaches on
the first db we migrated.
David Ramírez Reyes
MES DBA Technical Leader
On 4 July 2014 01:06, Chitale, Hemant K <Hemant-K.Chitale@xxxxxx> wrote:
Theres a 32MB file of a presentation Upgrade and Migrate to Oracle
Database 11g by Roy Swonger & Mike Dietrich.
Search for it on oracles site (or a google search).
Also remember that behaviour of Group By changes (results are NOT ordered as
you might have expected / seen them in 9i so an ORDER BY is necessary if
you expected sorted results), many optimizer changes as well. Changes to
dbms_stats are also significant.
Hemant K Chitale
From: Chitale, Hemant K
Sent: Friday, July 04, 2014 2:02 PM
To: 'RStorey@xxxxxxxxxxxxxxxxxx'
Cc: ORACLE-L
Subject: RE: Manual UPgrade question
Specifically responding to :
------------------------------------------------
According to documentation, the datafiles are not changed. The upgrade
involves recompilation of binaries and such.
Or does the upgrade alter the contents of the sys tablespace?
-------------------------------------------------
The Upgrade *DOES* update the system tablespace (lots and lots of changes
!). It would update the UNDO Tablespace. It also needs a new SYSAUX
tablespace. Datafile headers need to be updated when the database is OPENed.
The word size conversion requires additional scripts --- utlirp.sql and
utlrp.sql and a separate script for Java objects.
There are a number of support notes on word size conversion --- 62290.1,
548978.1, 341880.1 are three that I have saved.
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Storey, Robert (DCSO)
Sent: Thursday, July 03, 2014 10:08 PM
To: Oracle L
Subject: Manual UPgrade question
So working on a manual upgrade of 9iR2 to 11gR2. Changing hardware and word
size. Import/Export is not an option, DBUA is not an option, nor is
transportable tablespaces. Manual is all I have left short of buying
migration software such as Shareplex or Goldengate.
The manual upgrade appears straight forward. My question is for after the
upgrade.
So I have a new server that will be my production server. Ill do my
testing on it. So, assuming the manual upgrade is successfully wrung out
and tested and Im ready to do the live upgrade.
Im curious if , now that I have the upgraded DB on the production server
could I just recopy over new versions of the datafiles, controlfiles, redo
Logs(?) and restart the upgraded database without having to run through the
upgrade again.
According to documentation, the datafiles are not changed. The upgrade
involves recompilation of binaries and such.
Or does the upgrade alter the contents of the sys tablespace?
Thanks
This email and any attachments are confidential and may also be privileged.
If you are not the intended recipient, please delete all copies and notify
the sender immediately. You may wish to refer to the incorporation details
of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html.
Other related posts:
