Re: 8i to 9i upgrade of Oracle Apps database
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <smd@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 02 Mar 2005 09:35:36 -0500
Our shared_pool is 320M already.
>>> Scott Dial <smd@xxxxxxxxxxxxxxxxxxxxxxx> 3/2/05 9:12:13 AM >>>
We had that same problem albeit physical memory was fine. We increased
shared_pool_size to a min of 150 mb, and no problems after that. You
should be able to re-run the upgrade script with no problems.
-Scott
+-------- Original Message --------+
+ From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
+ Subject: RE: 8i to 9i upgrade of Oracle Apps database
+ Date: Wednesday March 2, 2005 09:00:17 AM
+ Lines: 37
> Jeff,
>
> Can you look via OEM to see what exactly the upgrade is running?
Look at
> any sql statements being executed to get a clue as to what is going
on? It
> may help you to determine what else you can do to help the process
along.
>
> Tom
>
> -----Original Message-----
> From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
> Sent: Wednesday, March 02, 2005 8:39 AM
> To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
> ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; OAUGNetDBA@xxxxxxxx;
> oracle-rdbms@xxxxxxxxxxxxxxx
> Subject: 8i to 9i upgrade of Oracle Apps database
>
> Running u0801070.sql - it has been running for 20 hours now.
>
> We are seeing 4030 errors, etc.
>
> Only thing changed init.ora so far is to increase java pool from 50m
to
> 200 m per upgrade instructions.
>
> Help.
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
