bpgergo
asked on
Which patch set for a database 9.2.0.4? Any newer then 3501955?
Hi,
never patched so far,
mainly use 10g databases
but also have a production database server version 9.2.0.4 and it has not been patched so far
--or is it really 9.2.0.4? don't know what is this CORE supposed to be, but is not 9.2.0.4
select * from v$version
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
I have several problems with it and decided to patch it
(pls. do not go here into why patch, maybe other solution would be more appropriate, thx)
The patch I was able to find on metalink is the following:3501955
Theoretically it'll upgrade it to 9.2.0.5
Is there a newer patchset which upgrades 9.2.0.4 to a higher version?
Will I face incompatibility issues? like someone said that the listener will work differently from version 9.2.0.5 then in 9.2.0.4 and listener.ora will have to be modified in order to keep the database available for non-local connections?
Thank you very much
Gergo
never patched so far,
mainly use 10g databases
but also have a production database server version 9.2.0.4 and it has not been patched so far
--or is it really 9.2.0.4? don't know what is this CORE supposed to be, but is not 9.2.0.4
select * from v$version
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
I have several problems with it and decided to patch it
(pls. do not go here into why patch, maybe other solution would be more appropriate, thx)
The patch I was able to find on metalink is the following:3501955
Theoretically it'll upgrade it to 9.2.0.5
Is there a newer patchset which upgrades 9.2.0.4 to a higher version?
Will I face incompatibility issues? like someone said that the listener will work differently from version 9.2.0.5 then in 9.2.0.4 and listener.ora will have to be modified in order to keep the database available for non-local connections?
Thank you very much
Gergo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also dont forget to apply the "Oracle Critical Patch Update July 2006". This has many security fixes for oracle networking components.
metalink doc # 372927.1
metalink doc # 372927.1
ASKER
Thanks techji,
just reading the readme page for 4547809.
it says:
"Patch sets are cumulative. Patch set release 9.2.0.8 includes all fixes in patch sets 9.2.0.8 and earlier as well as new fixes for patch set 9.2.0.8. This means that unless the patch set documentation indicates otherwise, you can apply this patch set to any earlier release 9.2 installation. You do not have to install intermediate patch sets."
My problem was not being aware of this cumulative attribute of patches. I thougth it can only be applied on 9.2.0.7
Also I saw that this patch was last updated on 25-AUG-2006.
So it should be just what I need.
This "Oracle Critical Patch Update July 2006" should be installed after the 4547809 patch, shouldn't it?
Thanks.
Gergo
just reading the readme page for 4547809.
it says:
"Patch sets are cumulative. Patch set release 9.2.0.8 includes all fixes in patch sets 9.2.0.8 and earlier as well as new fixes for patch set 9.2.0.8. This means that unless the patch set documentation indicates otherwise, you can apply this patch set to any earlier release 9.2 installation. You do not have to install intermediate patch sets."
My problem was not being aware of this cumulative attribute of patches. I thougth it can only be applied on 9.2.0.7
Also I saw that this patch was last updated on 25-AUG-2006.
So it should be just what I need.
This "Oracle Critical Patch Update July 2006" should be installed after the 4547809 patch, shouldn't it?
Thanks.
Gergo
Yup. you can apply 9.2.0.8 on any previous version.
And yes, apply the July Critical Update after you apply 9.2.0.8 patchset to the binaries/database.
And yes, apply the July Critical Update after you apply 9.2.0.8 patchset to the binaries/database.
ASKER
Good techji,
seems we're done.
Will approve the answer when finished with patching. (06.09.13., Wednesday, have many other issues).
Thanks again.
Gergo
seems we're done.
Will approve the answer when finished with patching. (06.09.13., Wednesday, have many other issues).
Thanks again.
Gergo
ASKER
Hi Venabili,
I had other DBs to maintain and other more urgent projects to work on.
I still plan to apply this patch (which was recommended) when I'll have time for it in the near future.
Also I plan to accept the answer when I'm done with patching and everything is all right.
Thank you for your patience.
Gergo
I had other DBs to maintain and other more urgent projects to work on.
I still plan to apply this patch (which was recommended) when I'll have time for it in the near future.
Also I plan to accept the answer when I'm done with patching and everything is all right.
Thank you for your patience.
Gergo
Any news here?
ASKER
Sorry for the delay,
(eventually an other colleague did this stuff)
the patch set was OK, thanks
(eventually an other colleague did this stuff)
the patch set was OK, thanks
There are no incompatability issues that I noticed when I moved from 9.2.0.4 to newer versions.