troubleshooting Question

Which patch set for a database 9.2.0.4? Any newer then 3501955?

Avatar of bpgergo
bpgergo asked on
Oracle Database
9 Comments1 Solution969 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
techji

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros