解决办法:
修改数据库中的初始化参数LOCAL_LISTENER
node1
- [oracle@node1~]$sqlplus / as sysdba
- sql>select * from v$instance
- sql>alter system set
- 2 local_listener='(ADDRESS = (PROTOCAL =TCP)(HOST = 172.16.20.132)(PORT = 1521))'
- 3 SID='profdb1';
- [oracle@node2~]$sqlplus / as sysdba
- sql>select * from v$instance
- sql>alter system set
- 2 local_listener='(ADDRESS = (PROTOCAL =TCP)(HOST = 172.16.20.133)(PORT = 1521))'
- 3 SID='profdb2';
再尝试了多次一切正常。