What platform?
Looks like 9.2.0.8 is the latest available on metalinks. You said "need" - you have to define that. Yes, you need a registration from metalinks; I have no idea how to do this if you are not registered. You can download a "shipped" version (9.2.0.4comes to mind) from OTN for free, but not the latest patchset, to the best of my knowledge.
Once you obtain the patch, you can apply just the one, as they are cumulative. However, if for some reason you cross a word boundary (ie, going from 9.2.0.1 32-bit to 9.2.0.8 64-bit), you have to jump the hoop of an intermediate patchset.
HTH,
Hii Following is the my database version information. select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for Solaris: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production
I want to know which patch is need to be installed and what is the latest patch available. And Please guide me how to download it from metalink means for that any registration is needed? Download of patch is free? I can directly install latest patch ot I have to install all patches?
------------------------------ Get your email and more, right on the new Yahoo.com<http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview>
-- Charles Schultz