10g RAC ORA-12545 on client sometime

gengyonghui

修改hosts文件，修改的是两台集群机器的hosts文件，还是修改最初连接客户端的hosts文件？

lucky_lau

设置local_listener参数即可

guo_li_yuan

最初由 caoxiahui 发布
[B]1、配置参数文件init.ora或spfile：
   remote_listener=LISTENERS_ORCL
2、运行lsnrctl service命令查看服务对应的HOST（hostname.domain_name）  
   在tnsnames.ora文件里配置与lsnrctl service命令看到服务对应的host一致（重要）：
LISTENERS_ORCL =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux1.hnpmi.cn)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux2.hnpmi.cn)(PORT = 1521))
  )
ORCLTEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux1.hnpmi.cn)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux2.hnpmi.cn)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcltest)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )

修改hosts文件:
172.18.0.211                      linux1.hnpmi.cn
172.18.0.212                      linux2.hnpmi.cn [/B]

我改过tns.ora 中将主机名 ，改成虚拟IP