topic Re: how to check oracle database patch level in Operating System - HP-UX

how to check oracle database patch level

malay boy — Wed, 03 Sep 2003 05:51:24 GMT

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

regards
mB

Re: how to check oracle database patch level

Massimo Bianchi — Wed, 03 Sep 2003 05:58:41 GMT

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

Re: how to check oracle database patch level

T G Manikandan — Wed, 03 Sep 2003 06:33:00 GMT

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

Re: how to check oracle database patch level

twang — Wed, 03 Sep 2003 06:42:51 GMT

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.

Re: how to check oracle database patch level

Indira Aramandla — Thu, 04 Sep 2003 05:13:25 GMT

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.

Re: how to check oracle database patch level

R. Allan Hicks — Thu, 04 Sep 2003 11:18:18 GMT

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.