Oracle 集群RAC拒绝连接问题ORA-12545解决

客户端sqlplus和plsql developer连接集群数据库时时常会有ORA-12545错误，几率很高。据称是Oracle的bug。可以通过修改服务器rac1和rac2的数据库初始化参数来解决这个问题。

SQL> sqlplus sys/***@orcl1 as sysdba;

SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.2) (PORT = 1521))' sid='orcl1';
SQL> sqlplus sys/***@orcl2 as sysdba;

SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.0.3) (PORT = 1521))' sid='orcl2';

SQL> conn system/***@172.168.0.2:1521/orcl;

SQL> OK...

SQL> conn system/***@172.168.0.3:1521/orcl;

SQL> OK...