3 Node RAC Cluster..TFA Status Only Sees 2 Nodes.
(Doc ID 2751885.1)
Last updated on JULY 20, 2024
Applies to:
Engineered Systems Utilities - Version 12.1.2.8.3 and laterInformation 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
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 |
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 |