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

Swamy,

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

Please be aware that you can't substitute or upgrade 9iAS R1 used in
Apps installation (all current version) with AS 10G R2.

Only thing that you can do at the moment is to implement some bits of
AS 10G functionality as add-ons to your existing Apps environments.
Those bits of functionality are:
- Discoverer
- Portal
- Single Sign On

Ono of listened functions are critical of can substitute existing 9iAS
R1 core functions. You will still use it.
I wouldn't recommend to introduce additional monster in you Apps
installation as 10G R2 AS (with additional infrastructure DB and tons
of processes) which you will need to administer and maintain in
addition to your existing configuration unless you haven't got strong
business need for that.

BTW: Release 12 will be based on AS 10G R3 100%'. Where will not be
any 9i staff any more. I would recommend to wait another year and
plane for 12 release instead going with AS 10G release now.

PS AS 10G R2 doesn't support cloning :) as Apps does. You will spend a
lot of time implementing those procedures which Oracle doesn't
support.

Just my 0.02£,
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: