How to get all nodes to show when running tfactl print status? Currently only two of the fours nodes are displayed.
.------------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+---------------+---------------+--------+------+------------+----------------------+------------------+
| racnode1 | RUNNING | 181861 | 5000 | 12.1.2.8.4 | 12128420161122101422 | COMPLETE |
| racnode2 | RUNNING | 184825 | 5000 | 12.1.2.8.4 | 12128420161122101422 | COMPLETE |
'---------------+---------------+--------+------+------------+----------------------+------------------'
racnode1:~ # tfactl print hosts
Host Name : racnode1
Host Name : racnode2
Host Name : racnode3
Host Name : racnode4
In the TFA logs you will see an SSL Handshake error such as:
2017-03-30 14:12:27.585 [ERROR] [Thread-4771] SSLHandshake Failed. Cannot process request from host : racnode<n>
SOLUTION
(on racnode1)
# tfactl host remove racnode<n>
(on racnode<n>)
# tfactl shutdown <----IMPORTANT!
(on racnode1)
$ copy client.jks and server.jks from racnode1 TFA_HOME to racnode<n> TFA_HOME
How to find TFA_HOME?: $ ps -ef | grep tfa
root 29091 1 0 Apr11 ? 00:37:38 /u01/app/12.1.0/grid/jdk/jre/bin/java -Xms128m -Xmx512m oracle.rat.tfa.TFAMain /u01/app/12.1.0/grid/tfa/racnode1/tfa_home <---------TFA_HOME Directory
$ cd /u01/app/12.1.0/grid/tfa/racnode1/tfa_home
copy TFA_HOME/internal ssl.properties from racnode1 to racnode<n>
(on racnode<n>)
# tfactl start
Verify node is now showing in status:
# ./tfactl print status
.--------------------------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+---------------+----------------+------+-------+------------+-----------------------------+--------------------+
| racnode1 | RUNNING | 1669 | 5000 | 12.1.2.8.4 | 12128420170206111019 | COMPLETE |
| racnode2 | RUNNING | 1669 | 5000 | 12.1.2.8.4 | 12128420170206111019 | COMPLETE |
| racnode<n> | RUNNING | 1669 | 5000 | 12.1.2.8.4 | 12128420170206111019 | COMPLETE |
'----------------+----------------+------+-------+------------+-----------------------------+--------------------'
注意检查/etc/hosts中的主机名配置,防止127.0.0.1对应配错主机名,导致两边无法联通。
例如:
[root@rac1 tfa_home]# cat /etc/hosts
127.0.0.1 localhost localhost4 localhost4.localdomain4 #之前发现有这个地方配置了rac1导致status无法获取到其它节点状态
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
#public
192.168.19.59 rac1
192.168.19.60 rac2
#vip
192.168.19.61 rac1-vip
192.168.19.62 rac2-vip
#priv
10.168.0.59 rac1-priv
10.168.0.60 rac2-priv
#scan
192.168.19.63 rac-scan
错误的状态:
正确的状态如下:
修改完/etc/hosts后,tfactl shutdown并检查ps -ef|grep tfa,确保两节点都已经没有tfa进程,再tfactl start即可
如果需要添加则用tfactl host add rac2命令
[root@rac1 tfa_home]# /oracle/app/12.2.0/grid/bin/tfactl status
WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
.--------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+------+---------------+-------+------+------------+----------------------+------------------+
| rac1 | RUNNING | 12870 | 5000 | 19.2.0.0.0 | 19200020190426044818 | COMPLETE |
| rac2 | RUNNING | 6294 | 5000 | 19.2.0.0.0 | 19200020190426044818 | COMPLETE |
'------+---------------+-------+------+------------+----------------------+------------------'