Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 8i to 9i upgrade of Oracle Apps database

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

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 02 Mar 2005 09:35:36 -0500
Message-Id: <s22588fe.016@gcrta.org>


Our shared_pool is 320M already.
>>> Scott Dial <smd_at_triquetra.homelinux.org> 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_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 



--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 02 2005 - 09:39:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US