What's the command to find out patch version?

[jt]

How do I find out if a patch has been applied, and if so, the version of the patch?

[gandolf989]

You can try this in 8i:

FUNCTION DbReleaseNumber RETURN VARCHAR2 IS
VersionNumber VARCHAR2(20);
Compatibility VARCHAR2(20);
BEGIN
DBMS_UTILITY.Db_Version( VersionNumber, Compatibility);
RETURN VersionNumber;
EXCEPTION
WHEN OTHERS THEN
return(NULL);
END;

[jmodic]

Note that not all patches leave their "footprint" in the versionnumber. For example, if you apply patch 8.1.7.1.2 to your database (after you have applied 8.1.7.1.1), you will still see 8.1.7.1.1 as your release everywhere.

[jt]

So if you reapply the same patch again unknowingly, would that be a problem?

[sambavan]

To get this information you can check the oraInventory/Patches this would reveal you the patches that you have applied so far on to the database.

Sam

[jmodic]

Originally posted by sambavan
To get this information you can check the oraInventory/Patches this would reveal you the patches that you have applied so far on to the database.

I stress again: this is true only if the pach has been applied through Universal Installer.

But some "minor" patches can not be applied like this - for them to be "installed" you simply has to copy bunch of exec and library files over the old ones. To keep track of such paches installed there is no other way than to have a good memory or good "document everything" habit.

And to answer jt: I don't think there would be a problem to reapply same patch again, unless it is lower than the highest patch allready applied. If the patch has to be installed by Oracle Universal Installer then the Installer will complain anyway.

[yls177]

okay.. so there is no way to see which patch has been applied since there are other workarounds.....

for example, all_dba_links will show u all the dba_links. i was wondering whether there are similar ones for patches?

opatcah isinventory will work for oracle 8.1.7.4

Thanks

[TimHall]

Is this available in 8i?

select comp_name, version, status from dba_registry;

Can't test at the moment, but it works in 9i and 10g for patches that update the data

Cheers

Tim...

[adewri]

Is this available in 8i?

select comp_name, version, status from dba_registry;

Can't test at the moment, but it works in 9i and 10g for patches that update the data

Cheers

Tim...

AFAIK it's there from 9i onwards.

[TimHall]

AFAIK it's there from 9i onwards.

I thought you were insulting me for a minute, then I looked up AFAIK on google and all was revealed

Cheers

Tim...