Re: from oracle 9.2.04 to oracle 9.2.05

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 May 2005 04:44:38 -0700
Message-ID: <1115811878.818419.202530@z14g2000cwz.googlegroups.com>

jakko1982 wrote:
> i'm a newbie, i'd like to guess if anybody knows how can I upgrade my
> oracle 9.2.04 to 9.2.05.
> My java_pool_size, shared_pool_size are under 150 MB. How can I set
> this value?
>
> Bye and thx a lot.

Goto http://metalink.oracle.com and download the 9.2.0.5 patchset. You can also goto 9.2.0.6. Patch installation documentation comes with it. Make sure you review the documentation before applying the patchset.
Goto http://tahiti.oracle.com and review the "Initialization Parameter" section. If you are using spfile (Server Parameter File) then you can change these parameters online. Search for "spfile" keyword and goto "Administrator's Guide". If you are not using spfile then you need to locate the database init.ora file, modify the parameter values and bounce the database.

Regards
/Rauf Received on Wed May 11 2005 - 06:44:38 CDT