My Oracle Support Banner

3 Node RAC Cluster..TFA Status Only Sees 2 Nodes. (Doc ID 2751885.1)

Last updated on APRIL 17, 2023

Applies to:

Engineered Systems Utilities - Version 12.1.2.8.3 and later
Information in this document applies to any platform.

Symptoms

The tfactl status only displays 2 nodes out of 3 nodes when the command is executed as the grid user

 

 

ODM Issue Verification
As that grid user ,you will see that on:
1) 471, only 471, 472 are shown - so 473 is missing
2) 472, only 472, 471 are shown - so 473 is missing
3) 473, only 471, 473 are shown - so 472 is missing

prod:grid@a471:~ $ tfactl status
.---------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------------+---------------+--------+------+------------+----------------------+------------------+
| a471 | RUNNING | 5248 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a472 | RUNNING | 125212 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
'------------+---------------+--------+------+------------+----------------------+------------------'

prod:grid@a472:~ $ tfactl status
.---------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------------+---------------+--------+------+------------+----------------------+------------------+
| a472 | RUNNING | 125212 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a471 | RUNNING | 5248 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
'------------+---------------+--------+------+------------+----------------------+------------------'

prod:grid@a473:~ $ tfactl status
.--------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------------+---------------+-------+------+------------+----------------------+------------------+
| a473 | RUNNING | 26436 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a471 | RUNNING | 5248 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |



On all 3 servers, the user GRID, sees all 3 nodes with olsnodes -n

prod:grid@a471:~ $ olsnodes -n
a471 1
a472 2
a473 3

prod:grid@a472:~ $ olsnodes -n
a471 1
a472 2
a473 3

prod:grid@a473:~ $ olsnodes -n
a471 1
a472 2
a473 3


As the root user:

prod:root@a471:~ # tfactl status

.---------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------------+---------------+--------+------+------------+----------------------+------------------+
| a471 | RUNNING | 5248 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a472 | RUNNING | 125212 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a473 | RUNNING | 26436 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
'------------+---------------+--------+------+------------+----------------------+------------------'
14:23:36 prod:root@a472:~ # tfactl status

.---------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------------+---------------+--------+------+------------+----------------------+------------------+
| a472 | RUNNING | 125212 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a471 | RUNNING | 5248 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a473 | RUNNING | 26436 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
'------------+---------------+--------+------+------------+----------------------+------------------'
14:27:16 prod:root@a473:~ # tfactl status

.---------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------------+---------------+--------+------+------------+----------------------+------------------+
| a473 | RUNNING | 26436 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a471 | RUNNING | 5248 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
| a472 | RUNNING | 125212 | 5000 | 20.4.0.0.0 | 20400020201214101756 | COMPLETE |
'------------+---------------+--------+------+------------+----------------------+------------------'




prod:root@a471:~ # tfactl access lsusers
.--------------------------------.
| TFA Users in a471 |
+-----------+---------+----------+
| User Name | Status | Promoted |
+-----------+---------+----------+
| grid | Allowed | true |
| oracle | Allowed | true |
'-----------+---------+----------'

.--------------------------------.
| TFA Users in a472 |
+-----------+---------+----------+
| User Name | Status | Promoted |
+-----------+---------+----------+
| grid | Allowed | true |
| oracle | Allowed | true |
'-----------+---------+----------'

.--------------------------------.
| TFA Users in a473 |
+-----------+---------+----------+
| User Name | Status | Promoted |
+-----------+---------+----------+
| grid | Allowed | true |
| oracle | Allowed | true |

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.