9i patch upgrade to 9.0.2.4

Printable View

12-19-2003, 08:56 AM
prodadmin

9i patch upgrade to 9.0.2.4

Hi

we are going to apply patch (9.0.2.4) on our database.I would like to know ,aany one have any weird experiences while applying patch or need to take care anything apart from what has been mentioned in the
oracle documentation

thanks
12-19-2003, 09:48 AM
jrpm

I recently did the upgrade for AIX 5L.

Make sure your SGA is at least 400MB, with 150 MB for the Java Pool and 150 MB for the Large pool (I think, see the README.)

Basically, it looks like Oracle will/now needs at least a 512MB SGA to run okay.

Also, I always find at least 1 OS library our admin's haven't updated.
12-19-2003, 10:49 AM
marist89

The instructions (for solaris anyway) state that you have to upgrade the installer before you apply the patch.
12-19-2003, 03:42 PM
Cookies

If you are referring to 9.2.0.4 then it was effortless on Solaris if you follow the readme instructions.

Linux is a whole other kit-and-kaboodle!
Don't get me started
12-19-2003, 04:01 PM
marist89

hmm, I actually found Linux easier than Solaris...
12-19-2003, 04:22 PM
Cookies

9.2.0 was fine on install, it was the patch that caused me grief.

I know little regarding Linux.

I believe the difficulty was that it was Red Hat Linux 9 and Oracle only supports version 7? Does that sound right?

So, I had to do a few tweaks here and there.
12-19-2003, 04:36 PM
marist89

Hmm, I did it on RH9 and RH2.1AS without issue. However, I try to keep my boxes up to date as best as I can...
12-20-2003, 09:13 AM
prodadmin

actually i was doing for windows 2000 32bit.It went well
Also even i had more than 150 mB , it was all wining about java pool but continued .

Workspace didn't upgraded to 9.0.2.4.rest went well

thanks guys
12-20-2003, 12:54 PM
stecal

What is version 9.0.2.4?
12-20-2003, 04:07 PM
prodadmin

yes
12-20-2003, 04:32 PM
patel_dil

prodadmin : Did you mean 9.2.0.4 patchset? There is no patch called 9.0.2.4.
12-23-2003, 03:46 PM
Cookies

Quote:

Originally posted by marist89
Hmm, I did it on RH9 and RH2.1AS without issue. However, I try to keep my boxes up to date as best as I can...

There was my problem.
It was a box that was sitting around doing nothing and at the time I didn't even know what 'rpm' was since I had never worked on Linux.
Definitely added some skills during the installation.
12-24-2003, 12:11 PM
leo

It went fine on AIX. Keep in mind one of the bugs - the CORE's version is showing 9.2.0.3:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production