Re: Benefit going for oracle Database 10g with 11i applications

I am also trying to upgrade the Database from the 9.2.0.5.0 to 10gR2 in
my test environment. Can u forward me the documents which u have used to
perform this up gradation.

As I said already I have used
Note362203.1 Oracle Applications Release 11i with Oracle Database 10g Release 2
as main document.
I can send the technical instruction (commands level) but I am afraid
that you will not benefit that document as during that upgrade I am
installing a bunch of patches together and situation in your
environment can be slightly different, so you wouldn't be able to use
those instruction. (I can send it anyway ;)

However, if you are facing some problems during an upgrade process I
will be more than happy to help you. Just post the error messages you
have got and describe your situation.
I am sure I and others would be able to help you.

Yury


On 5/26/06, Srawan <srawankumar.pn@xxxxxxxxxxxxxxxxx> wrote: 
Hi Yury,

I am also trying to upgrade the Database from the 9.2.0.5.0 to 10gR2 in
my test environment. Can u forward me the documents which u have used to
perform this up gradation.

As well I would like to know the whether anybody did 9iAS to 10giAS
stack upgradation.If so please give the information.

Dear Rahul,

Very useful information related to Oracle Apps is attached in the above
PPT.Please check it. It will be very useful for you.

Thanks and Regards,
Srawan Kumar P.N.

DBA - Oracle Apps
Telesis Global Solutions

"'Arise, awake, and stop not till the goal is reached.'"  - Swamy
Vivekananda



-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs
Velikanovs
Sent: Friday, May 26, 2006 6:07 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Benefit going for oracle Database 10g with 11i applications

Hi Rohit,

I am doing 10G R2 implementation in a 11.5.10.2 environment at the
moment.
Some general ideas:
-- It is time then 10G became reliable enough to implement it in the
production (R2 + first patch released 1/2 year ago).
-- Optimizer in 10G is smarter the in 9i and generally speaking 98% of
your SQL-s will have better or the same performance.
   For as it is actual in terms of Discoverer reports. We have got a
lot of them and some are not preforming well.
   Just one example: The Disc Report with 500 rows in an execution
plan executes within 10 hours in our current production environment. I
have tried to execute the same report on upgraded test environment and
it took 5 sec to complete (the same SQL on the same DATA)
-- Looking back in history we can assume that this version of Oracle
RDBMS will be supported longer then any available today and any wich
will appear in nearest feature.

Just some general ideas.
Today I have to finish upgrading functional test environment and let
business to run tests.
The testing results expected within next 2 weeks.

Yury


On 5/26/06, Rohit Goyal <rgoyal_dba@xxxxxxxxx> wrote:
>
>
> Hi, folks,
> We currently have Oracle Applications 11i, (11.5.10.2) with database
9i
> (9.2.0.6). We are thinking about going for 10g but we are not sure
whats the
> benefit we will get.
> If any one has done some research on it, or has some documents then
can you
> please share with me. Before we decide to move to 10g, I want to make
sure
> it is right thing to do. If we don't move to 10g, what we will miss,
or what
> will be impact in future.
> Any comment will be helpful.
> Thanks,
>
> Regards,
> Rohit
>


--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html





--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html

Other related posts: