This discussion is archived
8 Replies Latest reply: Apr 21, 2013 11:20 PM by User477708-OC RSS

OPatch Utility ls inventory workaround

1004067 Newbie
Currently Being Moderated
Hello There,

IS there a way to get the lsinventory without using the opatch command. I want to do this i, order to the get patch level installed on the DB server without using DB account/group. I am trying to get this working on 9i 10g and 11g. Any help or hint shall be highly appreciated.
  • 1. Re: OPatch Utility ls inventory workaround
    sb92075 Guru
    Currently Being Moderated
    1001064 wrote:
    Hello There,

    IS there a way to get the lsinventory without using the opatch command. I want to do this i, order to the get patch level installed on the DB server without using DB account/group. I am trying to get this working on 9i 10g and 11g. Any help or hint shall be highly appreciated.
    & must solution be OS independent & work on both Windows & *NIX?                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
  • 2. Re: OPatch Utility ls inventory workaround
    1004067 Newbie
    Currently Being Moderated
    Oops forget to mention the OS. I looking for it to work on *nix platform.                                                                                                                                                                                       
  • 3. Re: OPatch Utility ls inventory workaround
    EdStevens Guru
    Currently Being Moderated
    1001064 wrote:
    Hello There,

    IS there a way to get the lsinventory without using the opatch command. I want to do this i, order to the get patch level installed on the DB server without using DB account/group. I am trying to get this working on 9i 10g and 11g. Any help or hint shall be highly appreciated.
    Please explain why you want to do DBA work without using DB account/group
  • 4. Re: OPatch Utility ls inventory workaround
    User477708-OC Journeyer
    Currently Being Moderated
    you can get some database info from the registry

    SELECT * FROM sys.registry$history

    but this wont include any bug releases or OS patches. Id go with earlier, why do you not want to use opatch?
  • 5. Re: OPatch Utility ls inventory workaround
    user62721 Newbie
    Currently Being Moderated
    hi
    sql> oradebug patch list 
    regards
  • 6. Re: OPatch Utility ls inventory workaround
    User477708-OC Journeyer
    Currently Being Moderated
    user12045475 wrote:
    hi
    sql> oradebug patch list 
    regards
    And that gives you what?

    SQL> oradebug patch list
    
    Patch File Name                                   State
    ================                                =========
    No patches currently installed
    
    SQL> host opatch lsinventory
    Invoking OPatch 11.2.0.1.6
    
    Oracle Interim Patch Installer version 11.2.0.1.6
    Copyright (c) 2011, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home       : /u01/oracle/product/11.2.0/db_2
    Central Inventory : /u01/oraInventory
       from           : /etc/oraInst.loc
    OPatch version    : 11.2.0.1.6
    OUI version       : 11.2.0.2.0
    Log file location : /u01/oracle/product/11.2.0/db_2/cfgtoollogs/opatch/opatch2013-04-19_13-16-56PM.log
    
    Lsinventory Output file location : /u01/oracle/product/11.2.0/db_2/cfgtoollogs/opatch/lsinv/lsinventory2013-04-19_13-16-56PM.txt
    
    --------------------------------------------------------------------------------
    Installed Top-level Products (1): 
    
    Oracle Database 11g                                                  11.2.0.2.0
    There are 1 products installed in this Oracle Home.
    
    
    Interim patches (4) :
    
    Patch  11815753     : applied on Fri Sep 16 13:12:56 IST 2011
    Unique Patch ID:  13616542
       Created on 1 Apr 2011, 03:33:21 hrs PST8PDT
       Bugs fixed:
         11815753
    
    Patch  10636231     : applied on Fri Sep 16 13:10:58 IST 2011
    Unique Patch ID:  13866956
       Created on 22 Jun 2011, 09:36:12 hrs PST8PDT
       Bugs fixed:
         10636231
       This patch overlays patches:
         11724916
       This patch needs patches:
         11724916
       as prerequisites
    
    Patch  12431716     : applied on Fri Sep 16 13:10:17 IST 2011
    Unique Patch ID:  13720930
       Created on 5 May 2011, 21:52:04 hrs PST8PDT
       Bugs fixed:
         12431716
       This patch overlays patches:
         11724916
       This patch needs patches:
         11724916
       as prerequisites
    
    Patch  11724916     : applied on Fri Sep 16 13:09:12 IST 2011
    Unique Patch ID:  13739423
       Created on 1 Apr 2011, 07:09:05 hrs PST8PDT
       Bugs fixed:
         10151017, 10158965, 11724916, 10190642, 10129643, 10018789, 9744252
         10248523, 9956713, 10356513, 9715581, 9770451, 10170431, 10425676
         10222719, 9591812, 10127360, 10094201, 11069199, 10245086, 10205230
         10052141, 11818335, 11830776, 11830777, 9905049, 11830778, 10077191
         10358019, 10219576, 10264680, 10209232, 10102506, 11067567, 9881076
         10040531, 10218814, 9788588, 9735237, 10230571, 10079168, 10228151
         10013431, 10217802, 10238786, 10052956, 11699057, 10080579, 10332111
         10227288, 10329146, 10332589, 10110863, 10073683, 10019218, 10229719
         10373381, 11724984, 9539440, 10411618, 10022980, 10187168, 6523037
         9724970, 10084145, 10157402, 9651350, 10299224
    
    
    
    --------------------------------------------------------------------------------
    
    OPatch succeeded.
    
    SQL> 
  • 7. Re: OPatch Utility ls inventory workaround
    1004067 Newbie
    Currently Being Moderated
    Hello All,
    Thanks for the help. The user does not belong the DBA group so it cannot access database. Any log or file where I can get this information.
  • 8. Re: OPatch Utility ls inventory workaround
    User477708-OC Journeyer
    Currently Being Moderated
    1001064 wrote:
    Hello All,
    Thanks for the help. The user does not belong the DBA group so it cannot access database. Any log or file where I can get this information.
    Have to ask for what business purpose a non-oracle user has looking for lsinventory? youre either a DBA or not, if youre not, can you ask the DBA?

    If you are the DBA and dont have the correct oracle permissions, speak to your systems and get them.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points