how to check a patch no.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: how to check a patch no.

  1. #1
    Join Date
    Dec 2002
    Posts
    62

    how to check a patch no.

    Hi All,

    How can I check that certain patch is already applied.

    Thanks all.

  2. #2
    Join Date
    Oct 2002
    Posts
    182
    select * from v$instance;

    select * from v$version;
    - Cookies

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    For some patches like 8.1.7.4.10, These Views might not be helpful.
    -- Dilip

  4. #4
    Join Date
    Oct 2002
    Posts
    182
    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.
    - Cookies

  5. #5
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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.
    -- Dilip

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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!)

  7. #7
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Thumbs up

    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

  8. #8
    Join Date
    Oct 2002
    Posts
    182
    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.
    - Cookies

  9. #9
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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
    -- Dilip

  10. #10
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width