Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

Wednesday, January 13, 2010

OPatch lsinventory

Ensure that you are able to invoke the opatch lsinventory -detail command and are able to see the node information being printed out. A sample listing of the output of the command is as follows:

Oracle interim Patch Installer version 10.2.0.4.6
Copyright (c) 2009, Oracle Corporation. All rights reserved..
Oracle Home : /home/racqa/102_twork/toii/toiir/toiir571/HOMEtoiir571
Central Inventory : /home/racqa/102_twork/toii/toiir/toiir571/inventory
from : /home/racqa/102_
twork/toii/toiir/toiir571/HOMEtoiir571/oraInst.loc
OPatch version : 10.2.0.4.6
OUI version : 10.2.0.4.6
OUI location : /home/racqa/102_twork/toii/toiir/toiir571/HOMEtoiir571/oui
Log file location : /home/racqa/102_
twork/toii/toiir/toiir571/HOMEtoiir571/cfgtoollogs/opatch/opatch-2008_May_30_
01-04-52-PDT_Mon.log
Lsinventory Output file location : /home1/racqa/102_
twork/toii/toiir/toiir571/HOMEtoiir571/cfgtoollogs/opatch/lsinv/lsinventory-2008_
May_30_01-04-52-PDT_Mon.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 10g 10.2.0.4.6
There are 1 products installed in this Oracle Home.
Installed Products (151):
Advanced Queueing (AQ) API 10.2.0.4.6
Advanced Replication 10.2.0.4.6
Agent Required Support Files 10.2.0.4.6
Assistant Common Files 10.2.0.4.6
Authentication and Encryption 10.2.0.4.6
Bali Share 1.1.18.0.0
Character Set Migration Utility 10.2.0.4.6
CSS Single-instance Common Files 10.2.0.4.6
Data Management Services Common Files 10.2.0.4.6
Database Configuration Assistant 10.2.0.4.6
Database SQL Scripts 10.2.0.4.6
Database Upgrade Assistant 10.2.0.4.6
Database Verify Utility 10.2.0.4.6
Database Workspace Manager 10.2.0.4.6
DBJAVA Required Support Files 10.2.0.4.6
Documentation Required Support Files 10.2.0.4.6
Enterprise Edition Options 10.2.0.4.6
Enterprise Manager Agent 10.2.0.4.6
Enterprise Manager Common Files 10.2.0.4.6
Enterprise Manager Minimal Integration 10.2.0.4.6
Enterprise Manager plugin Common Files 10.2.0.4.6
Enterprise Manager Repository 10.2.0.4.6
Export/Import 10.2.0.4.6
Extended Windowing Toolkit 3.3.18.0.0
Generic Connectivity Common Files 10.2.0.4.6
Generic Connectivity Using ODBC 10.2.0.4.6
Installation Common Files 10.2.0.4.6
Installer SDK Component 10.2.0.1.0
iSQL*Plus 10.2.0.4.6
Java Naming and Directory Interface Libraries 10.2.0.4.6
Java Runtime Environment 1.4.2.0.0
JDBC Common Files 10.2.0.4.6
JDBC/OCI Common Files 10.2.0.4.6
JDBC/OCI Common Files for Instant Client 10.2.0.4.6
LDAP Required Support Files 10.2.0.4.6
New Database ID 10.2.0.4.6
Object Type Translator 10.2.0.4.6
Oracle Advanced Security 10.2.0.4.6
Oracle C++ Call Interface 10.2.0.4.6
Oracle C++ Call Interface for Instant Client 10.2.0.4.6
Oracle Call Interface (OCI) 10.2.0.4.6
Oracle Client Required Support Files 10.2.0.4.6
Oracle Code Editor 1.2.1.0.0I
Oracle Containers for Java 10.2.0.4.6
Oracle Core Required Support Files 10.2.0.4.6
Oracle Data Mining 10.2.0.4.6
Oracle Database 10g 10.2.0.4.6
Oracle Database 10g 10.2.0.4.6
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 10.2.0.4.6
Oracle Development Kit 10.2.0.4.6
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager 10g Database Control 10.2.0.4.6
Oracle Enterprise Manager Console DB 10.2.0.4.6
Oracle Extended Windowing Toolkit 3.4.28.0.0
Oracle Globalization Support 10.2.0.4.6
Oracle Help For Java 4.2.5.0.0a
Oracle Help for the Web 1.1.7.0.0a
Oracle Ice Browser 5.2.3.3.0
Oracle interMedia 10.2.0.4.6
Oracle interMedia Annotator 10.2.0.4.6
Oracle interMedia Audio 10.2.0.4.6
Oracle interMedia Client Compatibility Files 10.2.0.4.6
Oracle interMedia Client Demos 10.2.0.4.6
Oracle interMedia Client Option 10.2.0.4.6
Oracle interMedia Common Files 10.2.0.4.6
Oracle interMedia Image 10.2.0.4.6
Oracle interMedia Java Advanced Imaging 10.2.0.4.6
Oracle interMedia Java Client 10.2.0.4.6
Oracle interMedia Locator 10.2.0.4.6
Oracle interMedia Video 10.2.0.4.6
Oracle interMedia Web Client 10.2.0.4.6
Oracle Internet Directory Client 10.2.0.4.6
Oracle Internet Directory Client Common Files 10.2.0.4.6
Oracle Internet Directory Tools 10.2.0.4.6
Oracle Java Tools 10.2.0.4.6
Oracle JDBC Thin Driver for JDK 1.2 10.2.0.4.6
Oracle JDBC Thin Driver for JDK 1.4 10.2.0.4.6
Oracle JDBC Thin Driver for JDK 1.4 for Instant Client 10.2.0.4.6
Oracle JDBC/OCI Driver for JDK 1.4 10.2.0.4.6
Oracle JFC Extended Windowing Toolkit 4.2.18.0.0
Oracle JVM 10.2.0.4.6
Oracle Locale Builder 10.2.0.4.6
Oracle Message Gateway Common Files 10.2.0.4.6
Oracle Net 10.2.0.4.6
Oracle Net Configuration Assistant 10.2.0.4.6
Oracle Net Listener 10.2.0.4.6
Oracle Net Manager 10.2.0.4.6
Oracle Net Required Support Files 10.2.0.4.6
Oracle Net Services 10.2.0.4.6
Oracle Notification Service 9.0.4.0.0
Oracle OLAP 10.2.0.4.6
Oracle OLAP API 10.2.0.4.6
Oracle OLAP Catalog 10.2.0.4.6
Oracle One-Off Patch Installer 10.2.0.1.0
Oracle Partitioning 10.2.0.4.6
Oracle Programmer 10.2.0.4.6
Oracle RAC Required Support Files 10.2.0.4.6
Oracle RAC Required Support Files-HAS 10.2.0.4.6
Oracle Real Application Clusters 10.2.0.4.6
Oracle Spatial 10.2.0.4.6
Oracle Starter Database 10.2.0.4.6
Oracle Text 10.2.0.4.6
Oracle UIX 2.1.21.0.0a
Oracle Ultra Search Common Files 10.2.0.4.6
Oracle Ultra Search Middle-Tier 10.2.0.4.6
Oracle Ultra Search Server 10.2.0.4.6
Oracle Universal Installer 10.2.0.1.0
Oracle Wallet Manager 10.2.0.4.6
Oracle XML Developer's Kit 10.2.0.4.6
Oracle XML Runtime Components 10.2.0.4.6
Oracle XML SQL Utility 10.2.0.4.6
Oracle10g Real Application Clusters Common Files 10.2.0.4.6
Parser Generator Required Support Files 10.2.0.4.6
Perl Interpreter 5.6.1.0.2d
PL/SQL 10.2.0.4.6
PL/SQL Embedded Gateway 10.2.0.4.6
PL/SQL Required Support Files 10.2.0.4.6
Platform Required Support Files 10.2.0.4.6
Precompiler Common Files 10.2.0.4.6
Precompiler Required Support Files 10.2.0.4.6
Pro*C/C++ 10.2.0.4.6
RDBMS Required Support Files 10.2.0.4.6
Recovery Manager 10.2.0.4.6
regexp 2.1.9.0.0
Required Support Files 10.2.0.4.6
Sample Schema 10.2.0.4.6
Secure Socket Layer 10.2.0.4.6
Secure Socket Layer 10.2.0.4.6
SQL*Loader 10.2.0.4.6
SQL*Plus 10.2.0.4.6
SQL*Plus Required Support Files 10.2.0.4.6
SQLJ Runtime 10.2.0.4.6
SSL Required Support Files 10.2.0.4.6
SSL Required Support Files for InstantClient 10.2.0.4.6
Sun JDK 1.4.2.0.0
Sun JDK extensions 9.0.4.0.0
Utilities Common Files 10.2.0.4.6
Visigenics ORB 3.4.0.0.0
XDK Required Support Files 10.2.0.4.6
XML 10.2.0.4.6
XML Class Generator for C++ 10.2.0.4.6
XML Class Generator for Java 10.2.0.4.6
XML Parser for C 10.2.0.4.6
XML Parser for C++ 10.2.0.4.6
XML Parser for Java 10.2.0.4.6
XML Parser for Oracle JVM 10.2.0.4.6
XML Parser for PL/SQL 10.2.0.4.6
XML Transviewer Beans 10.2.0.4.6
XML Transx 10.2.0.4.6
XSQL Servlet 10.2.0.4.6
There are 151 products installed in this Oracle Home.
Intermin patches (1) :
Patch 3811942 : applied on Mon May 30 00:59:33 PDT 2008
Created on 31 Aug 2007, 12:06:28 hrs US/Pacific
Bugs fixed:
3811942
Files Touched:
/hosp.o --> ORACLE_HOME/lib/libagent10.a
/pesblt.o --> ORACLE_HOME/lib/libpls10.a
/kgl.o --> ORACLE_HOME/lib/libgeneric10.a
/qcpi6.o --> ORACLE_HOME/lib/libgeneric10.a
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/iextjob
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/iextjobo
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/client_sharedlib
/hosp.o --> ORACLE_HOME/lib/libserver10.a
/prse.o --> ORACLE_HOME/lib/libserver10.a
/prsa.o --> ORACLE_HOME/lib/libserver10.a
/prsf.o --> ORACLE_HOME/lib/libserver10.a
/prssz.o --> ORACLE_HOME/lib/libserver10.a
/kprc.o --> ORACLE_HOME/lib/libserver10.a
/qmhdr.o --> ORACLE_HOME/lib/libserver10.a
/pesblt.o --> ORACLE_HOME/lib/libpls10.a
/qcpi6.o --> ORACLE_HOME/lib/libgeneric10.a
prvtpexp.plb --> ORACLE_HOME/rdbms/admin/prvtpexp.plb
sjsex.o --> ORACLE_HOME/rdbms/lib/sjsex.o
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/iextjob
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/iextjobo
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/ioracle
ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/client_sharedlib
driload.pkh --> ORACLE_HOME/ctx/admin/driload.pkh
/oracle/sysman/assistants/util/em/EMConfigStep.class --> ORACLE_
HOME/assistants/jlib/assistantsCommon.jar
/oracle/sysman/assistants/util/sqlEngine/SQLEngine.class --> ORACLE_
HOME/assistants/jlib/assistantsCommon.jar
/oracle/sysman/assistants/dbca/backend/DBEntryStep.class --> ORACLE_
HOME/assistants/dbca/jlib/dbca.jar
/oracle/sysman/assistants/dbca/backend/EMConfigStep.class --> ORACLE_
HOME/assistants/dbca/jlib/dbca.jar
/oracle/sysman/assistants/dbca/backend/PostDBCreationStep.class --> ORACLE_
HOME/assistants/dbca/jlib/dbca.jar
/oracle/sysman/emcp/EMConfig.class --> ORACLE_HOME/jlib/emca.jar
/oracle/sysman/emcp/IEMCAConstants.class --> ORACLE_HOME/jlib/emca.jar
/oracle/sysman/emcp/EMConfig.class --> ORACLE_HOME/sysman/jlib/emCORE.jar
/oracle/sysman/emcp/IEMCAConstants.class --> ORACLE_
HOME/sysman/jlib/emCORE.jar
/oracle/sysman/emSDK/conf/ConfigManager.class --> ORACLE_
HOME/sysman/jlib/emCORE.jar
/oracle/sysman/emSDK/eml/EmlConstants.class --> ORACLE_
HOME/sysman/jlib/emCORE.jar
/oracle/sysman/util/pref/PrefUtil.class --> ORACLE_
HOME/sysman/jlib/emCORE.jar
emctl.pl --> ORACLE_HOME/emdw/bin/emctl.pl
/ncrfipm.o --> ORACLE_HOME/lib/libnro10.a
libsqlplus.a --> ORACLE_HOME/lib/libsqlplus.a
libsqlplus.so --> ORACLE_HOME/lib/libsqlplus.so
libisqlplus.a --> ORACLE_HOME/lib/libisqlplus.a
libisqlplus.so --> ORACLE_HOME/lib/libisqlplus.so
mdprivs.sql --> ORACLE_HOME/md/admin/mdprivs.sql
prvtgmd.plb --> ORACLE_HOME/md/admin/prvtgmd.plb
sdolrsmd.sql --> ORACLE_HOME/md/admin/sdolrsmd.sql
prvtccbk.plb --> ORACLE_HOME/md/admin/prvtccbk.plb
wk0acl.pkh --> ORACLE_HOME/ultrasearch/admin/wk0acl.pkh
wk0acl.plb --> ORACLE_HOME/ultrasearch/admin/wk0acl.plb
wk0adm.pkh --> ORACLE_HOME/ultrasearch/admin/wk0adm.pkh
wk0adm.plb --> ORACLE_HOME/ultrasearch/admin/wk0adm.plb
wk0snapshot.plb --> ORACLE_HOME/ultrasearch/admin/wk0snapshot.plb
wk0util.pkh --> ORACLE_HOME/ultrasearch/admin/wk0util.pkh
wk0util.plb --> ORACLE_HOME/ultrasearch/admin/wk0util.plb
Patch Location in Inventory:
/home1/racqa/102_
twork/toii/toiir/toiir571/HOMEtoiir571/inventory/oneoffs/3811942
Patch Location in Storage area:
/home1/racqa/102_twork/toii/toiir/toiir571/HOMEtoiir571/.patch_
storage/3811942_Aug_31_2007_12_06_28
Rac system comprising of multiple nodes
Local node = stadu56
Remote node = stacg16
--------------------------------------------------------------------------------
OPatch succeeded.

If you do not find the node information correctly printed out, you need to update the node list. For more information on updating the node list, see the Oracle Universal Installer User's Guide.

No comments: