addnode gave PRCF-2023 : The following contents are not transferred as they are non-readable.

While adding a node to an existing four node cluster, got the following error.

Copying to remote nodes (Monday, May 20, 2013 8:37:18 AM EDT)
.........................................................................
WARNING:Error while copying directory /usr/local/opt/oracle/product/11.2.0.3 with exclude file list '/tmp/OraInstall2013-05-20_08-36-45AM/installExcludeFile.lst' 
to nodes 'myrac6d5'. [PRKC-PRCF-2015 : One or more commands were not executed successfully on one or more nodes : <null>]
----------------------------------------------------------------------------------
nmsis6d5:
PRCF-2023 : The following contents are not transferred as they are non-readable.
Directories:
-
Files:
1) /usr/local/opt/oracle/product/11.2.0.3/root.sh_11203

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

Refer to '/usr/local/opt/oracle/product/oraInventory/logs/addNodeActions2013-05-20_08-36-45AM.log' for details. 
You may fix the errors on the required remote nodes. Refer to the install guide for error recovery.

The issue in this case was the file permission on the file root.sh_11203

Solution
========
Fix the file permission so that its readable by the user owning the ORACLE_HOME and re-run the add_node command.

SQL Scripts to find TEMP tablespace usage

Here are various scripts which helps in determining who's using the TEMP tablespace.

Script 1

select a.inst_id,b.Total_MB, b.Total_MB - round(a.used_blocks*8/1024) Current_Free_MB,        
round(used_blocks*8/1024) Current_Used_MB, round(max_used_blocks*8/1024)             
Max_used_MB from gv$sort_segment a,  
(select round(sum(bytes)/1024/1024) Total_MB from dba_temp_files ) b; 

Script 2

SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text
FROM gv$session a, gv$tempseg_usage b, gv$sqlarea c
WHERE a.saddr = b.session_addr
AND c.address= a.sql_address
AND c.hash_value = a.sql_hash_value
ORDER BY b.tablespace, b.blocks

Script 3

select s.sid, s.osuser, s. process, s.sql_id, tmp.segtype, ((tmp.blocks*8)/1024)MB, tmp.tablespace
from gv$tempseg_usage tmp, gv$session s
where tmp.session_num=s.serial# and segtype in ('HASH','SORT')
order by blocks desc;

Script 4

select sql_id,sum(blocks) from gv$tempseg_usage group by sql_id order by 2 desc;

Useful Oracle Notes in reference to TEMP Tablespace

How Can Temporary Segment Usage Be Monitored Over Time? (Doc ID 364417.1)

TROUBLESHOOTING GUIDE (TSG) : ORA-1652: unable to extend temp segment [ID 1267351.1]

Generate AWR report for a particular SQL

Once you have identified that a particular SQL is causing issues, you can generate the AWR report for a particular SQL between two specific snap_id's for further analysis. SQL "awrsqrpt.sql" is located under $ORACLE_HOME/rdbms/admin

$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 66397
Begin Snapshot Id specified: 66397

Enter value for end_snap: 66398
End   Snapshot Id specified: 66398

Specify the SQL Id
~~~~~~~~~~~~~~~~~~
Enter value for sql_id: 8p6wy9fr8m0sn
SQL ID specified:  8p6wy9fr8m0sn

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrsqlrpt_2_66397_66398.html.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrsqlrpt_2_66397_66398.html

awrsqlrpt_2_66397_66398.html => This report gives lot of good information about that particular SQL including the Plan Statistics and EXECUTION PLAN