Tuesday, September 13, 2016

TFA not Moved to New GI_HOME while Upgrading from 11.2.0.4 to 12c

Scenario: Upgrading to 12.1.0.2 Grid Infrastructure but TFA wasn't installed in the new GI_HOME: 

>> TFA not Moved to New GI_HOME While Upgrading to 12.1.0.2 (Doc ID 1918428.1)
Follow to fix this issue +

Deinstall TFA from 11.2.0.4 

[root@tnc2 bin]# tfactl uninstall

TFA will be Uninstalled on Node tnc2: 
Removing TFA from tnc2 only
Please remove TFA locally on any other configured nodes

Notifying Other Nodes about TFA Uninstall...
Sleeping for 10 seconds...

Stopping TFA Support Tools...
Stopping TFA in tnc2...

Shutting down TFA
TFA is running  - Will wait 5 seconds (up to 3 times)  
TFA-00002 : Oracle Trace File Analyzer (TFA) is not running
TFA Stopped Successfully
. . . . . 
. . . 
Successfully shutdown TFA..

Deleting TFA support files on tnc2:
Removing /u01/app/oracle/tfa/tnc2/database...
Removing /u01/app/oracle/tfa/tnc2/log...
Removing /u01/app/oracle/tfa/tnc2/output...
Removing /u01/app/oracle/tfa/tnc2...
Removing /u01/app/oracle/tfa...
Removing /etc/rc.d/rc0.d/K17init.tfa
Removing /etc/rc.d/rc1.d/K17init.tfa
Removing /etc/rc.d/rc2.d/K17init.tfa
Removing /etc/rc.d/rc4.d/K17init.tfa
Removing /etc/rc.d/rc6.d/K17init.tfa
Removing /etc/init.d/init.tfa...
Removing /u01/app/11.2.0.4/grid/bin/tfactl...
Removing /u01/app/11.2.0.4/grid/tfa/bin...
Removing /u01/app/11.2.0.4/grid/tfa/tnc2...

Install TFA as root user on new 12.1.0.2 Cluster Home + 

Syntax #
<NEW_GI_HOME>/crs/install/tfa_setup -silent -crshome <NEW_GI_HOME

/u01/app/12.1.0.2/grid/crs/install/tfa_setup -silent -crshome /u01/app/12.1.0.2/grid
>>>
[root@tnc2 grid]# /u01/app/12.1.0.2/grid/crs/install/tfa_setup -silent -crshome /u01/app/12.1.0.2/grid

Starting TFA installation
Using JAVA_HOME : /u01/app/12.1.0.2/grid/jdk/jre

Running Auto Setup for TFA as user root...
Installing TFA now...

TFA Will be Installed on tnc2...
TFA will scan the following Directories
++++++++++++++++++++++++++++++++++++++++++++

.------------------------------------------------------.
|                         tnc2                         |
+-------------------------------------------+----------+
| Trace Directory                           | Resource |
+-------------------------------------------+----------+
| /u01/app/12.1.0.2/grid/OPatch/crs/log     | CRS      |
| /u01/app/12.1.0.2/grid/cfgtoollogs        | CFGTOOLS |
| /u01/app/12.1.0.2/grid/crs/log            | CRS      |
| /u01/app/12.1.0.2/grid/cv/log             | CRS      |
| /u01/app/12.1.0.2/grid/evm/admin/log      | CRS      |
| /u01/app/12.1.0.2/grid/evm/admin/logger   | CRS      |
| /u01/app/12.1.0.2/grid/evm/log            | CRS      |
| /u01/app/12.1.0.2/grid/install            | INSTALL  |
| /u01/app/12.1.0.2/grid/log                | CRS      |
| /u01/app/12.1.0.2/grid/network/log        | CRS      |
| /u01/app/12.1.0.2/grid/oc4j/j2ee/home/log | DBWLM    |
| /u01/app/12.1.0.2/grid/opmn/logs          | CRS      |
| /u01/app/12.1.0.2/grid/racg/log           | CRS      |
| /u01/app/12.1.0.2/grid/rdbms/log          | ASM      |
| /u01/app/12.1.0.2/grid/scheduler/log      | CRS      |
| /u01/app/12.1.0.2/grid/srvm/log           | CRS      |
| /u01/app/oraInventory/ContentsXML         | INSTALL  |
| /u01/app/oraInventory/logs                | INSTALL  |
| /u01/app/oracle/crsdata/tnc2/acfs         | ACFS     |
| /u01/app/oracle/crsdata/tnc2/core         | CRS      |
| /u01/app/oracle/crsdata/tnc2/crsconfig    | CRS      |
| /u01/app/oracle/crsdata/tnc2/crsdiag      | CRS      |
| /u01/app/oracle/crsdata/tnc2/cvu          | CRS      |
| /u01/app/oracle/crsdata/tnc2/evm          | CRS      |
| /u01/app/oracle/crsdata/tnc2/output       | CRS      |
| /u01/app/oracle/crsdata/tnc2/trace        | CRS      |
'-------------------------------------------+----------'

Installing TFA on tnc2:
HOST: tnc2 TFA_HOME: /u01/app/12.1.0.2/grid/tfa/tnc2/tfa_home
.------------------------------------------------------------------------.
| Host | Status of TFA | PID  | Port | Version    | Build ID             |
+------+---------------+------+------+------------+----------------------+
| tnc2 | RUNNING       | 3679 | 5000 | 12.1.2.0.0 | 12120020140619094932 |
'------+---------------+------+------+------------+----------------------'
Running Inventory in All Nodes...
Enabling Access for Non-root Users on tnc2...
Adding default users and groups to TFA Access list...

Summary of TFA Installation:
.----------------------------------------------------------------.
|                              tnc2                              |
+---------------------+------------------------------------------+
| Parameter           | Value                                    |
+---------------------+------------------------------------------+
| Install location    | /u01/app/12.1.0.2/grid/tfa/tnc2/tfa_home |
| Repository location | /u01/app/oracle/tfa/repository           |
| Repository usage    | 0 MB out of 6247 MB                      |
'---------------------+------------------------------------------'
Installing oratop extension..
TFA is successfully installed...

Usage : /u01/app/12.1.0.2/grid/bin/tfactl <command> [options]
<command> =
          start        Starts TFA
          stop         Stops TFA
          enable       Enable TFA Auto restart
          disable      Disable TFA Auto restart
          print        Print requested details
          access       Add or Remove or List TFA Users and Groups
          purge        Delete collections from TFA repository
          directory    Add or Remove or Modify directory in TFA
          host         Add or Remove host in TFA
          diagcollect  Collect logs from across nodes in cluster
          analyze      List events summary and search strings in alert logs.
          set          Turn ON/OFF or Modify various TFA features
          uninstall    Uninstall TFA from this node

For help with a command: /u01/app/12.1.0.2/grid/bin/tfactl <command> -help

[oracle@tnc2 TFA]$ tfactl print status
.--------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID   | Port | Version    | Build ID             | Inventory Status |
+------+---------------+-------+------+------------+----------------------+------------------+
| tnc2 | RUNNING       |  3679 | 5000 | 12.1.2.0.0 | 12120020140619094932 | COMPLETE         |
| tnc1 | RUNNING       | 12158 | 5000 | 12.1.2.0.0 | 12120020140619094932 | COMPLETE         |
'------+---------------+-------+------+------------+----------------------+------------------'

[oracle@tnc2 TFA]$ crsctl query crs softwareversion
Oracle Clusterware version on node [tnc2] is [12.1.0.2.0]


>>>>>>

--Nikhil Tatineni--
--RAC--

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...