Re: 8.1.7.4 upgrade - 10g or 11

Harish,  I dont agree, there is a connect role in 10g(10.2), its just 
doesn't have all of the privileges from previous version, it only has 
create session now.

Thanks,  Joe

---------------------------------------
You can have it: Fast, Right or Cheap, pick 2 of the 3.
Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.



"Harish Kalra" <harish.kumar.kalra@xxxxxxxxx>
 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx




04/17/2008 06:13 AM
Please respond to harish.kumar.kalra@xxxxxxxxx

From
"Harish Kalra" <harish.kumar.kalra@xxxxxxxxx>
To
peter.schauss@xxxxxxx
cc
oracle-l@xxxxxxxxxxxxx
Subject
Re: 8.1.7.4 upgrade - 10g or 11






Peter, along with the CBO changes, there are other itmes that you must 
consider before upgrading to 10g such as datababase users with CONNECT 
role because there is no CONNECT role in 10g, timezones files are of 
higher version in 10g so if you storing data with TIMESTAMP WITH TIMEZONE 
then you will have to migrate the data carefully. In 10g dblinks store the 
encrypted passwords so you may need to recreate your dblink in 10g. If you 
read the upgrade guide, all this is documented properly. 
 
I would suggest to upgrade to 10.2.0.3 and apply the latest patches 
advised in Critical Patch Advisory by Oracle. 
 
Thanks & Regards

 
On 4/10/08, Schauss, Peter <peter.schauss@xxxxxxx> wrote: 
We are starting to plan an upgrade of one of our applications which
currently runs on Oracle 8.1.7.4 on a Solaris server.  The database is
about 70 gb and I expect that the entire upgrade process will take
between four and six months.  The new version of the application will
support either Oracle 10g or 11.  Is 11g reliable enough that we should
consider it instead of 10g?

Will I be able to upgrade the 8.1.7.4 instance directly to the final
version or will I need to do an intermediate upgrade?

Thanks,
Peter Schauss
--
http://www.freelists.org/webpage/oracle-l

Other related posts: