Oracle Tablespace Creation and Management

How To create New Oracle Tablespace

SQL>create tablespace ts_stage datafile '+NSP' size 100m;

Adding a new datafile to Oracle Tablespace 

SQL> alter tablespace ts_stage add datafile '+NSP' size 20m;

Creating Tablespace with Auto Extend On #

create tablespace ts_vmstat datafile ‘+NSP’ size 20m auto extend on;

Size of table space is automatically extended as the datafile is filled 

We cannot auto extend on for tablespace. It can occupy the size of the file system. To avoid this scenario we specify max size option while we create tablespace on database as follows 

SQL> create tablespace ts_vmdata datafile ‘+NSP’ size 100m AUTOEXTEND ON NEXT 20m MAXSIZE 200m;

When we create Tablespace, To Check Tablespace is Autoextensible ?

column tablespace_name format A20

column file_name  format A20

column bytes format A10

column autoextensible format A15

column increment_by format A15

select tablespace_name, file_name, bytes/1048576 File_Size_MB, autoextensible from dba_data_files order by file_id;

Turnning off Auto Extended for datafile # 

SQL>  alter database datafile ‘PATH’ autoextend off;

To check datafile Offline and Online Status 

column file_name format A50

column online_status format A18

select file_name,file_id,online_status from dba_data_files;

TO check datafile size 

set linesize 120

col file_name formar a80

select file_name, sum(bytes)/1024/1024 df_size from dba_data_files group by file_name;

How to Resize datafile 

SQL> alter database datafile '+NSP/oval009/datafile/ts_stage.281.912735591' resize 40m;

Query To check Free and Used Space 

SELECT /* + RULE */  df.tablespace_name "Tablespace",

       df.bytes / (1024 * 1024) "Size (MB)",

       SUM(fs.bytes) / (1024 * 1024) "Free (MB)",

       Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",

       Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"

  FROM dba_free_space fs,

       (SELECT tablespace_name,SUM(bytes) bytes

          FROM dba_data_files

         GROUP BY tablespace_name) df

 WHERE fs.tablespace_name (+)  = df.tablespace_name

 GROUP BY df.tablespace_name,df.bytes

UNION ALL

SELECT /* + RULE */ df.tablespace_name tspace,

       fs.bytes / (1024 * 1024),

       SUM(df.bytes_free) / (1024 * 1024),

       Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),

       Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)

  FROM dba_temp_files fs,

       (SELECT tablespace_name,bytes_free,bytes_used

          FROM v$temp_space_header

         GROUP BY tablespace_name,bytes_free,bytes_used) df

 WHERE fs.tablespace_name (+)  = df.tablespace_name

 GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used

 ORDER BY 4 DESC;

If you are creating files using OMF

By default the files are autoextend on 

set value for “db_create_file_dest” Parameter # 

Related Topics

Procedure to flush SQL_ID from Shared Pool : Oracle 12c 

http://www.oracleinmemory.com/2016/03/procedure-to-flush-sqlid-from-shared.html

Plan Hash Values for a Given SQLID Over Given Period & Historical Plans from the AWR 

http://www.oracleinmemory.com/2016/03/plan-hash-values-for-given-sqlid-over.html

INDEX ORGANIZED TABLES: IOT

http://www.oracleinmemory.com/2015/03/index-organized-tables-iot.html

Create IPS Package: ADRCI

http://www.oracleinmemory.com/2015/03/create-ips-package-adrci.html

DBMS_METADATA.GET_DDL To extract Index DDL

http://www.oracleinmemory.com/2015/11/dbmsmetadatagetddl-to-extract-index-ddl.html

--Nikhil Tatineni--

--Oracle Database-- 

Check Snapshots on Database

###Check Snapshots on Database #

select dhdi.instance_name,
       dhdi.db_name,
       dhs.snap_id,
       to_char(dhs.begin_interval_time,'MM/DD/YYYY:HH24:MI') begin_snap_time,
       to_char(dhs.end_interval_time,'MM/DD/YYYY:HH24:MI')   end_snap_time,
       decode(dhs.startup_time,dhs.begin_interval_time,'**db restart**',null) db_bounce
  from dba_hist_snapshot dhs,
       dba_hist_database_instance dhdi
 where dhdi.dbid             = dhs.dbid
   and dhdi.instance_number  = dhs.instance_number
   and dhdi.startup_time     = dhs.startup_time
   and dhs.end_interval_time >= to_date(sysdate - &&num_days_back)
 order by db_name, instance_name, snap_id;

---Nikhil Tatineni--

Failed with Error in invoking "mkldflags ntcontab.o nnfgt.o' of makefile '

GRID infrastructure Installation Failed with Error in invoking "mkldflags ntcontab.o nnfgt.o' of makefile '/u01/app/11.2.0/grid/network/lib/ins_net_client.mk' 

 
####
Rootcause# Ignored pre-checks for packages during installation # 

[root@tnc1 ~]#  rpm -q binutils compat-db compat-gcc compat-libstdc++-33 compat-libstdc++ glibc glibc-devel glibc-headers glibc-kernelheaders gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch --qf '%{name}-%{version}.%{arch}\n'|sort

binutils-2.20.51.0.2.x86_64

elfutils-libelf-0.161.x86_64

glibc-2.12.x86_64

glibc-devel-2.12.x86_64

glibc-headers-2.12.x86_64

libaio-0.3.107.x86_64

libaio-0.3.107.x86_64

libstdc++-4.4.7.x86_64

make-3.81.x86_64

package compat-db is not installed

package compat-gcc is not installed

package compat-libstdc++-33 is not installed

package compat-libstdc++ is not installed

package cpp is not installed

package gcc-c++ is not installed

package gcc is not installed

package glibc-kernelheaders is not installed

package ksh is not installed*

package libaio-devel is not installed

package setarch is not installed

sysstat-9.0.4.x86_64

[root@tnc1 ~]# gcc -v

-bash: gcc: command not found’

Installed all required packages using yum on nodes of the cluster # 

#yum install compat-db*

#yum install compat-gcc*

#yum install compat-libstdc++-33*

# yum install compat-libstdc++*

#yum install cpp*

#yum install gcc-c++*

#yum install gcc*

#yum install glibc-kernelheaders*

#yum install ksh

#yum install libaio-devel*

#rpm install setarch*

#yum install setarch*

[root@tnc1 stage]# gcc -v

Using built-in specs.

Target: x86_64-redhat-linux

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-bugurl=http://bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads=posix --enable-checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --enable-languages=c,c++,objc,obj-c++,java,fortran,ada --enable-java-awt=gtk --disable-dssi --with-java-home=/usr/lib/jvm/java-1.5.0-gcj-1.5.0.0/jre --enable-libgcj-multifile --enable-java-maintainer-mode --with-ecj-jar=/usr/share/java/eclipse-ecj.jar --disable-libjava-multilib --with-ppl --with-cloog --with-tune=generic --with-arch_32=i686 --build=x86_64-redhat-linux

Thread model: posix

gcc version 4.4.7 20120313 (Red Hat 4.4.7-16) (GCC) 

Resolved all Dependencies and Installed Cluster Successfully # 

--Nikhil Tatineni--

--RAC 12C -- 

How To find Master Node In RAC

We can find Master Node by querying CRSD and CSSD logs 

[root@tnc1 cssd]# pwd

/u01/app/11.2.0/grid/log/tnc1/cssd

Querying cssd logs to find Master Node information # 

[root@tnc1 cssd]# for x in `ls -tr ocssd.*`; do grep -i "master node" $x ; done | tail -1

2016-05-14 01:29:06.282: [    CSSD][4099299072]clssgmCMReconfig: reconfiguration successful, incarnation 358651350 with 2 nodes, local node number 1, master node number 1

We know that ocr is backuped by CRSD demon by master node 
query ocrconfig to find out Master Node in RAC Cluster # 

[root@tnc1 dbs]# ocrconfig -showbackup

--Nikhil Tatineni--

--RAC -- 

[INS-41112] Specified network interface doesn't maintain connectivity across cluster nodes

###Scenario ##
GRID Infrastructure Installation Failed with 
[INS-41112] Specified network interface doesn't maintain connectivity across cluster nodes



#####
Running "runcluvfy" to check node connectivity 

[oracle@tnc1 grid]$ ./runcluvfy.sh comp nodecon -n tnc1,tnc2 -verbose

Verifying node connectivity 

Checking node connectivity...

Checking hosts config file...

  Node Name                             Status                  

  ------------------------------------  ------------------------

  tnc2                                  passed                  

  tnc1                                  passed                  

Verification of the hosts config file successful

Interface information for node "tnc2"

 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 eth0   192.168.1.40    192.168.1.0     0.0.0.0         10.0.0.1        08:00:27:02:C7:6D 1500  

 eth1   10.10.10.190    10.10.10.0      0.0.0.0         10.0.0.1        08:00:27:21:C4:4E 1500  

 eth2   10.0.0.20       10.0.0.0        0.0.0.0         10.0.0.1        08:00:27:97:81:0F 1500  

Interface information for node "tnc1"

 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 eth0   192.168.1.30    192.168.1.0     0.0.0.0         10.0.0.1        08:00:27:99:B2:23 1500  

 eth1   10.10.10.180    10.10.10.0      0.0.0.0         10.0.0.1        08:00:27:72:BD:E7 1500  

 eth2   10.0.0.21       10.0.0.0        0.0.0.0         10.0.0.1        08:00:27:23:03:AA 1500  

Check: Node connectivity of subnet "192.168.1.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc2[192.168.1.40]              tnc1[192.168.1.30]              yes             

Result: Node connectivity passed for subnet "192.168.1.0" with node(s) tnc2,tnc1

Check: TCP connectivity of subnet "192.168.1.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc1:192.168.1.30               tnc2:192.168.1.40               failed          

ERROR: 

PRVF-7617 : Node connectivity between "tnc1 : 192.168.1.30" and "tnc2 : 192.168.1.40" failed

Result: TCP connectivity check failed for subnet "192.168.1.0"

Check: Node connectivity of subnet "10.10.10.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc2[10.10.10.190]              tnc1[10.10.10.180]              yes             

Result: Node connectivity passed for subnet "10.10.10.0" with node(s) tnc2,tnc1

Check: TCP connectivity of subnet "10.10.10.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc1:10.10.10.180               tnc2:10.10.10.190               failed          

ERROR: 

PRVF-7617 : Node connectivity between "tnc1 : 10.10.10.180" and "tnc2 : 10.10.10.190" failed

Result: TCP connectivity check failed for subnet "10.10.10.0"

Check: Node connectivity of subnet "10.0.0.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc2[10.0.0.20]                 tnc1[10.0.0.21]                 yes             

Result: Node connectivity passed for subnet "10.0.0.0" with node(s) tnc2,tnc1

Check: TCP connectivity of subnet "10.0.0.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc1:10.0.0.21                  tnc2:10.0.0.20                  failed          

ERROR: 

PRVF-7617 : Node connectivity between "tnc1 : 10.0.0.21" and "tnc2 : 10.0.0.20" failed

Result: TCP connectivity check failed for subnet "10.0.0.0"

Interfaces found on subnet "10.0.0.0" that are likely candidates for VIP are:

tnc2 eth2:10.0.0.20

tnc1 eth2:10.0.0.21

WARNING: 

Could not find a suitable set of interfaces for the private interconnect

Checking subnet mask consistency...

Subnet mask consistency check passed for subnet "192.168.1.0".

Subnet mask consistency check passed for subnet "10.10.10.0".

Subnet mask consistency check passed for subnet "10.0.0.0".

Subnet mask consistency check passed.

Result: Node connectivity check failed

Verification of node connectivity was unsuccessful. 

Checks did not pass for the following node(s):

tnc1

###### Work Around: ##

After alot of investigation I found, Firewall is enabled on the Node's of the cluster 

[root@tnc1 ~]# service iptables -help

Usage: iptables {start|stop|reload|restart|condrestart|status|panic|save}

[root@tnc1 ~]# service iptables status

Table: filter

Chain INPUT (policy ACCEPT)

num  target     prot opt source               destination         

1    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           state RELATED,ESTABLISHED 

2    ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0           

3    ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0           

4    ACCEPT     tcp  --  0.0.0.0/0            0.0.0.0/0           state NEW tcp dpt:22 

5    REJECT     all  --  0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited 

Chain FORWARD (policy ACCEPT)

num  target     prot opt source               destination         

1    REJECT     all  --  0.0.0.0/0            0.0.0.0/0           reject-with icmp-host-prohibited 

Chain OUTPUT (policy ACCEPT)
num  target     prot opt source               destination    

###

Disable Firewall as follows 

[root@tnc1 ~]# service iptables stop

iptables: Setting chains to policy ACCEPT: filter          [  OK  ]

iptables: Flushing firewall rules:                         [  OK  ]

iptables: Unloading modules:                               [  OK  ]

[root@tnc1 ~]# chkconfig iptables off

[root@tnc1 ~]# 

[root@tnc1 ~]# service iptables status

iptables: Firewall is not running.

###############

After ##

[oracle@tnc1 grid]$ ./runcluvfy.sh comp nodecon -n tnc1,tnc2 -verbose

Verifying node connectivity 

Checking node connectivity...

Checking hosts config file...

  Node Name                             Status                  

  ------------------------------------  ------------------------

  tnc2                                  passed                  

  tnc1                                  passed                  

Verification of the hosts config file successful

Interface information for node "tnc2"

 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 eth0   192.168.1.40    192.168.1.0     0.0.0.0         10.0.0.1        08:00:27:02:C7:6D 1500  

 eth1   10.10.10.190    10.10.10.0      0.0.0.0         10.0.0.1        08:00:27:21:C4:4E 1500  

 eth2   10.0.0.20       10.0.0.0        0.0.0.0         10.0.0.1        08:00:27:97:81:0F 1500  

Interface information for node "tnc1"

 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 eth0   192.168.1.30    192.168.1.0     0.0.0.0         10.0.0.1        08:00:27:99:B2:23 1500  

 eth1   10.10.10.180    10.10.10.0      0.0.0.0         10.0.0.1        08:00:27:72:BD:E7 1500  

 eth2   10.0.0.21       10.0.0.0        0.0.0.0         10.0.0.1        08:00:27:23:03:AA 1500  

Check: Node connectivity of subnet "192.168.1.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc2[192.168.1.40]              tnc1[192.168.1.30]              yes             

Result: Node connectivity passed for subnet "192.168.1.0" with node(s) tnc2,tnc1

Check: TCP connectivity of subnet "192.168.1.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc1:192.168.1.30               tnc2:192.168.1.40               passed          

Result: TCP connectivity check passed for subnet "192.168.1.0"

Check: Node connectivity of subnet "10.10.10.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc2[10.10.10.190]              tnc1[10.10.10.180]              yes             

Result: Node connectivity passed for subnet "10.10.10.0" with node(s) tnc2,tnc1

Check: TCP connectivity of subnet "10.10.10.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc1:10.10.10.180               tnc2:10.10.10.190               passed          

Result: TCP connectivity check passed for subnet "10.10.10.0"

Check: Node connectivity of subnet "10.0.0.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc2[10.0.0.20]                 tnc1[10.0.0.21]                 yes             

Result: Node connectivity passed for subnet "10.0.0.0" with node(s) tnc2,tnc1

Check: TCP connectivity of subnet "10.0.0.0"

  Source                          Destination                     Connected?      

  ------------------------------  ------------------------------  ----------------

  tnc1:10.0.0.21                  tnc2:10.0.0.20                  passed          

Result: TCP connectivity check passed for subnet "10.0.0.0"

Interfaces found on subnet "10.0.0.0" that are likely candidates for VIP are:

tnc2 eth2:10.0.0.20

tnc1 eth2:10.0.0.21

Interfaces found on subnet "192.168.1.0" that are likely candidates for a private interconnect are:

tnc2 eth0:192.168.1.40

tnc1 eth0:192.168.1.30

Interfaces found on subnet "10.10.10.0" that are likely candidates for a private interconnect are:

tnc2 eth1:10.10.10.190

tnc1 eth1:10.10.10.180

Checking subnet mask consistency...

Subnet mask consistency check passed for subnet "192.168.1.0".

Subnet mask consistency check passed for subnet "10.10.10.0".

Subnet mask consistency check passed for subnet "10.0.0.0".

Subnet mask consistency check passed.

Result: Node connectivity check passed

Verification of node connectivity was successful.

 ### Issue is resolved ..

..Nikhil Tatineni--

--nikhiltatineni.dba@gmail.com-- 

Command to check patches installed on all Nodes of the RAC Cluster

using opatch to check patches installed on All Nodes of the RAC Cluster #

[oracle@tnc1 ~]$ opatch lsinventory -all_nodes

Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2016, Oracle Corporation.  All rights reserved. Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.12
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-05-09_11-13-45AM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-05-09_11-13-45AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: tnc1.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Rac system comprising of multiple nodes
  Local node = tnc1
  Remote node = tnc2 Installed Patch List(s)
======================
Node Name : tnc1
----------------
Interim patches (2) :
Patch  22502549     : applied on Mon May 09 10:48:30 EDT 2016
Unique Patch ID:  19880366
Patch description:  "OCW Patch Set Update : 11.2.0.4.160419 (22502549)"
   Created on 11 Mar 2016, 01:34:41 hrs PST8PDT
   Bugs fixed:
     19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 21232394
     20365005, 17750548, 17387214, 17617807, 14497275, 20219458, 17733927
     18180541, 18962892, 17292250, 17378618, 16759171, 20110156, 17843489
     17065496, 13991403, 17273020, 17155238, 20012766, 21245437, 18261183
     18053580, 20218012, 17013634, 17886392, 20995001, 17039197, 17947785
     16317771, 10052729, 22353346, 20340620, 16237657, 20317221, 15917869
     18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251
     20246071, 14270845, 20552947, 18882642, 18414137, 17001914, 17927970
     14378120, 16346413, 15986647, 18068871, 21222147, 18143836, 16206997
     21982225, 19168690, 20235511, 18343490, 21875360, 16613232, 19276791
     17722664, 20440643, 12928658, 18952577, 18520351, 16249829, 18226143
     16076412, 18265482, 18229842, 17172091, 20676340, 17818075, 20091753
     18231837, 14373486, 20136892, 17483479, 20551654, 18120545, 18729166
     13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 17087371
     20531190, 14525998, 18187697, 20598625, 14385860, 18348155, 19479503
     12928592, 17516024, 18370031, 17764053, 19272663, 17551223, 14671408
     18272135, 14207615, 21255373, 17500165, 18875012, 14769643, 18464784
     19558324, 18848125, 19241857, 14851828, 17955615, 20315294, 14693336
     16284825, 17352230, 20014326, 17238586, 17089344, 17405605, 21327402
     17531342, 19398098, 17159489, 17640316, 13823394, 16543190, 22024217
     17983675, 20795241, 17598201, 17481314, 16281493, 18346135, 15986311
     19601468, 17208793, 18700935, 18999857, 14076173, 18428146, 18352845
     17435488, 20408163, 17592037, 18352846, 19616601, 17391726, 17387779
     14777968, 15851860, 16206882, 20141091, 21113068, 20175174, 17305100
     15832129, 19885321, 16901346, 17985714, 18536826, 17780903, 18752378
     18946768, 16876500, 16875342, 17769597, 19955755, 16429265, 18336452
     17273003, 17209968, 16988311, 20094984, 19319357, 17059927, 17046460
     18053631, 16867761, 18774591, 21442094, 20235486, 19359787, 15869775
     19642566, 17447588, 16798862, 15920201
Patch  22502456     : applied on Mon May 09 10:46:10 EDT 2016
Unique Patch ID:  19856194
Patch description:  "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
   Created on 21 Mar 2016, 11:49:22 hrs
Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
   Bugs fixed:
     17288409, 21051852, 17811429, 18607546, 17205719, 20506699, 17816865
     17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
     16992075, 17446237, 14015842, 19972569, 21756677, 21538558, 20925795
     17449815, 17375354, 19463897, 13866822, 17982555, 17235750, 17478514
     18317531, 14338435, 18235390, 20803583, 13944971, 20142975, 17811789
     16929165, 18704244, 20506706, 17546973, 20334344, 14054676, 17088068
     17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724
     13951456, 21847223, 16315398, 18744139, 16850630, 19049453, 18673304
     17883081, 19915271, 18641419, 18262334, 17006183, 16065166, 18277454
     16833527, 10136473, 18051556, 17865671, 17852463, 18554871, 17853498
     18334586, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868
     17025461, 11883252, 13609098, 17239687, 17602269, 19197175, 22195457
     18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164
     19393542, 17571306, 18482502, 20777150, 19466309, 17040527, 17165204
     18098207, 16785708, 17465741, 17174582, 16180763, 16777840, 12982566
     19463893, 22195465, 16875449, 12816846, 17237521, 19358317, 17811438
     17811447, 21983325, 17945983, 18762750, 16912439, 17184721, 18061914
     17282229, 18331850, 18202441, 17082359, 18723434, 21972320, 19554106
     14034426, 18339044, 19458377, 17752995, 20448824, 17891943, 17258090
     17767676, 16668584, 18384391, 17040764, 17381384, 15913355, 18356166
     14084247, 20596234, 20506715, 21756661, 13853126, 18203837, 14245531
     21756699, 16043574, 22195441, 17848897, 17877323, 21453153, 17468141
     20861693, 17786518, 17912217, 17037130, 18155762, 16956380, 17478145
     17394950, 18641461, 18189036, 18619917, 17027426, 21352646, 16268425
     22195492, 19584068, 18436307, 17265217, 17634921, 13498382, 21526048
     19258504, 20004087, 17443671, 22195485, 18000422, 20004021, 22321756
     17571039, 21067387, 16344544, 18009564, 14354737, 21286665, 18135678
     18614015, 20441797, 18362222, 17835048, 16472716, 17936109, 17050888
     17325413, 14010183, 18747196, 17761775, 16721594, 17082983, 20067212
     21179898, 17302277, 18084625, 15990359, 18203835, 17297939, 17811456
     16731148, 21168487, 13829543, 17215560, 14133975, 17694209, 17385178
     18091059, 8322815, 17586955, 17201159, 17655634, 18331812, 19730508
     18868646, 17648596, 16220077, 16069901, 17348614, 17393915, 17274537
     17957017, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829
     18328509, 17622427, 22195477, 16943711, 22502493, 14368995, 17346671
     18996843, 17783588, 21343838, 16618694, 17672719, 18856999, 18783224
     17851160, 17546761, 17798953, 18273830, 22092979, 16596890, 19972566
     16384983, 17726838, 17360606, 22321741, 13645875, 18199537, 16542886
     21787056, 17889549, 14565184, 17071721, 17610798, 20299015, 21343897
     22893153, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
     18641451, 12747740, 18430495, 17016369, 17042658, 14602788, 17551063
     19972568, 21517440, 18508861, 19788842, 14657740, 17332800, 13837378
     19972564, 17186905, 18315328, 19699191, 17437634, 22353199, 18093615
     19006849, 19013183, 17296856, 18674024, 17232014, 16855292, 17762296
     14692762, 21051840, 17705023, 19121551, 21330264, 19854503, 21868720
     19309466, 18681862, 18554763, 20558005, 17390160, 18456514, 16306373
     13955826, 18139690, 17501491, 17752121, 21668627, 17299889, 17889583
     18673325, 19721304, 18293054, 17242746, 17951233, 17649265, 18094246
     19615136, 17011832, 16870214, 17477958, 18522509, 20631274, 16091637
     17323222, 16595641, 16524926, 18228645, 18282562, 17596908, 17156148
     18031668, 16494615, 22683225, 17545847, 17655240, 17614134, 13558557
     17341326, 17891946, 17716305, 16392068, 19271443, 21351877, 18092127
     18440047, 17614227, 14106803, 16903536, 18973907, 18673342, 19032867
     17389192, 17612828, 16194160, 17006570, 17721717, 17390431, 17570240
     16863422, 18325460, 19727057, 16422541, 19972570, 17267114, 18244962
     21538485, 18765602, 18203838, 16198143, 17246576, 14829250, 17835627
     18247991, 14458214, 21051862, 16692232, 17786278, 17227277, 16042673
     16314254, 16228604, 16837842, 17393683, 17787259, 20331945, 20074391
     15861775, 16399083, 18018515, 22683212, 18260550, 21051858, 17036973
     16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385
     15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 16285691
     17587063, 21343775, 16538760, 18180390, 18193833, 21387964, 21051833
     17238511, 17824637, 16571443, 18306996, 14852021, 18674047, 17853456
     12364061, 22195448

Node Name : tnc2
----------------
There are no Interim patches installed in this Oracle Home.

Binary & Checksum Information
==============================
 Binary Location : /u01/app/oracle/product/11.2.0/db_1/bin/oracle

 Node            Size            Checksum
 ----            ----            --------
 tnc1        239840518        CA25EF1480C4A31241F7E1D95F9BE47D10B16318882A383FE5A55D584F0620FC

 tnc2        239627031        C2A63A5807C20F7415001E62A0FCFBE93ECED91352A330C24A15C3A544553A62
The binary and checksum values of the following nodes does not match with that of tnc1 (local node) 

tnc2
--------------------------------------------------------------------------------
OPatch Session completed with warnings.
OPatch completed with warnings.


-- Nikhil Tatineni--
-- RAC --