客户端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...