Re: 8i to 9i upgrade of Oracle Apps database

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
> 
> --
> http://www.freelists.org/webpage/oracle-l 
> --
> http://www.freelists.org/webpage/oracle-l 

--
http://www.freelists.org/webpage/oracle-l 



--
http://www.freelists.org/webpage/oracle-l

Other related posts: