RAC Node Pinning & Unpinning

sam1374:CADP3>olsnodes -n -t -s

sam1372      1       Active  Unpinned

sam1373      2       Active  Unpinned

sam1374      3       Active  Unpinned

sam1374:CADP3>

There is so much we learn every day. One of such is leanred today is pinning and unpinning of RAC node.

Pinning a node means that the association of a node name with a node number is fixed. If a node is not pinned, its node number may change if the lease expires while it is down. The lease of a pinned node never expires.

This concept is active since version 11.2. When we do fresh installtion Clusterware do it for us. For the clusterware which are upgraded from lower version, can be pinned by :  crsctl pin css -n node3 node4

I'm still in phase to understand advantage/dis-advantage of pinning and unpinning the node.

OPatch cleanup

[oracle@localhost OPatch]$ ./opatch util Cleanup

Oracle Interim Patch Installer version 12.1.0.1.0

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/home/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/home/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 12.1.0.1.0

OUI version       : 12.1.0.1.0

Log file location : /u01/home/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-02-15_07-53-51AM_1.log

Invoking utility "cleanup"

OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.

You will be still able to rollback patches after this cleanup.

Do you want to proceed? [y|n]

y

User Responded with: Y

Size of directory "/u01/home/oracle/product/11.2.0/db_1/.patch_storage" before cleanup is 227169947 bytes.

Size of directory "/u01/home/oracle/product/11.2.0/db_1/.patch_storage" after cleanup is 227169947 bytes.

UtilSession: Backup area for restore has been cleaned up. For a complete list of files/directories

deleted, Please refer log file.

OPatch succeeded.

[oracle@localhost OPatch]$