-
How do I find out if a patch has been applied, and if so, the version of the patch?
J.T.
-
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;
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
So if you reapply the same patch again unknowingly, would that be a problem?
J.T.
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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
Last edited by yls177; 07-22-2005 at 04:40 AM.
-
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...
Last edited by TimHall; 07-22-2005 at 08:32 AM.
-
Originally Posted by 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...
AFAIK it's there from 9i onwards.
Amar
"There is a difference between knowing the path and walking the path."
-
Originally Posted by adewri
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|