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

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_at_labor.state.ny.us>
+ 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_at_gcrta.org]
> Sent: Wednesday, March 02, 2005 8:39 AM
> To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com;
> ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; OAUGNetDBA_at_oaug.com;
> oracle-rdbms_at_yahoogroups.com
> 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