Counting Size of Oracle Process

Page moved to ,

http://sysdbaonline.com/?p=152

Oracdebug ( Undocumented Utility )

Oradebug utility is very  useful for all the DBA.

Oradebug is mainly useful in case of hang analysis , tracing perticular process etc.With oradebug you can litteraly see the database engine.

Understanding the trace file generated by oradebug requires lots of expertise.

Among the many useful things that can be done with oradebug are:
- enabling/disabling the SQL tracing for another user’s session.
- suspending intensive processes
- finding information about shared memory and semaphores
- closing the trace file so that new one can be generated
- manipulating and dumping internal structures
- wake up processes etc.
Examples:

• Oradebug setospid

Get the OS PID from spid column of v$process and set oradebug on it.

SQL> select program,spid from v$process;

PROGRAM                                          SPID
———————————————— ————
PSEUDO
oracle@quartz (PMON)                         4106
oracle@quartz (PSP0)                           4108
oracle@quartz (MMAN)                         4110

SQL> oradebug setospid 4106
Oracle pid: 2, Unix process pid: 4106, image: oracle@quartz (PMON)
SQL> oradebug unlimit;
Statement processed.
SQL> oradebug procstat
Statement processed.
SQL> oradebug tracefile_name
/u01/app/oracle/product/10.2.0/db_1/admin/dev/bdump/dev_pmon_4106.trc

• oradebug setorapid

Dump statistics for the DBWR background process:

SQL> select pid,name from v$process p, v$bgprocess b where b.paddr = p.addr;

PID NAME
———- —–
2 PMON
3 PSP0
4 MMAN
5 DBW0
6 LGWR
7 CKPT
8 SMON
9 RECO
10 CJQ0
11 MMON
12 MMNL

PID NAME
———- —–
16 ARC0
17 ARC1
18 ARC2
21 QMNC

15 rows selected.

SQL> oradebug setorapid 5
Unix process pid: 4112, image: oracle@quartz (DBW0)

SQL> oradebug procstat
Statement processed.

SQL> oradebug tracefile_name
/u01/app/oracle/product/10.2.0/db_1/admin/dev/bdump/dev_dbw0_4112.trc

• oradebug dump systemstate

SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug setinst all
Statement processed.
SQL> oradebug dump systemstate 10;
Statement processed.
SQL> oradebug tracefile_name
/u01/app/oracle/product/10.2.0/db_1/admin/dev/udump/dev_ora_557.trc

• oradebug dump processstate

SQL> oradebug setmypid
Statement processed.

SQL> oradebug unlimit

Statement processed.

SQL> oradebug dump PROCESSSTATE 10;
Statement processed.
SQL> oradebug tracefile_name
/u01/app/oracle/product/10.2.0/db_1/admin/dev/udump/dev_ora_1079.trc

• oradebug dump errorstack

Dump of the process call stack and other information.

SQL> oradebug setospid 13446
Oracle pid: 12, Unix process pid: 13446, image: oracle@apollo (TNS V1-V3)
SQL> oradebug unlimit
Statement processed.
SQL> oradebug dump errorstack 3
Statement processed.

• oradebug dump controlf

The contents of the current controlfile can be dumped in text form to a process trace file in the
user_dump_dest directory using the CONTROLF dump.

SQL> oradebug setospid 19272
Oracle pid: 26, Unix process pid: 19272, image: oracle@tomcat (TNS V1-V3)
SQL> oradebug dump controlf 4
Statement processed.

• oradebug dump file_hdrs

To dump one or more blocks:
alter system dump datafile <file_number> block min <first block > block max <last block >;
Example
select segment_name, header_file, header_block from dba_segments
where segment_type=’ROLLBACK’;
SEGMENT_NAME HEADER_FILE HEADER_BLOCK
————— ———– ————
SYSTEM                             1     2
RBS0                                     2    2
RBS1                                     2 3202
RBS2                                     2 6402

• oradebug dump heapdump

SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug dump heapdump 2
Statement processed.

—————— part of the trace file       ——————–
*** SESSION ID:(7.14111) 2003-09-03 13:01:21.412
******************************************************
HEAP DUMP heap name=”sga heap” desc=0×80000030
extent sz=0xfc4 alt=48 het=32767 rec=9 flg=2 opc=0
parent=0 owner=0 nex=0 xsz=0×3d2bdf4
EXTENT 0
Chunk b5815ff8 sz= 41699524 perm                “perm          ” alo=19395672
Chunk b7fda8bc sz= 887380 free               “           “
Chunk b80b3310 sz= 560 freeable “library cache ” ds=b80b5a0c
Chunk b80b3540 sz= 2588 freeable “sql area                     ” ds=b80b5898
Chunk b80b3f5c sz= 732 freeable “sql area                      ” ds=b80ba69c
Open the trace file and look for the ds (descriptor address).Convert hex to decimal and do the
dump.
SQL> oradebug dump heapdump_addr 1 3087751692
————————— part of the trace file generated using command above ————-
Statement processed.
*** 2003-09-03 13:12:35.330
*** SESSION ID:(8.20679) 2003-09-03 13:12:35.322
HEAP DUMP heap name=”library cache” desc=0xb80b5a0c
extent sz=0×224 alt=32767 het=8 rec=9 flg=2 opc=0
parent=80000030 owner=b80b5804 nex=0 xsz=0×224
EXTENT 0
Chunk b80b3324 sz= 464 perm                  “perm          ” alo=176
Chunk b80b34f4 sz=           76 freeable “kgltbtab          “
EXTENT 1
Chunk b80b55b4 sz= 500 perm                  “perm          ” alo=500
Chunk b80b57a8 sz=           40 free       “           “
EXTENT 2
Chunk b80b57f4 sz= 244 perm                  “perm          ” alo=244
Chunk b80b58e8 sz=           52 free       “           “
Chunk b80b591c sz=           76 freeable “kgltbtab           “
Chunk b80b5968 sz=            76 freeable “kgltbtab          “

Applying CPU JUL 2008 on RAC ( 11.1.0.6 ) ORACLE_HOME

• First you need to have OPatch 11.1.0.6.2 or higher to apply the CPU JUL 2008.You can download OPatch 11.1.0.6.3 from Patch 6880880.

[oracle@quartz Desktop]$ unzip p6880880_111000_Linux-x86-64.zip
Archive: p6880880_111000_Linux-x86-64.zip
creating: OPatch/
creating: OPatch/docs/
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
extracting: OPatch/docs/tmp
creating: OPatch/jlib/
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/jlib/opatchactions.jar
creating: OPatch/opatchprereqs/
creating: OPatch/opatchprereqs/opatch/
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
creating: OPatch/opatchprereqs/oui/
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
inflating: OPatch/opatch.pl
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/README.txt
creating: OPatch/ocm/
extracting: OPatch/ocm/ocm.zip
creating: OPatch/ocm/doc/
inflating: OPatch/ocm/doc/license.txt
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/emocmutl.jar
creating: OPatch/ocm/bin/
inflating: OPatch/ocm/bin/emocmrsp

• Remove the Old Opatch from $ORACLE_HOME

[oracle@quartz Desktop]$ rm -rf /u01/app/oracle/product/11.1.0/db_2/OPatch/

• Move new OPatch to $ORACLE_HOME

[oracle@quartz Desktop]$ mv OPatch/ $ORACLE_HOME

• Check the OPatch version

[oracle@quartz Desktop]$ /u01/app/oracle/product/11.1.0/db_2/OPatch/opatch version
Invoking OPatch 11.1.0.6.3

OPatch Version: 11.1.0.6.3

OPatch succeeded.

• Check the State of Resources

[oracle@quartz Desktop]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
———————————————————————-
ora….TZ.lsnr application 0/5 0/0 ONLINE ONLINE quartz
ora.quartz.gsd application 0/5 0/0 ONLINE ONLINE quartz
ora.quartz.ons application 0/3 0/0 ONLINE ONLINE quartz
ora.quartz.vip application 0/0 0/0 ONLINE ONLINE quartz

• Stop all application on the node where you are going to apply Patch.

[oracle@quartz Desktop]$ srvctl stop nodeapps -n quartz

• Check once again to make sure state if off line for all resources.

[oracle@quartz Desktop]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
———————————————————————-
ora….TZ.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.quartz.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.quartz.ons application 0/3 0/0 OFFLINE OFFLINE
ora.quartz.vip application 0/0 0/0 OFFLINE OFFLINE

• Move to directory where you have unzipped CPU JUL patch and apply it.

[oracle@quartz Desktop]$ cd 7150417/

[oracle@quartz 7150417]$ /u01/app/oracle/product/11.1.0/db_2/OPatch/opatch napply -skip_subset -skip_duplicate -local
Invoking OPatch 11.1.0.6.3

Oracle Interim Patch Installer version 11.1.0.6.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.

UTIL session

Oracle Home : /u01/app/oracle/product/11.1.0/db_2
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.3
OUI version : 11.1.0.6.0
OUI location : /u01/app/oracle/product/11.1.0/db_2/oui
Log file location : /u01/app/oracle/product/11.1.0/db_2/cfgtoollogs/opatch/opatch2008-09-11_14-07-43PM.log

Invoking utility “napply”
Checking conflict among patches…
Checking if Oracle Home has components required by patches…
Skip patch 7155439 from list of patches to apply: This patch is not needed.
Checking skip_duplicate
Checking skip_subset
Checking conflicts against Oracle Home…
OPatch continues with these patches: 6650132 6650135 6731395 6871274 6871276 7150417 7155429 7155447 7155449 7155452 7155459 7155461 7155463 7155464 7158307

Do you want to proceed? [y|n]
y
User Responded with: Y

Running prerequisite checks…

You selected -local option, hence OPatch will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/oracle/product/11.1.0/db_2′)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch ‘NApply’ for restore. This might take a while…

***************************************************************************
Oracle Configuration Manager (OCM) is included with this release of OPatch.
***************************************************************************

The Oracle Configuration Manager is installed previously in the Oracle Home.

Removing previously installed Oracle Configuration Manager from the Oracle Home…
Uninstalling Oracle Configuration Manager…

OPatch will now install the Oracle Configuration Manager in the Oracle Home.

OPatch has successfully installed Oracle Configuration Manager in the Oracle Home.
Please refer log file for details.

OPatch will now configure the Oracle Configuration Manager in the Oracle Home.

Configuring Oracle Configuration Manager. This may take a while…

Oracle Configuration Manager enables Oracle to provide superior, proactive
support for our customers. Oracle strongly recommends customers configure OCM.

ORACLE CONNECTION TOOLS AGREEMENT
Introduction
————
Customer (hereafter “Customer” or “you”) agrees to the following conditions
regarding the use of Oracle’s live connection tools, including Oracle
Configuration Manager and Remote Diagnostic Agent, that you have either
downloaded from Oracle’s technical support web site or which you received from
Oracle, and the related services that Oracle provides in connection with those
tools (collectively, the “Tools”). The individual entering into this
agreement certifies that he/she has authority to enter into this agreement on
Customer’s behalf.
These terms supplement the terms of your licensing or distribution agreement
with Oracle and the terms of Oracle’s Technical Support Policies. In the
event of a conflict between your licensing or distribution agreement or the
Technical Support Policies and the following terms, the relevant terms below
will control your use of the Tools.
Description of Tools: What Data is Collected and How it is Stored and Used
————

[Press enter to continue, 'q' to stop displaying the license agreement.] q

I accept the License Agreement (Y/N) [Y]: n

OPatch failed to configure Oracle Configuration Manager in the Oracle Home. Please refer log file
for details.

*******************************************************************************************
Oracle Configuration Manager is installed but not configured. OCM enables Oracle to
provide superior, proactive support for our customers. Oracle strongly recommends customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
*******************************************************************************************

Execution of ’sh /home/oracle/Desktop/7150417/6731395/custom/scripts/pre -apply 6731395 ‘:

Return Code = 0
Execution of ’sh /home/oracle/Desktop/7150417/7150417/custom/scripts/pre -apply 7150417 ‘:

Return Code = 0

Applying patch 6650132…

ApplySession applying interim patch ‘6650132′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6650132′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kzia.o”
ApplySession adding interim patch ‘6650132′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6650132 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6650132 are present in Oracle Home.

Applying patch 6650135…

ApplySession applying interim patch ‘6650135′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6650135′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kzsr.o”
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kzu.o”
ApplySession adding interim patch ‘6650135′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6650135 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6650135 are present in Oracle Home.

Applying patch 6731395…

ApplySession applying interim patch ‘6731395′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6731395′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/view_recompile/recompile_precheck_jan2008cpu.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/view_recompile/view_recompile_jan2008cpu.sql”
ApplySession adding interim patch ‘6731395′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6731395 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6731395 are present in Oracle Home.

Applying patch 6871274…

ApplySession applying interim patch ‘6871274′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6871274′ for rollback. This might take a while…

Patching component oracle.sdo.locator, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/md/admin/prvtpidx.plb”
ApplySession adding interim patch ‘6871274′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6871274 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6871274 are present in Oracle Home.

Applying patch 6871276…

ApplySession applying interim patch ‘6871276′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6871276′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/rdbms/jlib/CDC.jar” with “/rdbms/jlib/CDC.jar/oracle/CDC/AdvanceChangeSet.class”
ApplySession adding interim patch ‘6871276′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6871276 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6871276 are present in Oracle Home.

Applying patch 7150417…

ApplySession applying interim patch ‘7150417′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7150417′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/catcpu.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/catcpu_rollback.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/rollback_all.lst”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/rollback_new.lst”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/bundledata_CPU.xml”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/catbundle.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/scripts/sdo_jul2008.sql”
ApplySession adding interim patch ‘7150417′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7150417 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7150417 are present in Oracle Home.

Applying patch 7155429…

ApplySession applying interim patch ‘7155429′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155429′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/lib/env_rdbms.mk”
ApplySession adding interim patch ‘7155429′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155429 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155429 are present in Oracle Home.

Applying patch 7155447…

ApplySession applying interim patch ‘7155447′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155447′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/prvtdefr.plb”
ApplySession adding interim patch ‘7155447′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155447 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155447 are present in Oracle Home.

Applying patch 7155449…

ApplySession applying interim patch ‘7155449′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155449′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kupp.o”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/prvtbpp.plb”
ApplySession adding interim patch ‘7155449′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155449 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155449 are present in Oracle Home.

Applying patch 7155452…

ApplySession applying interim patch ‘7155452′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155452′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/catdef.sql”
ApplySession adding interim patch ‘7155452′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155452 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155452 are present in Oracle Home.

Applying patch 7155459…

ApplySession applying interim patch ‘7155459′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155459′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/ctc.o”
ApplySession adding interim patch ‘7155459′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155459 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155459 are present in Oracle Home.

Applying patch 7155461…

ApplySession applying interim patch ‘7155461′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155461′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kwqn.o”
ApplySession adding interim patch ‘7155461′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155461 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155461 are present in Oracle Home.

Applying patch 7155463…

ApplySession applying interim patch ‘7155463′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155463′ for rollback. This might take a while…

Patching component oracle.sdo.locator, 11.1.0.6.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$AlongEdgeComparator.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$AlongSegmentComparator.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$EdgeSplit.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$Int.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$PointStackEntry.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$SmartPoint.class”
ApplySession adding interim patch ‘7155463′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155463 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155463 are present in Oracle Home.

Applying patch 7155464…

ApplySession applying interim patch ‘7155464′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155464′ for rollback. This might take a while…

Patching component oracle.sysman.plugin.db.main.oms, 11.1.0.5.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsg.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsgID.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/rsrcmgr/RsrcmgrMonController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emdb_emjsp.jar” with “/sysman/jlib/emdb_emjsp.jar/_database/_instance/_sitemap/_healthgif.class”
ApplySession adding interim patch ‘7155464′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155464 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155464 are present in Oracle Home.

Applying patch 7158307…

ApplySession applying interim patch ‘7158307′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7158307′ for rollback. This might take a while…

Patching component oracle.sysman.plugin.db.main.oms, 11.1.0.5.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/MemoryController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SessionDetailsController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SitemapController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/sesn/SessionDetails.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emdb_emjsp.jar” with “/sysman/jlib/emdb_emjsp.jar/_database/_instance/_sitemap/_health.class”
ApplySession adding interim patch ‘7158307′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7158307 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7158307 are present in Oracle Home.
Running make for target ioracle
Running make for target iextjob
Running make for target iextjobo

——————————————————————————–
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************

——————————————————————————–

Execution of ’sh /home/oracle/Desktop/7150417/7150417/custom/scripts/post -apply 7150417 ‘:

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Apply done.
——————————————————————————–
The following warnings have occurred during OPatch execution:
1) OUI-67293:
OPatch failed to configure Oracle Configuration Manager in the Oracle Home. Please refer log file
for details.

2) OUI-67294:
*******************************************************************************************
Oracle Configuration Manager is installed but not configured. OCM enables Oracle to
provide superior, proactive support for our customers. Oracle strongly recommends customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
*******************************************************************************************

——————————————————————————–
OPatch Session completed with warnings.

OPatch completed with warnings.

• Check whether patch has been applied and registered in inventory or not.

[oracle@quartz 7150417]$ /u01/app/oracle/product/11.1.0/db_2/OPatch/opatch lsinv
Invoking OPatch 11.1.0.6.3

Oracle Interim Patch Installer version 11.1.0.6.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.1.0/db_2
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.3
OUI version : 11.1.0.6.0
OUI location : /u01/app/oracle/product/11.1.0/db_2/oui
Log file location : /u01/app/oracle/product/11.1.0/db_2/cfgtoollogs/opatch/opatch2008-09-11_14-26-45PM.log

Lsinventory Output file location : /u01/app/oracle/product/11.1.0/db_2/cfgtoollogs/opatch/lsinv/lsinventory2008-09-11_14-26-45PM.txt

——————————————————————————–
Installed Top-level Products (1):

Oracle Database 11g 11.1.0.6.0
There are 1 products installed in this Oracle Home.

Interim patches (15) :

Patch 7158307 : applied on Thu Sep 11 14:15:18 BST 2008
Created on 22 Jun 2008, 01:14:25 hrs PST8PDT
Bugs fixed:
7158307

Patch 7155464 : applied on Thu Sep 11 14:14:03 BST 2008
Created on 22 Jun 2008, 01:14:05 hrs PST8PDT
Bugs fixed:
7155464

Patch 7155463 : applied on Thu Sep 11 14:13:02 BST 2008
Created on 22 Jun 2008, 01:13:43 hrs PST8PDT
Bugs fixed:
7155463

Patch 7155461 : applied on Thu Sep 11 14:12:54 BST 2008
Created on 22 Jun 2008, 01:13:22 hrs PST8PDT
Bugs fixed:
7155461

Patch 7155459 : applied on Thu Sep 11 14:12:28 BST 2008
Created on 22 Jun 2008, 01:12:56 hrs PST8PDT
Bugs fixed:
7155459

Patch 7155452 : applied on Thu Sep 11 14:12:11 BST 2008
Created on 22 Jun 2008, 01:09:57 hrs PST8PDT
Bugs fixed:
7155452

Patch 7155449 : applied on Thu Sep 11 14:12:06 BST 2008
Created on 22 Jun 2008, 01:09:32 hrs PST8PDT
Bugs fixed:
7155449

Patch 7155447 : applied on Thu Sep 11 14:11:47 BST 2008
Created on 22 Jun 2008, 01:02:51 hrs PST8PDT
Bugs fixed:
7155447

Patch 7155429 : applied on Thu Sep 11 14:11:45 BST 2008
Created on 22 Jun 2008, 00:59:22 hrs PST8PDT
Bugs fixed:
7155429

Patch 7150417 : applied on Thu Sep 11 14:11:42 BST 2008
Created on 22 Jun 2008, 00:47:12 hrs PST8PDT
Bugs fixed:
7150417

Patch 6871276 : applied on Thu Sep 11 14:11:38 BST 2008
Created on 13 Mar 2008, 23:27:15 hrs PST8PDT
Bugs fixed:
6871276

Patch 6871274 : applied on Thu Sep 11 14:11:34 BST 2008
Created on 13 Mar 2008, 23:26:15 hrs PST8PDT
Bugs fixed:
6871274

Patch 6731395 : applied on Thu Sep 11 14:11:31 BST 2008
Created on 14 Mar 2008, 00:12:44 hrs PST8PDT
Bugs fixed:
6731395

Patch 6650135 : applied on Thu Sep 11 14:11:25 BST 2008
Created on 13 Mar 2008, 23:58:36 hrs PST8PDT
Bugs fixed:
6650135

Patch 6650132 : applied on Thu Sep 11 14:10:37 BST 2008
Created on 14 Mar 2008, 00:00:24 hrs PST8PDT
Bugs fixed:
6650132

——————————————————————————–

OPatch succeeded.

This article only explains about the how to patch Oracle Home and if you have DB also created then you need to follow post installation steps as per readme.