RE: Manual UPgrade question
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <dramirezr@xxxxxxxxx>, "'Storey, Robert \(DCSO\)'" <RStorey@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 3 Jul 2014 11:41:47 -0400
In addition to the optional case sensitivity on the passwords, there is a
MAJOR change in the things that come along with the default connect role
across the version boundaries you are crossing (starting in 10.2 if memory
serves.) Some review is usually required to keep the default tightening of
security while making the appropriate individual user grants to have your
applications still work. Bundling these in roles for applications and
granting the required application role is one useful way to do this.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of David Ramírez Reyes
Sent: Thursday, July 03, 2014 10:26 AM
To: Storey, Robert (DCSO)
Cc: Oracle L
Subject: Re: Manual UPgrade question
I have migrated about 6 DB's from 8i to 11g and yes, the sys tablespace have
different contents (some views, packages and sp's have changed or
disappeared), don't forget that 11g is case sensitive for example (you would
like disable that function probably).
Personally, I created the tablespaces on the new db, then created the
objects (generated the DDL of all tables, indexes, triggers, sequences, sp's
and packages) and then just made an export file with the contents of the
tables only, fast and "easy", I have used this method on all the db's
without any problem.
Before decide any option, I tried different methods (importing datafiles
from 8i to 11g, direct upgade, migration to 10g and then upgrade to 11g, a
single full export file, copy of objects directly without db's, a 10g db in
the middle), some of them "worked", but the list of errors were huge or
critical so that the process would be highly risky or I would have spent
more time finding and fixing all the errors than copying the objects one by
one.
That's from 8i of course...
David Ramírez Reyes
MES Global DBA Technical Leader
On 3 July 2014 09:07, Storey, Robert (DCSO) <RStorey@xxxxxxxxxxxxxxxxxx>
wrote:
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
Other related posts:
