Thanks all for the response. -- I need to check for Oracle Standard Edition ONE (OSE1) not Standard Edition. -- Actually my application needs to show if the underlying DB is OSE1 and SE. Hence any command/query to get this information would be useful. -- Is there anyway that I can write some file with the Oracle Edition during installation so that my application can make use of that? Appreciate all your help !!! On 7/28/10, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: > That's because I missed an important parameter -detail eg opatch lsinv > -detail > > Niall Litchfield > > On Jul 28, 2010 3:32 PM, "Michael McMullen" <ganstadba@xxxxxxxxxxx> wrote: > > I just installed SE1 11G Release 2 and it doesn’t show up in opatch but it > was an installable option. > > > > Invoking OPatch 11.1.0.6.6 > > > > Oracle Interim Patch Installer version 11.1.0.6.6 > > Copyright (c) 2009, Oracle Corporation. All rights reserved. > > > > > > Oracle Home : /oracle/app/oracle/product/11.2.0/dbhome_1 > > Central Inventory : /oracle/app/oraInventory > > from : /etc/oraInst.loc > > OPatch version : 11.1.0.6.6 > > OUI version : 11.2.0.1.0 > > OUI location : /oracle/app/oracle/product/11.2.0/dbhome_1/oui > > Log file location : > /oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2010-07-28_10-27-16AM.log > > > > Patch history file: > /oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt > > > > Lsinventory Output file location : > /oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2010-07-28_10-27-16AM.txt > > > > -------------------------------------------------------------------------------- > > Installed Top-level Products (1): > > > > Oracle Database 11g > 11.2.0.1.0 > > There are 1 products installed in this Oracle Home. > > > > > > There are no Interim patches installed in this Oracle Home. > -- Regards, Deepak Oracle DBA -- //www.freelists.org/webpage/oracle-l