General
cancel
Showing results for 
Search instead for 
Did you mean: 

how to check oracle database patch level

SOLVED
Go to solution
malay boy
Trusted Contributor

how to check oracle database patch level

Hi guy's,
How to check what patch have been apply to oracle database?.

regards
mB
There are three person in my team-Me ,myself and I.
5 REPLIES
Massimo Bianchi
Honored Contributor

Re: how to check oracle database patch level

Hi,
for the latest patch set, simply do a

select version from v$instance;

it will tell you major and pathset level.

Or you can start the runInstaller, but it's much more lengthy..


Unfortunatly I do not know how to find out if specifyc bugs are applied.....


Massimo


T G Manikandan
Honored Contributor

Re: how to check oracle database patch level

select * from v$version should give you the result

if it is 8.1.7.4.0

here

8.1.7 -->Release level
4.0--->PSR(patch set release)

Thanks
twang
Honored Contributor

Re: how to check oracle database patch level

select * from v$version;

BANNER
--------------------------------------------------------------------------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

5 rows selected.
Indira Aramandla
Honored Contributor

Re: how to check oracle database patch level

Hi,

You can select from the view v$version or from the table props$. The column NLS_RDBMS_VERSION in PROPS$ table will provide the version along with the patch set applied number.
Never give up, Keep Trying
R. Allan Hicks
Trusted Contributor
Solution

Re: how to check oracle database patch level

My personal favorite is rda. The script from metalink gives you html pages of just about anything you'd care to know about your system.

See doc id 139597.1 for info.
"Only he who attempts the absurd is capable of achieving the impossible