Thinking Out Loud

December 18, 2015

TFA installed as part of 21523375 (Oct2015 CPU)

Filed under: 11g,oracle,RAC — mdinh @ 7:01 pm

+++ Patch 21523375 – Oracle Grid Infrastructure Patch Set Update 11.2.0.4.8 (Oct2015) (Includes Database PSU 11.2.0.4.8)
+++ Case 1: GI Home and the Database Homes that are not shared and ACFS file system is not configured.

After the completion of Patch 21523375, TFA was installed.

If you need to shutdown processes running from grid, TFA will need to be stopped as well (# /etc/init.d/init.tfa stop) since crsctl stop crs does not stop TFA.

I ***incorrectly*** tweeted that start crs starts TFA.

TFA was started from patch apply.

Interested to see what happens in the next patching cycle.

[root@rac02:/root]
# $ORACLE_HOME/OPatch/opatch auto /u01/app/grid/patches/21744348/21523375 -ocmrf /tmp/ocm.rsp
Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/crs/patch11203.pl -patchdir /u01/app/grid/patches/21744348 -patchn 21523375 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2015-12-18_08-18-46.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2015-12-18_08-18-46.report.log

2015-12-18 08:18:46: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0.4/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0.4/db_1 successfully

patch /u01/app/grid/patches/21744348/21523375/21352635  apply successful for home  /u01/app/oracle/product/11.2.0.4/db_1
patch /u01/app/grid/patches/21744348/21523375/21352649/custom/server/21352649  apply successful for home  /u01/app/oracle/product/11.2.0.4/db_1

Stopping CRS...
Stopped CRS successfully

patch /u01/app/grid/patches/21744348/21523375/21352635  apply successful for home  /u01/app/11.2.0.4/grid
patch /u01/app/grid/patches/21744348/21523375/21352649  apply successful for home  /u01/app/11.2.0.4/grid
patch /u01/app/grid/patches/21744348/21523375/21352642  apply successful for home  /u01/app/11.2.0.4/grid

Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0.4/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0.4/db_1 successfully

opatch auto succeeded.
[root@rac02:/root]
#

[root@rac02:/root]
# ps -ef|grep tfa
root     11017     1  0 08:28 ?        00:00:00 /bin/sh /etc/init.d/init.tfa run
root     12980 12756  0 10:35 pts/0    00:00:00 grep tfa
root     26988     1  1 08:31 ?        00:01:33 /u01/app/11.2.0.4/grid/jdk/jre/bin/java -Xms128m -Xmx512m -classpath /u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/RATFA.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/je-5.0.84.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/ojdbc5.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/commons-io-2.1.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0.4/grid/tfa/rac02/tfa_home

[root@rac02:/root]
# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac02'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac02'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac02'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac02' has completed
CRS-4133: Oracle High Availability Services has been stopped.

[root@rac02:/root]
# ps -ef|egrep 'oracle|grid|agent'
gdm       2968  2926  0 06:11 ?        00:00:00 /usr/libexec/polkit-gnome-authentication-agent-1
root     14811 12756  0 10:39 pts/0    00:00:00 egrep oracle|grid|agent
root     26988     1  1 08:31 ?        00:01:36 /u01/app/11.2.0.4/grid/jdk/jre/bin/java -Xms128m -Xmx512m -classpath /u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/RATFA.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/je-5.0.84.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/ojdbc5.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/commons-io-2.1.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0.4/grid/tfa/rac02/tfa_home

TFA needs to be stopped manually

[root@rac02:/root]
# /etc/init.d/init.tfa stop
Stopping TFA
TFA-00002 : Oracle Trace File Analyzer (TFA) is not running
TFAmain Force Stopped Successfully
Killing TFA running with pid 26988
. . .
Successfully stopped TFA..
[root@rac02:/root]
# ps -ef|egrep 'oracle|grid|agent'
gdm       2968  2926  0 06:11 ?        00:00:00 /usr/libexec/polkit-gnome-authentication-agent-1
root     15141 12756  0 10:40 pts/0    00:00:00 egrep oracle|grid|agent
[root@rac02:/root]
# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

[root@rac02:/root]
# ps -ef|grep -i tfa
root     11017     1  0 08:28 ?        00:00:00 /bin/sh /etc/init.d/init.tfa run
root     16558 12756  0 10:42 pts/0    00:00:00 grep -i tfa

TFA needs to be started manually

[root@rac02:/root]
# /etc/init.d/init.tfa start
Starting TFA..
start: Job is already running: oracle-tfa
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
[root@rac02:/root]
# ps -ef|grep -i tfa
root     11017     1  0 08:28 ?        00:00:00 /bin/sh /etc/init.d/init.tfa run
root     16739     1 99 10:43 ?        00:00:13 /u01/app/11.2.0.4/grid/jdk/jre/bin/java -Xms128m -Xmx512m -classpath /u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/RATFA.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/je-5.0.84.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/ojdbc5.jar:/u01/app/11.2.0.4/grid/tfa/rac02/tfa_home/jlib/commons-io-2.1.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0.4/grid/tfa/rac02/tfa_home
root     16938 12756  0 10:43 pts/0    00:00:00 grep -i tfa
[root@rac02:/root]

TFA does not have a status and needs to be checked using ps -ef

[root@rac02:/root]
# /etc/init.d/init.tfa
Usage: /etc/init.d/init.tfa {stop|start|shutdown|restart}
[root@rac02:/root]
#

UPDATE: Dec 19 2015

[grid@rac01:+ASM1:/home/grid]
$ echo $ORACLE_BASE
/u01/app/grid
[grid@rac01:+ASM1:/home/grid]
$ cd $ORACLE_BASE

TFA directory beneath grid $ORACLE_BASE

[grid@rac01:+ASM1:/u01/app/grid]
$ ll
total 36
drwxrwxr-x. 4 grid   oinstall 4096 Nov 30  2014 cfgtoollogs
drwxrwxr-x. 2 grid   oinstall 4096 Nov 30  2014 checkpoints
drwxrwxr-x. 2 grid   oinstall 4096 Nov 30  2014 Clusterware
drwxrwxr-x. 4 grid   oinstall 4096 Nov 30  2014 diag
drwxrwxr-x. 3 oracle oinstall 4096 Dec  4  2014 oradiag_oracle
drwxrwxr-x. 3 root   root     4096 Dec  1  2014 oradiag_root
drwxrwxr-x. 3 grid   oinstall 4096 Nov 30  2014 rac01
drwxr-x--x. 4 root   root     4096 Nov 30  2014 tfa
drwxrwxr-x. 9 grid   oinstall 4096 Dec 18  2014 xag
[grid@rac01:+ASM1:/u01/app/grid]
$ cd tfa/
[grid@rac01:+ASM1:/u01/app/grid/tfa]
$ ll
ls: cannot open directory .: Permission denied
[grid@rac01:+ASM1:/u01/app/grid/tfa]
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: