how to check a patch no.

[ayushsingh]

Hi All,

How can I check that certain patch is already applied.

Thanks all.

[Cookies]

select * from v$instance;

select * from v$version;

[patel_dil]

For some patches like 8.1.7.4.10, These Views might not be helpful.

[Cookies]

I agree with you, but unless you were the one installing the patch, there is basically no way to find out that I know of.

[patel_dil]

The closest I could think of is to compare O/S timestamp on few random files copied as part of Patch(set) installation with the ones from source Patchset directory and readme file. Like Oracle.exe, sqlplus exe, nlsdata directory, etc.

[pando]

in unix you can use owhat which does not always work heh, but there are other tricks in unix, you need to look on

http://metalink.oracle.com/metalink/...T&p_id=69118.1

or simply run Universal Installer which tells you what has been installed, or look oraInventory but for patches like replacing a .so your best bet is follow that paper or simply compare the .so file (which are usually small!)

[clio_usa]

I agree.

$ORACLE_BASE\OraInventory\Components\ will have a sub-directory for each installed component. In each subdirectory you will see directory with the exact version - 8.1.7.4.0 (for example)


Hope that helps,

clio_usa

OCP 8/8i/9i DBA

[Cookies]

Originally posted by clio_usa
I agree.

$ORACLE_BASE\OraInventory\Components\ will have a sub-directory for each installed component. In each subdirectory you will see directory with the exact version - 8.1.7.4.0 (for example)


Hope that helps,

clio_usa

OCP 8/8i/9i DBA

I am assuming you are referring to Unix only.
in Win NT/2000 there is no such directory.

[patel_dil]

Originally posted by Cookies
I am assuming you are referring to Unix only.
in Win NT/2000 there is no such directory.

There is "\Oracle\Inventory\components\" which is same as its unix counterpart. In Windows you can generally find that under your 'Program Files' Directory. Even then these are not of full help.

Thanks

[denevge]

On 9iR2, if you want to apply patches ( except those you do using the installer ) you have to install a little perl-script called opatch. ( downloadable from metalink, do a search on 'opatch' )

You use this script to apply a patch.

If you want to see which patches have been applied, you can use
'opatch lsinventory'.

HTH
Gert