Oracle Study之--Oracle 11g RAC之scan ip访问故障

灰太狼 2022-07-15 07:11 276阅读 0赞

**Oracle Study之--Oracle 11g RAC之scan ip访问**

**系统环境：**

<table> 
 <tbody> 
 <tr> 
 <td style="text-align:center"> </td> 
 <td style="text-align:center">Server</td> 
 <td style="text-align:center">Client </td> 
 </tr> 
 <tr> 
 <td>操作系统</td> 
 <td>RedHat EL5</td> 
 <td>Windows10</td> 
 </tr> 
 <tr> 
 <td>Oracle</td> 
 <td>Oracle 11g(11.2.0.1.0)</td> 
 <td>Oracle 11g (11.2.0.1.0)</td> 
 </tr> 
 </tbody> 
</table>

**一、客户端配置**

**tnsnames.ora：：**

\# tnsnames.ora Network Configuration File: D:\\app\\tiany\\product\\11.2.0\\client\_1\\network\\admin\\tnsnames.ora  
\# Generated by Oracle configuration tools.  
  
 **PROD =  
  (DESCRIPTION =  
    (ADDRESS = (PROTOCOL = TCP)(HOST = scan\_ip)(PORT = 1521))  
    (CONNECT\_DATA =  
      (SERVER = DEDICATED)  
      (SERVICE\_NAME = prod)  
    )  
  )**  
  
客户端连接报错信息：  
  
**C:\\Users\\tiany>sqlplus scott/tiger@prod**  
SQL\*Plus: Release 11.2.0.1.0 Production on 星期日 11月 6 17:25:26 2016  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
ERROR:  
ORA-12545: 因目标主机或对象不存在, 连接失败

**二、服务端配置**

**在server端没有配置DNS服务器，scan ip的解析通过/etc/hosts文件解析：**

**\# cat  /etc/hosts**

**127.0.0.1                           localhost**

**192.168.8.11                       node1**

**192.168.8.13                       node1-vip**

**10.10.10.11                          node1-priv**

**192.168.8.12                       node2**

**192.168.8.14                       node2-vip**

**10.10.10.12                         node2-priv**

**192.168.8.15                        scan\_ip**

**通过metalink查询获悉，在Oracle 11.2.0.1.0的版本有bug需要做以下修改，才能用客户端通过scan ip访问RAC(11.2.0.2.0，已经被修复）**

**三、修改Server配置**

**SQL> alter system set local\_listener='(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.13) (PORT=1521))))' sid='prod1';**  
System altered.  
**SQL> alter system set local\_listener='(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.14)(PORT=1521))))' sid='prod2';  
System altered.  
\------ 将local\_listener中的node-vip 主机名改为ip地址连接，问题解决。**

**四、客户端连接**  
C:\\Users\\tiany>sqlplus scott/tiger@prod  
SQL\*Plus: Release 11.2.0.1.0 Production on 星期日 11月 6 17:34:42 2016  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
连接到:  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production  
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,  
Data Mining and Real Application Testing options  
SQL>  
  
**@连接成功 ！**